Hi!I'm trying to filter out record where field 'value' is null, but it only gives the record of the first item, here's the code
local!validValues:ri!properties[where(a!isNotNullOrEmpty(ri!properties['recordType!{5ebb976a-556f-4033-b1d7-9e5976ab963d}MM Property.fields.{041a7f43-dfd1-4b07-aaed-48e305712f4e}value']))],
Any inputs?
Thank you
Discussion posts and replies are publicly visible
Rather than indexing, can you try applying the query filters using "not null" operator? This should ideally retrieve records that do not have null values.
the problem is that this is added data not in the record that i want to save after editing it