Hi,
I am working on exporting a record grid to excel. I am getting an error message while using Export Data Store Entity to Excel Smart Service.
Filters field must be of type QueryFilter or LogicalExpression (APNX-1-4505-019). I am using a script task to get the values and passing into the filter node input.
What could be the problem here? Can anyone help me with it? Thanks
a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "partNumber", operator: "includes", value: pv!partNumberFilter ), a!queryFilter( field: "supplierId", operator: "=", value: pv!supplierFilter ), a!queryFilter( field: "manufacturerId", operator: "=", value: pv!manufacturerFilter ) }, ignoreFiltersWithEmptyValues: true )
Discussion posts and replies are publicly visible
I think from script task you may saving the values in type of text field (pv!filters), that is why you are getting this error. I would suggest you to create an expression rule for these filters and call that expression rule for your filter value.
Hi Naresh,
It worked.
Thanks