Search for order updated date

What is the best way to search for orders with Last Updated Date within a date range

Litium version: 7.4

Hi,
In which context do you need to do this search? Import, export, a BO panel, my pages? And why last updated date?

It is an order export through an API call. and the API should only return the orders that have been updated within the date range provided as input to the API.

You can always use the search with a RangeTag having your date range and tag name “TagNames.UpdatedDate”. See Range search for range search example.

If the export is business critical, I would prefer to get the information directly from the database not from the search indices. In that case you can use Dapper to run your sql request. You have to be carefull with the direct database calls since they will easily cause some performance issues if they are improperly used.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.