Hello,
I'm using function a!recordData to return data from one of my records and I need to apply multiple filtering on the dataset:
data: a!recordData( recordType: 'recordType!{a24eedc6-9d03-4ecc-affc-9d0a19c7cc0d}QUA Incident', filters: { a!queryFilter( field: 'recordType!{a24eedc6-9d03-4ecc-affc-9d0a19c7cc0d}QUA Incident.fields.{a1a9fdf7-1d9b-48eb-a147-2a233271d74b}adGroup', operator: "=", value: local!adGroup ), a!queryFilter( field: 'recordType!{a24eedc6-9d03-4ecc-affc-9d0a19c7cc0d}QUA Incident.fields.{3729b606-5b1b-4fb8-b16b-c9e929833ece}assignedTo', operator: "<>", value: loggedInUser() ) } )
When I use both filters, data is not appearing at all, If I remove the second condition I can see some results that are aligned with the first filter definition.
However, If I use a!queryEntity function to retrieve the same data for the same entity I get 2 results ( the expected result).
a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "adGroup", operator: "=", value: "GS-A2-CAPF-BPM-QUA-Bendern-Accountants" ), a!queryFilter( field: "assignedTo", operator: "<>", value: loggedInUser() ) }, ignoreFiltersWithEmptyValues: true )
Can anyone please explain what could be the reason for not getting the same result with both approaches ?
Discussion posts and replies are publicly visible
Check if there is any source filter applied to your Record Type which is filtering out the records you are trying to fetch in a!recordData
Ah yes, this too - any default filters declared in the Record Type definition would stack with any passed into a!recordData(), which is something that wouldn't be seen when using a direct queryEntity(). I forgot to think of that.
Exactly!!