moisbo
commented
1 week ago Hi Rosanna -- Have a look at what query is produced with the Show Query Button and then try to reproduce it with the API. If there is a difference then we should address it, otherwise I'd update the help page. I mean a difference with the results, because there might be a bug on the query generation or that is how opensearch works
- With postman create a query with the API
- Compare it to what is produced as a query
- Run the query in both
If this should go in auto-ldaca-data-portals let me know and I'll move it.
I'm putting together some training around advanced search in the portal, and noticed some differences in result count for boolean operators. I'm testing three types here: 1) two terms in a single search field without parentheses
2) two terms in a single search field with parentheses
3) two terms in separate search fields with the boolean operator.
I'm including the searches and results I got from each below, together with the query output, which seems to be slightly different for each.
AND:
otway AND grampians: 0 results ( name.@value : otway AND grampians OR description.@value : otway AND grampians OR inLanguage.name.@value : otway AND grampians OR _text : otway AND grampians )
(otway AND grampians): 1 result ( name.@value : (otway AND grampians) OR description.@value : (otway AND grampians) OR inLanguage.name.@value : (otway AND grampians) OR _text : (otway AND grampians) )
Text 1: otway /AND/ Text 2: grampians: 1 result ( name.@value : otway OR description.@value : otway OR inLanguage.name.@value : otway OR _text : otway ) AND ( name.@value : grampians OR description.@value : grampians OR inLanguage.name.@value : grampians OR _text : grampians )
OR:
otway OR grampians: 9 results ( name.@value : otway OR grampians OR description.@value : otway OR grampians OR inLanguage.name.@value : otway OR grampians OR _text : otway OR grampians )
(otway OR grampians): 14 results ( name.@value : (otway OR grampians) OR description.@value : (otway OR grampians) OR inLanguage.name.@value : (otway OR grampians) OR _text : (otway OR grampians) )
Text 1: otway /OR/ Text 2: grampians: 14 results ( name.@value : otway OR description.@value : otway OR inLanguage.name.@value : otway OR _text : otway ) OR ( name.@value : grampians OR description.@value : grampians OR inLanguage.name.@value : grampians OR _text : grampians )
NOT:
otway NOT grampians: 9 results ( name.@value : otway NOT grampians OR description.@value : otway NOT grampians OR inLanguage.name.@value : otway NOT grampians OR _text : otway NOT grampians )
(otway NOT grampians): 8 results ( name.@value : (otway NOT grampians) OR description.@value : (otway NOT grampians) OR inLanguage.name.@value : (otway NOT grampians) OR _text : (otway NOT grampians) )
Text 1: otway /NOT/ Text 2: grampians: 8 results ( name.@value : otway OR description.@value : otway OR inLanguage.name.@value : otway OR _text : otway ) NOT ( name.@value : grampians OR description.@value : grampians OR inLanguage.name.@value : grampians OR _text : grampians )
Options 2 and 3 provide identical results, so it seems like it's booleans without parentheses that are producing different counts. The help says to use parentheses when multiple operators are used, but seems like it's required for a single operator as well.