Applying sort only on N number of items

volume_up

A critical vulnerability was discovered in React Server Components (Next.js). Our systems remain protected but we advise to update packages to newest version. Learn More.

Home / Forums / Developers (Apps and Integrations) Forum / Search & Navigation /

Applying sort only on N number of items

Zoran

Vote:

expand_less 0 expand_more

Hi guys,

I have a page with DateTime property, "PageDate" and property "PageRank"

There is a requirement where I need to apply OrderBy for search pages which have "PageDate" in future first and ThenBy "PageRank".

Thing that complicates this is the requirement also says that editors also have an option to controll how many items can be sorted like this. There is an option for 1-3 items.

Basically something like promoted results but only with an option to choose how many items to be promoted.

I tried with getting only promoted results and than combining with normal and excluding duplicates.

Downside of this approach is duplicates in normal search results, incorrectly loaded result count and Facet count.

Also I tried with just one query and sorting by "PageDate" then by "PageRank" but then I can't controll how many items are sorted.

If anyone has any suggestion it would be really helpfull.

I'm using EPiServer.CMS version 12.15.1 and EPiServer.Find 14.2.4

Thanks,
Zoran

#302339

Edited, May 25, 2023 14:40

Scott Reed

Vote:

expand_less 0 expand_more

Instead of deduplicating after the results come back you could with 2 search queries

Get the results back of the prioritized
Then pass an exclusion in to the second query of the non sorted results with each contentreference id to exclude it from the results

This would leave you with pagination only working for the second layer so you'd have to show the promoted results on top of the normal set of results. E.g. if your pagination number is 9 you'd put a row of the 3 artifically in front of the main results.

If you have pagination you can then combine result total count

#302402

May 26, 2023 10:11

Zoran

Vote:

expand_less 0 expand_more

Hi Scott,

Thanks for reply.

I have implemented it like that but I was trying to do that in one query with just sorting to avoid complexity.

But I can't limit the number of prometed items.

I guess that two queries is the way to go.

#302458

May 27, 2023 14:33

- May 30, 2023 13:52

I understand, I did think of multisearch as you can do 10 queries in 1 request but you'd need the result back first so that's not possible. Good luck with it!

error This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.