Dynamic Operators & Fields on query record.

I have a requirement where the user can select the 5 mutliple dropdown values,Sort for any one of 5 and operators for each value from operator dropdown and Gate operator (AND or OR).

Ex:
Employee Dept(dropdown) Sort On(radio button) Operator(dropdown) Gate
Medical Yes = AND
Transport No is null OR
Finance No includes AND
Billing No = OR
Delivery No in AND

based on the user selected values I would required a query record with selected employee depts as fields in the filters with respective operators.

Can someone please provide your valuable suggestions to write queryrecord.

Thanks in Advance.

  Discussion posts and replies are publicly visible