You are viewing limited content. For full access, please sign in.

Question

Question

LASERFICHE CLOUD - Unexpected behavior using ALL quantifier in Lookup Query Rules

asked one day ago Show version history

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.

0 0

Replies

replied one day ago

Hi Miguel,

When you said it worked before, by chance, was it in a table or collection?

I was able to reproduce the issue with lookups on single-line and Drop-down fields outside of a table in both classic and Modern designers.

 

 

0 0
replied 14 hours ago

Hi Troy, It was always using a table.

0 0
replied 14 hours ago

This was a behavior change at the beginning of the month. Can you describe the use case where duplicates are needed in a drop-down list?

0 0
replied 13 hours ago

Hi Miruna,

The use case is similar to the examples shown in the images. We often have fields such as color names, item names, or worker names - where multiple entries may share the same name but have different IDs.

For lookup purposes, it's more user-friendly to display the names (rather than the IDs) in a drop-down list, as names are easier for users to recognize and remember. However, when we have duplicate names with different IDs—each representing a distinct row with different properties—the drop-down now only displays one of the repeated names, effectively hiding valid data entries from the user.

If we use IDs instead of names, the drop-down will show all unique rows correctly. However, managing lookups by ID is not practical for end users, as IDs are not meaningful or memorable to them.

This recent change in behavior is impacting processes that rely on presenting repeated names in the drop-down while preserving their underlying differences. We had previously used the ALL quantifier specifically to retain those duplicates, and would appreciate if there’s a workaround or option to restore the original behavior.

0 0
replied 14 hours ago Show version history

To the form filler, there is no difference between white and white so we squash duplicates. If you assign values to the dropdown and the label/value pairs are different we will retain duplicates. At that point it is up to you to make sure the label shows correctly as we will default it to "label (value)" i.e. "White (1)" instead of "White" so the user can choose the right color.

Just labels
white, black, white, blue -> white, black, blue

Labels/values

white:1, black:2, white:3, blue:4 -> white (1), black, white (3), blue

0 0
replied 13 hours ago

Hi Louis,

Thank you for your time on this question. As shown in the example, I am using a Table (Image 2) that includes one column for IDs, which are unique for each row—even when rows share the same name. This is because the table also contains other columns with different properties for each duplicated name.

I am not using the drop-down panel to manually populate the fields. Instead, the drop-down is populated through a lookup query rule linked to the table.

You're right that assigning different values to the labels would work, but in this case, using the drop-down panel to populate it will become unmanageable due to the volume—nearly 3,000 names, many of which are similar.

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.