HI team,
what is the differende between "AND " and "AND_ALL" operator in recordtype filter.
can you guys explain with example
Discussion posts and replies are publicly visible
“AND_ALL” operator is only valid when filtering on multiple fields from a one-to-many relationship.When you use the "AND_ALL" operator to filter by multiple related record fields from the same one-to-many relationship (i.e., the "many" side of the relationship), the filter will return all records from the base record type (the "one" side of the relationship) that have at least one related record that meets each filter condition.you can see the example here ->docs.appian.com/.../fnc_system_a_querylogicalexpression.html
“AND_ALL”
"AND_ALL"
i have created recordtype and i done one to many relationship using that when using "AND" and "AND_ALL" same only i am getting
AND will take care of returning all the matching conditions with the base, many-to-one, and one-to-one records. AND_ALL will help me one-to-many.
i need more clarification in this can you give any example
example is provided in this documentation linkdocs.appian.com/.../fnc_system_a_querylogicalexpression.html