Project

General

Profile

Actions
Copy link

Bug #6832

closed

Userlist searching of select values with spaces breaks the value

Bug #6832: Userlist searching of select values with spaces breaks the value

Added by krileon about 8 years ago. Updated almost 8 years ago.

Status:
Closed
Priority:
Urgent
Assignee:
krileon
Target version:
CB 2.1.4
Start date:
01 November 2017
Due date:
% Done:

100%

Estimated time:

Description

When searching a select type field and the value contains a space it is split at the space. Example as follows.

Field: Drop Down (Single Select)
Advanced Search: is one of
Values: Value 1 and Value 2
Result:
AND ((ue.`cb_dropdownsingle` = 'Value') OR (ue.`cb_dropdownsingle` = '2'))
Expected:
AND ((ue.`cb_dropdownsingle` = 'Value 1') OR (ue.`cb_dropdownsingle` = 'Value 2'))

https://www.joomlapolis.com/forum/153-professional-member-support/237677-userlist-advanced-search-not-working#298596

Updated by krileon about 8 years ago Actions
Copy link
 #1

This is due to the jQuery for userlists not switching the name of the input to include [] at the end so it can be treated as an array of values.

Updated by krileon about 8 years ago Actions
Copy link
 #2

  • % Done changed from 0 to 50

Partially fixed. The name properly changes now and the SQL is now working fine, but the redisplay of the input is not showing the appropriately selected values likely due to fields search HTML not handling the array of values.

Updated by krileon about 8 years ago Actions
Copy link
 #3

  • Status changed from Assigned to Resolved
  • % Done changed from 50 to 100

Fixed in MR !1291

Updated by beat almost 8 years ago Actions
Copy link
 #4

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: PDF Atom