list of unique values in a BOs attributes?

tford

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

Hubertus

Hi Tom,

The following rule does the job:

IF NOT(EXISTS LastNames WHERE (LastNames.LastName=Customer.LastName)) THEN CREATE LastNames WITH LastNames.LastName=Customer.LastName

http://www.hiden.org/files/u1/Uniqueness.bsv

Hope it helps,
Hubertus

Hubertus

In case you want to use the above on existing data then you need to run the following process once.

FIND ALL CUSTOMER
UPDATE Customer

tford

Super -- I'll give it a shot. You have an amazing understanding of AwareIM functions. 😃 I'm glad you are active in the forum

Tom

tford

Thanks Hubertus. Pete's demo in his May 14 post at