ParamQuery grid support forum

General Category => ParamQuery Pro Evaluation Support => Topic started by: stevejacobsen on May 19, 2016, 09:12:07 pm

Title: Compare two columns in header filter
Post by: stevejacobsen on May 19, 2016, 09:12:07 pm

I'm trying to figure out how to do a comparison between two columns in a header filter. I have a minimum inventory column and an actual inventory column. I need to show all rows where actual inventory is less than the minimum. I'd like to do it in the header filter so then I can select other filters such as Supplier and know what parts I need to order from each supplier.

Can you point me to an example of this?

Title: Re: Compare two columns in header filter
Post by: paramvir on May 23, 2016, 10:49:35 am

First you need to add a computed column based on dependent columns, then custom filter or an inbuilt filter condition can be applied to that column.

Example: http://paramquery.com/pro/demos/filter_custom