IsUniqueValue

This function checks if specified fields value is unique across some or all cases.

Syntax

IsUniqueValue("field","filter");

IsUniqueValue("field","filter","closedCasesAswell");

Function arguments

• field – (String) The name of the field containing value that is to be checked if is unique.
• filter – (String) Filter value specyfing which cases are to be searched through. Available values: [ User | Organization | Database ]
  Filter values explanation:
  User – check through all cases created by current user
  Organization – check through all cases created by anyone from the current user’s organization
  Database – check through all cases
• closedCasesAswell – (Boolean) [Optional] Specify if search is to be performed only in open cases (default behaviour) or in closed cases aswell. (Default = false)

Return value

This function returns Boolean.
Returns true if specified field’s value is unique, false otherwise.

Examples

Example 1:
This will check if 'Phone Number’ field’s value is unique across all opened cases created by anyone from current user’s organiztaion.

isUnique = IsUniqueValue("Phone Number","Organization");

Example 2:
This will check if „Activity” field’s value is unique across all opened cases created by current user and if not, show appropriate message.

if(IsUniqueValue("Activity", "User") == false) {
ShowMessage(1, "Identical Activity already specified elsewhere.");
}

Example 3:
This will check if 'Country’ field’s value is unique across all cases, both in opened and closed cases.

IsUniqueValue("Country", "Database", true);