ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: entwine.llc.wi on August 31, 2022, 07:34:56 am

Title: Creating a criteria panel
Post by: entwine.llc.wi on August 31, 2022, 07:34:56 am

Is it possible to create a panel to the side or top of the page that contains all of the criteria fields? My client would like a panel layout versus having to go across all the columns to view/change criteria.

I was thinking this might be possible using CSS, or perhaps by looping through all the columns using code, but I'm not sure how to do it.

Title: Re: Creating a criteria panel
Post by: paramvir on August 31, 2022, 10:52:18 am

can you please share a screenshot of the desired functionality and the feature you are referring to. Do you mean by criteria for filtering.

Title: Re: Creating a criteria panel
Post by: entwine.llc.wi on September 01, 2022, 08:14:02 am

Hi,

The attached image is just the basic concept.

Ideally, I would end up with your filter row organized vertically, in an accordion which is divided by column group. The user would be able to alter the filter type for given columns and so on.

An alternative would be to have a drop-down where they could select a field, then add criteria for that field. They could then add another field and so on. It would still be nice to be able to select the type of criteria to use for each field (gte, lte, etc).

You have done such an excellent job creating the filtering capabilities that it is almost impossible to duplicate what you have right now.

My clients deal with large grids with hundreds of columns, and it is difficult to scroll across and find the proper columns.

I appreciate your assistance with this.

Title: Re: Creating a criteria panel
Post by: entwine.llc.wi on September 20, 2022, 03:08:22 am

Hi,

I was just wondering if there was any news on this question. 

I was looking at your demos and thought perhaps I could use a technique like is used here: https://paramquery.com/pro/demos/filter (https://paramquery.com/pro/demos/filter)

Is that the best way to approach this?

Regards

Title: Re: Creating a criteria panel
Post by: paramvir on September 23, 2022, 05:44:35 pm

Thanks for your feedback, it's being added in the upcoming version.

If you want to develop it yourself, then you can take help of grid API

grid.getColModel() to get get column list.
https://paramquery.com/pro/api#method-getColModel

grid.filter() method to filter the records in grid.
https://paramquery.com/pro/api#method-filter

Title: Re: Creating a criteria panel
Post by: entwine.llc.wi on September 24, 2022, 12:59:44 am

Thank you! I'm sure your version will be better than mine, but I will probably give it a go myself as well.

Title: Re: Creating a criteria panel
Post by: entwine.llc.wi on May 28, 2023, 01:04:49 am

I was wondering if there is any news on this. I have looked in the new versions and am unable to find the desired functionality. At one point you mentioned you would add it. Is that still the plan?
Thanks

Title: Re: Creating a criteria panel
Post by: paramvir on May 29, 2023, 10:44:57 pm

It's in the plan and it would be released probably in 9.1.0

Title: Re: Creating a criteria panel
Post by: entwine.llc.wi on May 30, 2023, 12:14:35 am

OK, Thank you.