I am using paging grid to display data. I want to give data filtering option to

Hi,
Please refer this link,
forum.appian.com/.../e-82778

You can use queryrecord instead.

Thanks for the reply.

I might need to be a bit clearer with my use case. The user wants a multi filter search, so the user can filter his/her search by 1 filter (Order Number) OR 2 filters Order Number, Description OR 3 filters etc.

The only possible way I see of doing this is by creating a query rule for each scenario, which may lead to many query rules and many paging grids to be created. For example, if the user could filter their search by up to 10 filters, that means I would have to create 10 to the power to 10 query rules to handle all the possible sear h scenarios. Surely there is an easier way to achieve this?

Use Includes operator...

There is a number of options that you can do in this case depending on the setup of your environments:
1. Use Query Database smart service where you can construct your custom SQL query taking account any parameters that you defined for filtering the records for the paging grid. For this approach, it's best (in my opinion) to have a database view that aggregate the tables that are required for the paging grid information as well as exposing the columns to be filtered on the same view rather than perform the joins in the query database node itself.
2. Build an external web service that takes account all the parameters that you want to use for filtering and then return the result set required to populate the paging grid. Then use the Call Web Service smart service to pass the parameter and get the result set back into Appian.
3. Build a database stored procedure exposing the parameters for the filtering, and then use the Execute Stored Procedure smart service from Execute Stored Procedure plugin (forum.appian.com/.../64996) to run that database procedure and pass the parameter values for filtering.

@Amirula Thanks a lot for your input I'm currently trying out the second option.