Hello:
I would appreciate your guidance and support regarding an unexpected behavior related to lookup query rules, specifically when using the 'ALL' quantifier.
We have configured several lookup query rules using the ALL quantifier, which are expected to return duplicate values. These rules work correctly when tested within the Lookup Query Rule panel. However, when the form is launched, the behavior changes.
The issue is that the drop-down field linked to these rules displays only unique values, even though the underlying data contains multiple rows with identical values. It appears that the drop-down UI is now filtering out duplicate values by default. This behavior seems to have changed recently, as these business processes were previously functioning as expected.
As a result, both the ALL and DISTINCT quantifiers now appear to return the same outcome in the User Interface, which is impacting our processes. We have relied on the ALL quantifier to explicitly show repeated values and the DISTINCT option to exclude them, depending on the use case.
Attached below are some screenshots to help illustrate this unexpected behavior.
Image1 - Table Data:
Image 2 - Lookup Query Rule (No where condition applied)
Image3 - Lookup Query Test Result Panel:
Image4 - Drop Down UI Result with the same look up rule linked.