Repositories query does work with "AND" negate or "Sort"

Hi Michael

I have made a copy of the problem description so others on the forum have a chance to reply to this:

"We have made a Suggested search in repositories. Here we build two indexes - one in pure sql for pages and one for products that use product schema.

We are not able to "Negate" results inside products.query. Indeed, we must only show products if they exist in a given group per language layer. Today I have to do this work in razor file:

if (groupIds.Contains ("GROUP2302") || groupIds.Contains ("GROUP2304") || groupIds.Contains ("GROUP2306")) {

This is not optimal because my result list automatically becomes smaller as it makes the minus in the number of results.

Similarly, my results are not sorted out from my "Product name" "Ascending" sort - this is not something that should fixes in our razor file."

Kind Regards
Dynamicweb Support
Kristian Kirkholt

Developer forum

Repositories query does work with "AND" negate or "Sort"

Replies