Within a form, I have a field that enables users to select from a list of customer ID's. However, I need to filter the list using a child table with additional attributes, so the list I'm presenting the users with contains what looks like duplicate records.
Do you have any suggestions for an approach I can take for limiting the list of customers to only one occurrence of each ID?
I've pasted an example below and attached the image as well. Essentially, I need to filter against customers from the table whose key is in col A, made up of Cols B-G.
When I display the customer number in the pick list, the list as it looks today is as follows:
0000000150
0000000410
0000000410
0000000430
0000000430
0000000445
0000000445
0000001000
0000001000
0000001000
0000001000
0000001000
0000001000
But for this specific purpose, the user only cares about the customer number in column B, so I'd like the available values to be (eliminate dupes):
0000000150
0000000410
0000000430
0000000445
0000001000
I cannot just filter off of the table containing the customer numbers, because I need to filter against some of these other attributes in cols C-G.
Any suggestions regarding an approach I can take? Thank you!
Michael_bartley
Within a form, I have a field that enables users to select from a list of customer ID's. However, I need to filter the list using a child table with additional attributes, so the list I'm presenting the users with contains what looks like duplicate records.
Do you have any suggestions for an approach I can take for limiting the list of customers to only one occurrence of each ID?
I've pasted an example below and attached the image as well. Essentially, I need to filter against customers from the table whose key is in col A, made up of Cols B-G.
When I display the customer number in the pick list, the list as it looks today is as follows:
0000000150
0000000410
0000000410
0000000430
0000000430
0000000445
0000000445
0000001000
0000001000
0000001000
0000001000
0000001000
0000001000
But for this specific purpose, the user only cares about the customer number in column B, so I'd like the available values to be (eliminate dupes):
0000000150
0000000410
0000000430
0000000445
0000001000
I cannot just filter off of the table containing the customer numbers, because I need to filter against some of these other attributes in cols C-G.
Any suggestions regarding an approach I can take? Thank you!
Hello Michael,
If I understand correctly, you need to remove "duplicates" from a reference list of value in an authoring form.
I guess those "duplicates" are here because the display card associated is a concatenation of multiple fields.
This concatenation not being unique, then it displays "duplicates".
But in reality, those are not duplicates, as they are each linked to a unique identifier.
Maybe as a workaround, you could give more liberty to the user to chose its referenced attribute by providing a search form on the reference:
And if required, you could even apply a picker filter based on your need.
Hope this helps.
Have a good day.
Best regards,
Alexia
Alexia SIMOND
Hello Michael,
If I understand correctly, you need to remove "duplicates" from a reference list of value in an authoring form.
I guess those "duplicates" are here because the display card associated is a concatenation of multiple fields.
This concatenation not being unique, then it displays "duplicates".
But in reality, those are not duplicates, as they are each linked to a unique identifier.
Maybe as a workaround, you could give more liberty to the user to chose its referenced attribute by providing a search form on the reference:
And if required, you could even apply a picker filter based on your need.
Hope this helps.
Have a good day.
Best regards,
Alexia
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 275 topics