ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: nzxgq0 on March 11, 2020, 11:18:45 pm

Title: Any way to load data after user clicks a search button on the tool bar
Post by: nzxgq0 on March 11, 2020, 11:18:45 pm

Hello,

I read the examples but found none to resolve this case:
when the page is loaded the first time, the grid just shows the empty table defined by the colModel.
When user clicks a search button on the toolbar, it starts to make the ajax call to load the dataModel and then fresh the grid.

Because we have millions of records in the DB (looks we have to apply remote filtering, paging and sorting rather than local) and it will be reasonable to show the grid after user fires the command.

Thanks in advance.

Title: Re: Any way to load data after user clicks a search button on the tool bar
Post by: paramvir on March 12, 2020, 09:29:05 am

refreshDataAndView() method is used to load or reload the data ( local or remote ) in the grid. When data location is remote, then grid automatically sends filter/ sorting/paging parameters along with remote request initiated by refreshDataAndView.

filter() method can also be used to reload data in case of remote filtering, when you want to send custom filter parameters. Example: https://paramquery.com/pro/demos/filter

So in listener of search button on toolbar, you can call either refreshDataAndView or filter method.

Title: Re: Any way to load data after user clicks a search button on the tool bar
Post by: nzxgq0 on March 12, 2020, 08:41:27 pm

Quote from: paramvir on March 12, 2020, 09:29:05 am

refreshDataAndView() method is used to load or reload the data ( local or remote ) in the grid. When data location is remote, then grid automatically sends filter/ sorting/paging parameters along with remote request initiated by refreshDataAndView.

filter() method can also be used to reload data in case of remote filtering, when you want to send custom filter parameters. Example: https://paramquery.com/pro/demos/filter

So in listener of search button on toolbar, you can call either refreshDataAndView or filter method.

I know these. Thanks for the reply.
However what I want is that the grid doesn't have itself populated with data until user clicks the button.
Currently, all the examples have the grid populated with data when the page loads for the first time.

Title: Re: Any way to load data after user clicks a search button on the tool bar
Post by: paramvir on March 12, 2020, 09:42:55 pm

Quote

However what I want is that the grid doesn't have itself populated with data until user clicks the button.

Set initial dataModel.location to "local" and don't assign any data to grid. When button is clicked, set dataModel.location to "remote" and call refreshDataAndView()

Title: Re: Any way to load data after user clicks a search button on the tool bar
Post by: nzxgq0 on March 23, 2020, 12:50:45 pm

Quote from: paramvir on March 12, 2020, 09:42:55 pm

Quote

However what I want is that the grid doesn't have itself populated with data until user clicks the button.

Set initial dataModel.location to "local" and don't assign any data to grid. When button is clicked, set dataModel.location to "remote" and call refreshDataAndView()

Hello, this approach does work. However it has another issue that the widths of the columns don't refresh but remain the same. Any idea? Thanks.

Title: Re: Any way to load data after user clicks a search button on the tool bar
Post by: paramvir on March 23, 2020, 05:17:37 pm

refreshDataAndView doesn't change width of columns.

Please use flex, refreshCM methods or Columns API to alter width of the columns.

https://paramquery.com/pro/api#method-flex

https://paramquery.com/pro/api#method-Columns