Project

General

Profile

Actions

Feature proposal #6231

open

improve multi-select search query

Added by krileon over 8 years ago. Updated 4 months ago.

Status:
Feedback
Priority:
Normal
Assignee:
-
Target version:
Start date:
30 September 2016
Due date:
% Done:

0%

Estimated time:

Description

When searching a mult-select (or multi-checkbox) field it adds each value selected as a LIKE usage to the query. This results in usage like the below.

AND (((ue.`cb_checkboxmultiple` LIKE '%Value 1%') OR (ue.`cb_checkboxmultiple` LIKE '%Value 4%') OR (ue.`cb_checkboxmultiple` LIKE '%Value 8%')))

The problem with this is if 1 value contains the value of another you end up getting incorrect results. For example I search Value 1 it will also match Value 11, Value 111, etc.. This should convert the |*| and do an IN usage instead with a single AND.

https://www.joomlapolis.com/forum/153-professional-member-support/234879-user-search-function-issue#286469


Files

multiselect_search_regexp.txt (150 Bytes) multiselect_search_regexp.txt krileon, 01 December 2016 21:08
#2

Updated by krileon over 8 years ago

#4

Updated by krileon over 8 years ago

  • Status changed from Assigned to Feedback
  • Assignee deleted (krileon)
#5

Updated by krileon over 8 years ago

  • Target version changed from CB 2.1 to CB 2.2
#6

Updated by krileon almost 7 years ago

  • Target version changed from CB 2.2 to CB 2.8
#7

Updated by beat over 2 years ago

  • Target version changed from CB 2.8 to CB 2.8.1
#8

Updated by beat almost 2 years ago

  • Target version changed from CB 2.8.1 to CB 2.8.2
#9

Updated by beat over 1 year ago

  • Target version changed from CB 2.8.2 to CB 2.9.0
#10

Updated by beat over 1 year ago

  • Target version changed from CB 2.9.0 to CB 2.9.2
#11

Updated by beat 12 months ago

  • Target version changed from CB 2.9.2 to CB 2.9.3
#12

Updated by beat 9 months ago

  • Target version changed from CB 2.9.3 to CB 2.10.0
#13

Updated by beat 4 months ago

  • Target version changed from CB 2.10.0 to CB 2.10.1
Actions

Also available in: Atom PDF