How to add AND and OR in SDP filter criterion
Summary:
How to add AND and OR in SDP filter criterion
Content (required):
We have a scenario, in which we need to set AND and OR in Filter Criterion for SDP. For example, we need to set below:
((invoiceNumber LIKE '%abc%') and (policyGroup LIKE '%Employee Benefit%') and (approvalStatus != 'Not Required' or postingStatus != 'Posted'))
I tried it by using javascript function below.
PageModule.prototype.prepareSearchQueryParams = function (q1, q2, q3, q4) {
var req = [];
if (q1.value) { req.push(q1); }
if (q2.value) { req.push(q2); }
if (q3.value) { req.push(q3); }
if (q4.value) { req.push(q4); }
return req;
0