2

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?

alexin
  • 243
  • 1
  • 15

2 Answers2

4

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.

Aitor
  • 56
  • 1
  • 4
  • I found the [solution](https://github.com/gizur/gizurcloud/wiki/System_Documentation%23Design%23lib%23vTiger) for setting a limit on the server. it is correct? – alexin Jun 10 '16 at 08:44
0

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 .....

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
  • thanks for the answer. I tried different options. a variant spelling of the same does not work. `doQuery("select * from Leads limit 200;")` – alexin Jun 09 '16 at 12:20