Webservice filter

[wallink]

Hello.

I wonder if there is any filter on the webservice?

For example if I want all orders with a specific status or all orders created after a specific date.

is this possible in some way?

[wallink]

As I didn't get any answer I tried to find the answer in the source code.

I found that you have a few filtering options:

display:

www.yourshop.com/shop/api/orders?display=VALUE

Where VALUE can be changed to 'full' or '[current_status,id...]'

display makes it possible to specify which fields should be included in the result

limit:

example limit=5 (gives 5 results), limit=5,15 (gives 10 results)

sort:

example: sort=id_ASC, sort=current_status_DESC

filter:

I know it is there but haven't figured out what to give. does anybody know?

[Burhan BVK]

You can add a filter parameter.

?filter[filedname]=value

You can add multiple filters this way. There are more options, check the function getSQLRetrieveFilter for more details.

[wallink]

Thanks.

Another thing then. It workes with most fields but not 'current_state' for order which is the one I want to filter on.

on the order I can see not_filterable="true", but why is current_state not filterable?

[Burhan BVK]

Current state is not stored within the orders table. The api gets the last order state associated with that order and shows that. That is why it can't be used to filter. You should use the "valid" field instead.

[wallink]

Thanks again. I almost have everything I'm looking for:)

The last thing I'm missing is payment information for orders.

What I need is the id that the different payment modules leaves that is connected to the order.

Some I know puts it in the order message and I guess other also puts it in the payment_cc table, but none of these can be retreived using the api, or can it?

Also, is tha payment id or transaction id ever placed in any other location?

[wallink]

Anybody who knows where payment modules stores the payment/transaction ids?

[fguespe]

Same here...

[Totti]

Hello,
I just upgraded to the latest version prestashop, before doing a filter field current_status on the orders table, but now I read that it is no longer filterable, how do I fix?