CODEWITHSUNDEEP
vtiger
alexin
alexin

Reputation: 243

Vtiger. Change query limit

In vtiger wiki written:

Query always limits its output to 100 records, client application can use limit operator to get different records.

This query does not work:

doQuery("select * from Leads limit='200';")

How to specify the operator in a query?

Upvotes: 2

Views: 757

Answers (2)

Aitor
Aitor

Reputation: 56

The "limit" clause only works if the number given is lower than 100. You can't get more records than 100 using "limit" with 1 request.

To get more than 100 records from vTiger services you need to make various request using the "offset" in the "limit" clause.

Upvotes: 4

marc_s
marc_s

Reputation: 754993

If you really read the Wiki documentation, you'd see that you need to use:

select * 
from Leads 
limit 200;

Stop using unnecessary single quotes ('200') - the limit expects a numerical value, there's absolutely no point in converting that to a string (by using single quotes) .....

and drop the equal sign, too - it's not shown in the docs anywhere .....

Upvotes: 0

Related Questions