2

I have a requirement to fetch the news items in between the fromDate and toDate. fromDate and toDate need to pass as a parameter so i am unable to forming the query. for your reference please find the below screenshot.

enter image description here

1 Answer 1

3

The parameters that are passed in are used to build a predicate and fired off for search results from the Search API. The OOTB parameters allow for very powerful and fast queries for data but are limiting by a key factor. It does not support filter by date and sorting, so you cannot control the order in which your results are returned. In a recent implementation, we had to add date filter fromdate,todate and sorting to allow us to retrieve data sorted by date in given date range.

Most standard sorting will work, but it likely won't give you the desired result if you're trying to sort something like a date. To do this, you will need to convert your date field to a string-sortable friendly value. My recommendation is to create a computed index for your date fields to store the value in ticks.

You can find the full implementation for the ExtendedSearchQuery in a gist here: ExtendedSitecoreQuery.

Hopefully, this helps.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.