Hi,
I need help with Appian queryFilter, I have found a strange behavior that I would like to consult you.When I filter for a record that is boolean true, it returns false values, what can I be doing wrong? Here are two different examples with a!queryRecordType()
Thanks in advance,
Hector
Discussion posts and replies are publicly visible
If you want to exclude related records from your result set, I suggest you use relatedRecordData in your query.
docs.appian.com/.../fnc_system_relatedrecorddata.html
Did you check the difference between the "AND" and "AND_ALL" operator?
This solution does not work for me, because I would like to exclude the simulation with id 1, and it is excluding the fixed fee = false. Thanks anyway
I did try AND_ALL, and the same thing happens. I would like to be able to exclude the records of type Simulation that have some Simulation_Plant.fixedFee = false. Thanks anyway
Maybe ...
https://docs.appian.com/suite/help/24.1/fnc_system_relatedrecorddata.html#filtering-and-sorting-the-related-record-set
We would like to achieve this but without having to do a loop to get the totalCount 16, in the case I gave you it returns more values of Simulation because it includes the records that have the fixedFee=false
With this code it is correct, but we want to make it more efficient without having to make the loop
Does using whereContains and getting the already fetched data make difference?