1. Forums
  3. Support and Presales
  5. Professional Members Support
  7. User List - Search Query Fields only match if all values are present

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

1 year 10 months ago #329786 by senclave
User List - Search Query Fields only match if all values are present was created by senclave
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

Please Log in to join the conversation.

1 year 10 months ago #329788 by krileon
Replied by krileon on topic User List - Search Query Fields only match if all values are present
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.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

1 year 10 months ago #329799 by senclave
Replied by senclave on topic User List - Search Query Fields only match if all values are present
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

Please Log in to join the conversation.

1 year 9 months ago #329811 by krileon
Replied by krileon on topic User List - Search Query Fields only match if all values are present
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.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
The following user(s) said Thank You: senclave

Please Log in to join the conversation.

1 year 9 months ago #329873 by senclave
Replied by senclave on topic User List - Search Query Fields only match if all values are present
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

Please Log in to join the conversation.

1 year 9 months ago #329879 by krileon
Replied by krileon on topic User List - Search Query Fields only match if all values are present
For audio fields or for CB Gallery stored audio files? For audio fields the filename generated and stored in database is as follows.

$newFileName	=	$col . '_' . uniqid( $user->id . '_' ) . '.' . $uploadedExt;

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.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
The following user(s) said Thank You: senclave

Please Log in to join the conversation.

Moderators: beat, nant, krileon
  1. Forums
  3. Support and Presales
  5. Professional Members Support
  7. User List - Search Query Fields only match if all values are present
Time to create page: 0.237 seconds

Facebook Twitter LinkedIn

    You are here:  
  1. Home
  2. Forums
  3. Support and Presales
  4. Professional Members Support
  5. User List - Search Query Fields only match if all values are present

Search

Login / Logout

User Menu