Skip to main content
Question

How to filter customer orders according to the last update time?

  • April 14, 2026
  • 7 replies
  • 72 views

Forum|alt.badge.img+1

I want to filter customer orders based on the last update time.

However, currently, the interface for customer orders provided by the IFS system doesn't seem to support this directly.

The method I'm using at present is to filter the orders according to DateEntered first.

Then, for each order, I obtain its historical records, arrange them in reverse order, and regard the DateEntered of the first record in the record list as the last update time of the order.

Finally, I filter out the orders I need according to this time.

But this approach is very time - consuming.

What I want to ask is whether there is an interface that can obtain the order data I want in one go.

7 replies

Abdul
Superhero (Partner)
Forum|alt.badge.img+20
  • Superhero (Partner)
  • April 14, 2026

Hi ​@niexinbi,

Have you checked Customer Order Lines History interface? 

This could be a good option otherwise you could also try by configuring a quick report for Customer_Order_History view.

 

Regards

Abdul Rehman


Forum|alt.badge.img+1
  • Author
  • Do Gooder
  • April 15, 2026

Thank you very much for your answer. I tried using the methods you provided, but they still don't meet my requirements.

  1. Analysis->CustomerOrderLinesHistory: Although this interface returns the modification date, it doesn't include order details (such as RouteId, CustomerNo...) and order line details (such as PartNo, Quantity...).
  2. Customer_Order_History: Currently, I'm combining this interface with the CustomerOrders interface to obtain the data I need.

Can you suggest any other feasible methods so that I can filter out the order data I want by calling only one interface?


Forum|alt.badge.img+1
  • Author
  • Do Gooder
  • April 17, 2026

@Abdul Thank you very much for your answer. I tried using the methods you provided, but they still don't meet my requirements.

  1. Analysis->CustomerOrderLinesHistory: Although this interface returns the modification date, it doesn't include order details (such as RouteId, CustomerNo...) and order line details (such as PartNo, Quantity...).
  2. Customer_Order_History: Currently, I'm combining this interface with the CustomerOrders interface to obtain the data I need.

Can you suggest any other feasible methods so that I can filter out the order data I want by calling only one interface?


Abdul
Superhero (Partner)
Forum|alt.badge.img+20
  • Superhero (Partner)
  • April 17, 2026

Hi ​@niexinbi,

I don't think, there is any standard interface available which can provide the information the way you are looking for, better, you should configure a quick report in a desired info and format.

Regards

Abdul Rehman


Forum|alt.badge.img+3
  • Do Gooder (Customer)
  • April 17, 2026

I want to filter customer orders based on the last update time.

However, currently, the interface for customer orders provided by the IFS system doesn't seem to support this directly.

The method I'm using at present is to filter the orders according to DateEntered first.

Then, for each order, I obtain its historical records, arrange them in reverse order, and regard the DateEntered of the first record in the record list as the last update time of the order.

Finally, I filter out the orders I need according to this time.

But this approach is very time - consuming.

What I want to ask is whether there is an interface that can obtain the order data I want in one go.

 

Hi ​@niexinbi ,

You could possibly create a custom field of type Expression for entity CustomerOrder  e.g.

v.objversion  OR  to_date(v.objversion,'YYYYMMDDHH24MISS')

 

Then add it to the page configuration?

 

Regards,

Pakorn


Forum|alt.badge.img+1
  • Author
  • Do Gooder
  • April 20, 2026

Hi ​@niexinbi,

I don't think, there is any standard interface available which can provide the information the way you are looking for, better, you should configure a quick report in a desired info and format.

Regards

Abdul Rehman

Sorry, I didn't understand your answer. Could you please provide reference documents?


Forum|alt.badge.img+1
  • Author
  • Do Gooder
  • April 20, 2026

 ​@pacharry Sorry, I didn't understand your answer. Could you please provide reference documents?