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.
[mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05]
[mention:2773a0b2dec7409a8eee377b9fc57b88:e9ed411860ed4f2ba0265705b8793d05]
[mention:6b9f80ff18f9420082d13ef2d5121d56:e9ed411860ed4f2ba0265705b8793d05]
[mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05]
