How to use the filter parameter?

[David Bann]

I am trying to test the get_joborders API but I am having trouble testing the filter parameter.

If I want to return all Active job orders, what would I need to do?

This is what my URL looks like so far:
http://api.catsone.com/api/get_joborders?save_user_values=1&subdomain=k5erp&transaction_code=xxxxxxxxxxxxxxxxxxxx&search=&rows_per_page=50&page_number=&show_columns=&sort=location&sort_direction=asc&display_column[]=ID&display_column[]=title&display_column[]=description&display_column[]=type&display_column[]=location&display_column[]=duration&display_column[]=status&list=&filter=status%3Bequalto%3BActive

It still returns all job orders - not only Active ones...

[Aaron Baluczynski]

Hi David,

It looks like you're doing it correctly, so there's probably a bug here. Let me get back to you on this.

Aaron

[Aaron Baluczynski]

Hi David,

You need to use the "isexactly" operator in this case, so the filter looks like: status;isexactly;Active

Not all filter operators are available for every field. Unfortunately the API is not clear about what fields are available where.

Aaron

[David Bann]

Thanks Aaron – works like a charm now… Much appreciated!

 

Regards,

 

David

[bart Lugt]

This is not true Aaron, if you look at getColumns you will see that there are filter operators indicated to what degree you can filter upon. 

Isn't it so?

Bart

Op vrijdag 15 juni 2012 18:50:51 UTC+2 schreef Aaron Baluczynski:

[Aaron Baluczynski]

Hi Bart,

Yes, the get_columns call was added since that reply was written in 2012.

Aaron