Filter OR order of results

[revnelson]

I have a collection of TopSellers that has a Store relationship as well as a Region relationship. I'd like to perform a single query that prioritizes the more granular Store match over the more broad Region match.

If I perform a query with where containing an { OR: [ {store: {equals: givenStoreId},{region: {equals: givenRegionId}] } and a limit of 1, will a Store match reliably be returned even if there is also a Region match?

That is, is the first field in an OR filter reliably returned first, even if there is a match in both OR fields?

I'd prefer not to search for a Store match and then if nothing is found perform an additional search for a Region match to reduce round trips.

[akhrarovsaid]

Hey @revnelson,

I don't believe there is a way to consistently prioritize your stores over regions by just using the query you have as-is. There will have to be modifications to your data model. It's not obvious to me what you'd have to do in order to achieve that off the top of my head. However, I'd actually recommend the Search plugin which creates a proxy collection named Search which you can query. This collection can contain both Stores and Regions with one excellent option that will achieve the requirement you've listed - defaultPriorities. Essentially, you can get results for both collections while prioritizing one type of search result over the other.

I believe this plugin is perfect for your use-case. Hope that helps!

[revnelson]

Thank you for giving some insight here! I think this solution may work if the search term is the same, but I'm trying to find a match by a user's storeId first, and only if that fails look for a match by regionId.