how to download the picking notes for all the orders that I have received payment

[Lory]

Hi everybody,
I need to download the picking notes for all the orders that I have received payment. That means the order must have Payment accepted status. I am trying to develop this functionality. The problem is that the ps_orders table doesn't have a current_status field for example. Does anybody have a solution for this?

Another thing what does the valid field in ps_orders table mean? When is valid 1 and when is 0?

Thank you!

[Burhan BVK]

The order status is in the order_history table, you need to check the last entry for that order to see its current status.
The order is valid when the payment is accepted.

[Lory]

thank you whitelighter for your answer!

[Totti]

I with the old version filtravo for this field, now I can not do more, how can I fix this ?

 

The field "current_state" is dynamic. It is not possible to filter GET query with this field.

Edited May 11, 2015 by Totti (see edit history)