I am confused on getting Sales Order via API. 

1. I have a function that gets all Sales Order whose status is 'Waiting On Payment'. There are a total of 15 'Waiting On Payment' sales orders. However, I can only get 11 out of 15 'Waiting On Payment' sales orders. What happen to the rest ? Why dont they show up ?

2. So, I decide to test on the terminal using CURL. This is my curl command. (which is the same as my api function use)

curl "http://crm.zoho.com/crm/private/json/SalesOrders/getSearchRecords?apikey=myapikey&ticket=myticket&newFormat=2&selectColumns=All&searchCondition=(Status|contains|*Waiting On Payment*)"

Note: i replace real apikey/ticket with a fake name.

But I get -> {"response":{"nodata":{"message":"There is no data to show","code":"4422"},"uri":"/crm/private/json/SalesOrders/getSearchRecords"}}

This does not make any sense. The curl use the same ticket/apikey/parameter and value as my API function. However, i get a 'no data to show' message. In the other hand, my API function gives me 11 out of 15 sales orders.

Please help ASAP.

Regards,