Db: {{option}}   Name   |  SAVE |  CANCEL |       {{inerr}}   {{spars}}

Query name : {{csql.queryname}}
Parameters : {{params}}*
Method : GET
Sample request : {{runstat}}
* parameters should have not null values at test or run time

Queries HELP

Custom SQL can be set and used with REST API server, the server accept only server side stored SQL's for security reasons.
Here you can set the SQL statement to be used. It sould be PostgreSQL compatible SQL syntax. Only SELECT statements are allowed!

Parameters can be used with your SQL SELECT statement, see next sample of a SQL and REST API request:

SELECT * from stocks where productid = &pid

Always prefix you parameter name with " &" (spaceand) like in previous sample.

The REST command for the service is:
https://yourserveraddress/rapid/rpdquery?csql=nameofthesql&[par1=val1&par2=val2] ...&limit=0&offset=0

limit = number of returned records (0 defaults to 1000/ 10 records for test)
offset = number of records set to return (pagination)

Check also CRUD help chapter.