Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - rgorantla

Pages: [1] 2
Help for ParamQuery Pro / Data Loading taking long time
« on: October 30, 2017, 10:49:45 pm »

Have 1000 rows and 129 columns. if i load 350 rows it it taking 3 sec but more than that it is taking long time.(20-30 sec)

SQL - 500 ms - so no issue there. I think the problem is - long json  taking time in datamodel.

Any thoughts?

How do we load chunks of data and append later?

Help for ParamQuery Pro / AutoSave State?
« on: October 12, 2017, 07:35:41 am »

Is there a way to save the state automatically when columns are shown/hidden and/or when columns are dragged?

Help for ParamQuery Pro / Fill for select list
« on: October 11, 2017, 11:47:19 pm »
Hi ,

I have a select list with an Id mapped to different column similar to what you have in demo.

in this demo: select 1 from column A - column b,c,d populate

Now fill the 2nd row,3rd row with 1st row in column A - column A get populated for both rows but not b,c

Any solution?

Please tell me what is wrong - it works fine in chrome but not in IE.

In Create : I have loadStateSuccess = loadState(this); and the function that loads data from db is below:

function loadState(grid) {
            data: params,
            type: 'GET',
            dataType: 'json',
            success: function (json) {
                if ( != null)
                    var colModel =;
                    grid.loadState({ state: colModel });
            error: function (xhr, status) {
            complete: function (xhr, status) {

Help for ParamQuery Pro / Drag column - not working :(
« on: September 27, 2017, 02:11:30 am »

Have a select list in my colmodel and i want that to be draggable - please let me knwo what am i missing  :'(
here is my colmodel:
            title: "Companyname", dataIndx: "Companyname", width: 100, draggable: true,
            editor: {
                type: 'select',
                valueIndx: "value",
                labelIndx: "text",
                options: [],
                mapIndices: { "text": "Companyname", "value": "CompanyId" }
            validations: [{ type: 'minLen', value: 1, msg: "Required" }]
            filter: { type: 'textbox', condition: 'contain', listeners: ['keyup'] }

Here is my pqgrid obj:
        width: "100%",
        height: 425,
        dataModel: dataModel,
        copy: false,
        fillHandle: 'vertical',
        filterModel: { type: 'local', header: true }, //on: true, mode: "AND",
        pasteModel: { on: false },
        scrollModel: { lastColumn: null },
        colModel: columns,
        editModel: {
            clicksToEdit: 1
        selectionModel: { column: true },
        numberCell: false,
        freezeCols: 1,
        resizable: true     


Help for ParamQuery Pro / Dynamic colModel from database
« on: August 23, 2017, 06:36:16 pm »
Instead of writing the colmodel - I am trying to make it dynamic i.e.e, to get the complete col-model from database.

ex: if there are new columns next year, i do not want to edit the JavaScript instead if i add a column in database with necessary properties - i should be able to get it with inline functions,etc...

Any way to do this?

Help for ParamQuery Pro / Couple of Questions
« on: August 02, 2017, 12:15:57 am »
1. Save State and load State from database:
    I am trying to save and load columns /Column Model to and from Database on to the Grid.Also, after re-ordering - would like to save it to database.
    Local storage is working fine but not database.

2. show/hide columns : when we select a column to hide or unhide can we push those to the end

Bug Report / Do not show selected options but show default
« on: July 05, 2017, 11:49:43 pm »

I am using pqselect to shos/hide columns. But we do not want to see the column names again(please see optionsselected image). Instead show a "text" everytime

Another Question :

I set maxselect as 2 , sleected options do not show more than 2 but i can still check  the other options. If the maxselected is reached- we shouldn't be able to check too.
Any workaround for that?

ParamQuery Pro Evaluation Support / Saving remote data
« on: January 05, 2015, 09:15:30 pm »
Hi ,

I have remote Json data (3 rows) - i change data in those 3 rows and click save - Update list doesnt have any data

But if i create new rows and click save - list have data for those new rows .

Can you tell me what am i missing here?

Help for ParamQuery Pro / Dropdowns
« on: January 05, 2015, 09:11:40 pm »

Happy New Year!

I have JSON data returning text and value - how do i display text in dropdowns ? I also need value of it but hidden

Help for ParamQuery Pro / Expand or overlay the Grid
« on: November 07, 2014, 02:05:48 am »

is there a way to have a button in grid and when clicked on it it can expand the grid(like an overlay) ?

ex: Maximize and Minimize the Grid

Help for ParamQuery Pro / Redo issue and New row issues
« on: October 16, 2014, 12:06:37 am »
Please take a look at the fiddle :

Try adding few rows and do undo - until you have no rows

Now click on redo - you will receive an error "Cannot read property '0' of undefined "

Something when you click on add new row.

Can you help me on what am i doing wrong?


Resolved all other issues i was having before - only 1 requirement -

If i change funding value to SI - admin fees columns become editable - I am trying to write a validation call back to make basic admin fee and total admin fee as required when the cell is editable ... I am not able to accomplish this ... Can you help me with an example on how to do this please?

Also, if you can tell me if there is any way to add tootltip like we add class

Ex:  $grid.pqGrid("addClass", { rowIndx: rowIndx, dataIndx: dataIndx, cls: 'yellow' });

Thanks much !

Help for ParamQuery Pro / Read only cells - Pasting issue
« on: October 15, 2014, 02:25:26 am »

Read only cells are working fine when you edit in grid - but when you are trying to copy and paste - values are not pasting though the dependency condition is true ...

Help for ParamQuery Pro / Rendering Cells
« on: October 13, 2014, 09:27:30 pm »
Rendering Cells not working when i am pasting cells.

    obj.cellSave = function (evt, ui) {

        $(this).pqGrid('refreshRow', { rowIndx: ui.rowIndx });
        var ratesarray = ["rateeeonly", "rateeeplusoneonly", "rateeeplus2", "rateeepluschildren", "rateeeplusspouse", "rateeefamily"];
        var contributionsarray = ["contreeonly", "contreeplusoneonly", "contreeplus2", "contreepluschildre", "contreeplusspouse", "contreefamily"]
        if (!($.inArray(ui.dataIndx, ratesarray) == -1)) {
            $(this).pqGrid("refreshCell", { rowIndx: ui.rowIndx, dataIndx: ui.dataIndx });
        if (!($.inArray(ui.dataIndx, contributionsarray) == -1)) {
            $(this).pqGrid("refreshCell", { rowIndx: ui.rowIndx, dataIndx: ui.dataIndx });


  contributionvalidations(ui) and rateContribution assign colors based on values entered..

Since save key is tab - when you tab on that cell it works - but when you try to paste colors are not displayed .

I need this to be Fixed ASAP . can you please help ?

Pages: [1] 2