check for duplicates

Hi - could you please advise what and/or how to use the available CB tools/plugins/whatever to ensure that some fields are not entered the same value?
Example: fields for primary (required) + alternative emails; or phone numbers that must be unique: ideally a way to query and return error message if the value already exist.
Thanks!

azjr wrote: Hi - could you please advise what and/or how to use the available CB tools/plugins/whatever to ensure that some fields are not entered the same value?
Example: fields for primary (required) + alternative emails; or phone numbers that must be unique: ideally a way to query and return error message if the value already exist.
Thanks!

These 2 videos might help you:

www.youtube.com/playlist?list=PLp0puRITgC7MM9iP9FooKB1qk8f5MLWVp

CB Query Field and its Query Validation feature can be used to query the _comprofiler table to ensure another user hasn't already entered the value supplied by the user. See the below videos to get started.

www.youtube.com/playlist?list=PLp0puRITgC7MM9iP9FooKB1qk8f5MLWVp

OK guys, I need to ask probably embarrassing question, but I can't get the query right - the goal is to look for the duplicate values within the same ID - so that if user have entered value into cb_phone1, s/he canno't enter the same value in the cb_phone2.
So the validation is "horizontal" rather than vertical - any thoughts?
thanks!

~~~~~~
(few hours later...) - this is interesting:
I can validate email fields with the query:
and I'm getting the correct results... BUT when I try to do the same with phone fields, nothing... all is ignored.
The difference between the email and phone fields is that I'm using regex on phone: to force the entry: (999) 999-9999
Do you think this can have something to do?

The query validation is per field. So if you want to validate your phone field you need to edit your phone field in CB > Field Management then add query validation specifically for it. Example as follows.

Query Validation: Enabled
Query: Validate On: Empty Results
Ajax Validation: Enabled

Your email one would be as follows.

Query Validation: Enabled
Query: Validate On: Empty Results
Ajax Validation: Enabled

hmm... I can't validate with that email query:
scenario: example:
after user provides the email (the required one), there are 3 more email fields (optional): email2,email3,email4 - so if user attempts to enter the same email address into any of those fields, user should get the error validation.
Now, by no means my sql is perfect, but it does work - I have entered the following variation values under each field's query validation (the "SELECT * FROM `#__users`, `#__comprofiler` " is the same in all queries, only the WHERE portion changes:)

email:
WHERE email=value OR email2=value OR email3=value or email4=value

email2:
WHERE email=value OR email3=value OR email4=value

email3:
WHERE email=value OR email2=value OR email4=value

email4:
WHERE email=value OR email2=value OR email3=value

Please advise - thanks!