Hi there,
I am having an issue with the new option...
# community-helps
Stefan Hesse
03/13/2023, 1:51 PMHi there,
I am having an issue with the new optional filtering, I would expect that if I put the "_eval" sort criteria first that documents that match this expressions are shown first no matter the other sort criteria, but that doesn't seem to be the case:
Copy code
---------- Search parameters
{'q': '*', 'query_by': 'name', 'sort_by': '_eval(id:1):asc,pop:desc'}
---------- Query output
{'facet_counts': [],
'found': 2,
'hits': [{'document': {'id': '0', 'name': 'a', 'pop': 1},
'highlight': {},
'highlights': []},
{'document': {'id': '1', 'name': 'b', 'pop': 0},
'highlight': {},
'highlights': []}],
'out_of': 2,
'page': 1,
'request_params': {'collection_name': 'test_collection',
'per_page': 10,
'q': '*'},
'search_cutoff': False,
'search_time_ms': 0}k
Kishore Nallan
03/13/2023, 1:53 PMIs this a problem only for id field? Or are other fields affected as well?
s
Stefan Hesse
03/13/2023, 1:56 PMlet me check
Stefan Hesse
03/13/2023, 1:58 PMSeems to be only related to the id field:
Copy code
---------- Search parameters
{'q': '*',
'query_by': 'name',
'sort_by': '_eval(other_field:test):desc,pop:desc'}
---------- Query output
{'facet_counts': [],
'found': 2,
'hits': [{'document': {'id': '1',
'name': 'b',
'other_field': 'test',
'pop': 0},
'highlight': {},
'highlights': []},
{'document': {'id': '0',
'name': 'a',
'other_field': 'not_test',
'pop': 1},
'highlight': {},
'highlights': []}],
'out_of': 2,
'page': 1,
'request_params': {'collection_name': 'test_collection',
'per_page': 10,
'q': '*'},
'search_cutoff': False,
'search_time_ms': 0}k
Kishore Nallan
03/13/2023, 1:59 PMYup so there's probably a bug there specific to id
s
Stefan Hesse
03/13/2023, 2:06 PMShall I create an issue?
k
Kishore Nallan
03/13/2023, 2:19 PMYes please
s
Stefan Hesse
03/13/2023, 2:24 PM