I am adding another query filter for ri!employerId. The name of the field in the table is locindstryid. When I run a test query, I get the following error.
Error Expression evaluation error at function a!queryLogicalExpression [line 13]: The a!queryLogicalExpression function has an invalid value for the “operator” parameter. “operator” must not be null or empty.
Code:
with( /* Query for vanpools in status A, P, R or Z with the matching employer ID and worksite ID */ /* If none found, return empty {}, else return the worksite ID */ local!data: a!queryEntity( entity: cons!ENTITY_LOCATION_INDUSTRY_DET, query: a!query( selection: a!querySelection( columns: { a!queryColumn(field: "referenceId"), a!queryColumn(field: "locIndstryId") } ), logicalexpression: a!queryLogicalExpression( operator:"AND", filters: { a!queryFilter( field: "referenceId", operator: "=", value: ri!worksiteId ), a!queryFilter( field:"locIndstryId", operator:"=", value: ri!employerId ) }, ignoreFiltersWithEmptyValues: false ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ) ), fetchTotalCount: true).data,
if(count(local!data) > 1, {}, local!data[1].referenceId)
)
Discussion posts and replies are publicly visible
I don't see anything obvious that is incorrect - does your query work without the logical expression at all? Can you try to add / remove parts of the code to isolate the issue?
Thank you, I was thinking the same thing in that it looked ok from a syntax point of view. Ended up rebuilding the expression since it was several years old.