Feature #651
open
Improve selectBox results ordering
Added by Ondřej Kopr over 7 years ago.
Updated about 7 years ago.
Description
Now has selectBox pageSize (see #463), but on some implementations is necessary to override size for all project complete.
Please add BE configuration property for default pageSize, thank you.
- Related to Task #463: Only 10 items are shown in comboboxes - schema attribute mapping etc. added
- Priority changed from Low to Normal
Setting higher priority, because I found quite annoying example, why we need this.
Example: I have generated schema from LDAP. Now I want to do mapping for standard LDAP attribute "o".
1) Its not in select box, but it says thah I can see only 10 of 60 atrs - OK
2) But if I wrote "o" into search area... its searching for o, and sorting result by first letter and show only ten first. So I cannot find my attribute in any way.
I think this ticket is more about criteria query building than page size. More suitable will be add option to search by "text%" in select boxes (=> "starts with", maybe by default for select boxes). Now is search criteria query built as "%text%" everywhere.
Its definitely true.
"starts with" is propably better choice in select boxes, and it will completely solves my example.
We found another possible solution, example:
SELECT username
FROM idm_identity
WHERE username LIKE '%a%' order by (CASE WHEN username = 'a' THEN 0 ELSE 1 END), username asc
=> rows matched with equality are the first rows returned. I don't know, if it will be possible to integrate this to our devstack (spring data + criteria api), but this could work globally without api (filter dto) changes.
Ondra,
please update the state of this task. This closely correspond with the ticket in your project that our customer wants to address. We need to tell them, what is the status and when the issue will be solved (in what version).
- Target version changed from Diamond (7.4.0) to Emerald (7.5.0)
- Target version deleted (
Emerald (7.5.0))
- Subject changed from Add configurable search properties for selectBox to Improve selectBox results oredering
- Subject changed from Improve selectBox results oredering to Improve selectBox results ordering
Also available in: Atom
PDF