User List - Search Query Fields only match if all values are present

Hi,

I have a user list and a searchable field populated by query tags. In the DB values are stored properly like value1|*|value2... but in the search only find a match if both values are present, if i search by value1 or value 2 no match is found. There is any way to look for only one value and have a match?

I have it set up as:

Simple Any word match: Only 'any of' and ranges (WARNING: can be slow)

Best
J

Was able to confirm a bug during multi-select searching, but unsure if it was same issue you were experiencing. I have confirmed multi-select searching of single value when multiple are saved is working fine after fixing that issue though. Please update to latest CB Query Field build release. It should be available now.

Hi I just download the new version and installed over the old one. In my side still don't find a match with a single value, must be all values present in the search. The field I use to populate the db is Query Tag, probably have the same issue?

Best

Johnny

Ah, yes that certainly helps. Was able to confirm an issue with tag field searching. Have confirmed a fix and should be available in latest build release now.

Work like a charm! Thanks.

One unrelated question, the audio files names in db contain a hash, I need to store the file from a external form, and I wonder if I can use time() or to be consistent use the same hash method. Can you point me to the function that generate the hash so I can replicate the same behavior on my script?

Best
J

For audio fields or for CB Gallery stored audio files? For audio fields the filename generated and stored in database is as follows.


Why do you need this? Are you trying to store audio files externally? The stored value can be whatever you want it just needs to match the filename in storage.