Is there a way to create a list of the unique values of a given BOs attributes? For example, if various instances of Customer.ContactLastName include:
Moses
Brown
White
Coe
Brown
Moses
I would like to see a list that includes only (now alpha sorted):
Brown
Coe
Moses
White
Thanks!
Tom
list of unique values in a BOs attributes?
Hi Tom,
The following rule does the job:
http://www.hiden.org/files/u1/Uniqueness.bsv
Hope it helps,
Hubertus
The following rule does the job:
Code: Select all
IF NOT(EXISTS LastNames WHERE (LastNames.LastName=Customer.LastName)) THEN CREATE LastNames WITH LastNames.LastName=Customer.LastName
Hope it helps,
Hubertus
In case you want to use the above on existing data then you need to run the following process once.
Code: Select all
FIND ALL CUSTOMER
UPDATE Customer
Thanks Hubertus. Pete's demo in his May 14 post at http://www.awareim.com/forum/viewtopic.php?t=1548 now has a link to a demo + bsv that shows this functionality.
It also shows how to achieve dropdowns of existing database values in a search form.
Tom
It also shows how to achieve dropdowns of existing database values in a search form.
Tom