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

I am using paging grid to display data. I want to give data filtering option to the user. The user has five options to search for data e.g.: Order Number, Description, etc.
I've created a Query rule to get the data which I’ll like to display on the paging grid. The problem is with the Query Conditions it doesn't give you an option to search by an OR operator the only option is an AND operator. Any help will be appreciated
...

OriginalPostID-101358

OriginalPostID-101358

  Discussion posts and replies are publicly visible

Parents
  • 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?
Reply
  • 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?
Children
No Data