get_pipleline not returning correct results

30 views
Skip to first unread message

Imran Rahi

unread,
Apr 15, 2013, 3:59:33 AM4/15/13
to cats...@googlegroups.com
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

unread,
Apr 15, 2013, 10:20:04 AM4/15/13
to cats...@googlegroups.com
We will take a look into these issues.

Imran Rahi

unread,
Apr 15, 2013, 11:03:05 AM4/15/13
to cats...@googlegroups.com
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

unread,
Apr 15, 2013, 11:54:14 AM4/15/13
to cats...@googlegroups.com
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
Reply all
Reply to author
Forward
0 new messages