[SOLVED] CB QUERY FIELD not working

Hello,
First please thanks your administrative manager for trefounding my wrong purchase promplty. This is remarkable.
Now I have a problem with the CB QUERY FIELD ADDON

String I inserted in a TEXT field ( where registering user has to enter his phone number ) in the integrations tab CB QUERY FIELD , as per demo on online video, is following:

---

SELECT 'id' FROM `josog_comprofiler` WHERE 'cb_privatephonenumber' = '[value]'

---

Well, nothing happens. In fact if I enter a value of an existing phone number, exactyly the same, of a previuos registered user, it does accept it without giving back any error message.
Ajax enabled or disabled does not make any difference.
How comes ?

Many thanks in advace.
Massimo

You're using single quotes around column names instead of back quotes. Below should work fine.

No way, sorry. It does not work at all.
It keeps accepting an existing value
No matter using >> `#__comprofiler` <<
or >> `josog_comprofiler` << in the query string.

You're doing an exact 1 to 1 match, which can be a problem if you don't enforce some sort of format. Example as follows.

User A: 123-4567
User B: 1234567

Same number, but both are allowed unless you enforce a format. Are you sure a user exists with the exact string you're trying to supply? Are you testing this in backend or frontend?

I'm positive values entered vs value stored is exactly the same.
If it's quicker for you I may send private message with page login url so you can test as well as access to backend.
Let me know
Many thanks in advance

Query looks fine as does the data. Are you sure CB Query Field is even loading? Please ensure it's Public and Published within CB > Plugin Management. I'm having no issues in my tests with query validation. If issue persists after checking to make sure the plugin is loading please PM backend super administrator login credentials and will take a look.