Bug #6832: Userlist searching of select values with spaces breaks the value - CB - Joomlapolis forge

Actions

Copy link

Bug #6832

closed

Userlist searching of select values with spaces breaks the value

Added by krileon over 6 years ago. Updated about 6 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

Actions

Copy link

Updated by krileon over 6 years ago

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.

Actions

Copy link

Updated by krileon over 6 years ago

% 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.

Actions

Copy link