[SEARCH-903] Order by with a custom property (type = text) results in error Created: 11-Jun-18 Updated: 28-Jul-20 Resolved: 27-Jun-18
|Project:||Search and Discovery|
|Affects Version/s:||Insight Engine 1.0|
|Fix Version/s:||Insight Engine 1.0|
|Reporter:||Meenal Bhave [X] (Inactive)||Assignee:||Unassigned|
|Remaining Estimate:||0 minutes|
|Time Spent:||Not Specified|
|Original Estimate:||0 minutes|
ACS 6.0 + Insight Engine +DBVisualiser
Results in response:
<order by> works with the existing text field but fails with the following error when ordered by text property / field in the custom model.
|Comment by Michael Suzuki [X] (Inactive) [ 27-Jun-18 ]|
This is not a bug, we do not support ordering on text.
|Comment by Meenal Bhave [X] (Inactive) [ 06-Jul-18 ]|
Tested that order by text property works well, when the text fields support indexing. i.e. property / field type is either of list of values (whole or partial match), or pattern match (unique or many matches)
If text property is defined with indexing option as <none> or <freetext>, the order by does not work, as order by isn't supported for this indexing type.