Forum Discussion

rayinala's avatar
rayinala
Mentor
9 years ago

LIQL Query Limit

Hi,

 

What is the LIQL query maximum limit , as of now we are able to fetch less than 2000 rows , and getting gateway timedout error if the limit is morethan or equals to 2000.

 

Thanks,

Ramesh.

3 Replies

  • rayinala - The maximum limit which you can pass is 1000, after that, you need to paginate.

  • donpacote's avatar
    donpacote
    Helper
    9 years ago

    i give you a kudo, i need to know how i do pagination using java.  Where ir pagination store?

  • VarunGrazitti's avatar
    VarunGrazitti
    Boss
    9 years ago
    donpacote - That would require you to do some custom coding. You have all the resources available in the API documentation section where you can find the variables to be used for custom pagination like OFFSET in LiQL and page_size and page_num in API V1.

    Here is the link to the documentation - https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal

    You can switch b/w V1 and V2 from the drop down menu.

    Appreciate your kudos :)