get_pipleline not returning correct results

[Imran Rahi]

Hi,

Another severe problem which will affect our business. Please solve and update API ASAP.
Check the below 2 API call returning same results wheras joborder_id is different.

Example 1:
http://api.catsone.com/api/get_pipelines?save_user_values=1&subdomain=iplaceconnect&transaction_code=&search=&rows_per_page=20&page_number=&sort=&sort_direction=&display_column=&filter=joborder_id%3Bisexactly%3B1882255

Actually it should return 15 results, but its returning 16 (naem 'sarah' is the extra record)

Example 2:
http://api.catsone.com/api/get_pipelines?save_user_values=1&subdomain=iplaceconnect&transaction_code=&search=&rows_per_page=20&page_number=&sort=&sort_direction=&display_column=&filter=joborder_id%3Bequalto%3B1869861
1->above 16

Actually it should return 1 result, but its returning above 16 results.

Note: We have kept transaction_code blank for security reasons.

Please look into this ASAP as we are launching our website which depends on CATS API on this Friday

Thanks in advance.

Thanks,

[Aaron Baluczynski]

We will take a look into these issues.

[Imran Rahi]

Thank you Aaron and please update us when its done.

Imran Ahmed Rahi

Team Leader

Clarion Technologies

SEI CMMI Level 3 Company

4th Floor, Tower S-4, Magarpatta City, Hadapsar, Pune- 411 028, Maharashtra, India. www.clariontechnologies.co.in

Email: imran...@clariontechnologies.co.in

MSN : imran...@clariontechnologies.co.in

Mobile: +91 9823563228

--
You received this message because you are subscribed to a topic in the Google Groups "CATS API" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/cats-api/unUVEYwFgRg/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to cats-api+u...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Aaron Baluczynski]

I looked into this issue and found some problems with your filter. Note that when the filter is specified incorrectly it is just ignored and CATS will return all results (in this case 16).

First, the column should be "id" and not "joborder_id." (To get the list of available filter columns, use get_columns.)

Second, the operator "isexactly" won't work in this case. Not all filter types are supported for all filter columns. That's not well documented in the API, but you can see which filter types are supported for columns using the web interface.

So the filters should be:

id;equalto;1882255
id;equalto;1869861

Aaron