Feature #651
openImprove selectBox results ordering
0%
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 issues
Updated by Ondřej Kopr over 7 years ago
- Related to Task #463: Only 10 items are shown in comboboxes - schema attribute mapping etc. added
Updated by Petr Michal over 7 years ago
- 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.
Updated by Radek Tomiška over 7 years ago
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.
Updated by Petr Michal over 7 years ago
Its definitely true.
"starts with" is propably better choice in select boxes, and it will completely solves my example.
Updated by Radek Tomiška over 7 years ago
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.
Updated by Marcel Poul over 7 years ago
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).
Updated by Ondřej Kopr about 7 years ago
- Target version changed from Diamond (7.4.0) to Emerald (7.5.0)
Updated by Ondřej Kopr about 7 years ago
- Target version deleted (
Emerald (7.5.0))
Updated by Radek Tomiška about 7 years ago
- Subject changed from Add configurable search properties for selectBox to Improve selectBox results oredering
Updated by Radek Tomiška about 7 years ago
- Subject changed from Improve selectBox results oredering to Improve selectBox results ordering