Get order details with date

[NicolaiFriis]

Hello. 
Is there any way to get all orders with a specific status and the status update datetime? 

Order::getOrderIdsByStatus(5); returns all orders with status "closed"
OrderDetail::getList($orders[10]);  gives me the details on the orders above, but without a datetime parameter. 

I only want to get the orders which has been "Closed" within the last hour or so. 

Any ideas?

[Razi]

yes its possible, for this you can use the variable invoice_date

$sql = "SELECT * FROM ps_orders WHERE current_state = $state AND invoice_date < $date";

you can also make the condition base on different date variable

[NicolaiFriis]

Thank you Razi! 

[Razi]

Thanks

You can give a like by clicking on the gray heart below the posts.

[GoPure Kratom]

On 6/22/2020 at 7:20 PM, Razi said:

yes its possible, for this you can use the variable invoice_date

$sql = "SELECT * FROM ps_orders WHERE current_state = $state AND invoice_date < $date";

you can also make the condition base on different date variable

Is there a way to do it by just calling a method of Order class/object?

I need all orders with a certain status newer than a certain date.

I know how to do it in SQL, but I'm trying to figure out if it can be done purely within the code?