Checking for uniqueness

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
tkilshaw
Posts: 170
Joined: Thu Jan 19, 2006 11:33 pm
Location: Western Canada
Contact:

Checking for uniqueness

Post by tkilshaw »

How can I check that the values of an attribute of an object for uniqueness?

I want to do this at entry time mostly.

thanks,

Terry
aware_support2
Posts: 595
Joined: Sun Apr 24, 2005 2:22 am
Contact:

Post by aware_support2 »

Terry,

Here is the 'Uniqueness of login name' rule that the system automatically adds to RegularUser when you create a new business space:

If EXISTS SystemUser WHERE (SystemUser.LoginName = ThisRegularUser.LoginName
AND SystemUser.ID<>ThisRegularUser.ID)
Then REPORT ERROR 'User with this login name already exists. Please choose a different name'

You can add a similarly structured rule to your objects to check attribute values for uniqueness. If you specifically want to limit the check to entry-time only, you can add condition IS NEW to the rule.
Aware IM Support Team
Post Reply