What's the maximum length of a SQL query using JS or SOAP API's? - Forum - Rollbase - Progress Community

What's the maximum length of a SQL query using JS or SOAP API's?

 Forum

What's the maximum length of a SQL query using JS or SOAP API's?

  • What is the maximum allowable length of a SQL query for both Javascript API and SOAP API? I'm trying queries of different lengths, and the longer ones get this type of error: Fatal error: Uncaught SoapFault exception: [soapenv:Server.generalException] SQL query is too long in ........ If I knew the MAX length of a query, I can separate it into multiple smaller queries if it reached that size. Thanks, Mike
  • Query cannot be longer than 5000 chars. Why do you need that long query? You should be able to use * for fields list.
  • The reason I need such a long query is because we integrated a GIS map with Rollbase. The users can select multiple properties on the map and click a button to retrieve information about the selected properties. The property information is stored in Rollbase. If they select many (250+) properties, the length of the query becomes too long.

    If they select only 3 properties the query is something like:

    SELECT address, owner, tax, block, lot FROM property_data WHERE propid IN ( '1810-002010000-000100000-00000', '1810-002010000-000040000-00000', '1810-002020000-000200000-QFARM')

    But selecting many properties will be an issue. I am probably going to use a smaller property identifier (propid) to shorten the query.

    Thanks
  • Well, looks cool, but 5000 chars query is not going to be efficient anyway. I think you should limit number of properties somehow.