...
For the convenience of our customers, this Library contains pre-built AdHoc Grids that anyone may copy and add to their PCR-360 application. If you require an AdHoc query not provided by this Library, please contact your Account Manager to request Professional Services; your Account Manager will provide you with a quote to create an AdHoc tailored to your needs.
...
- Navigate to Admin > AdHoc Grids > Manage Grids.
- Click the
button. - The SQL field accepts any valid SQL select statement. Copy the desired query from this Library into this field.
- Click the
button, on the Saved Queries tab to save the query.
The following functions are not allowed for use: INSERT, UPDATE, DELETE, DROP, ALTER, CREATE, TRUNCATE, EMPTY, and SELECT INTO.
RECID vs. ROW ID
Insert excerpt How to get RECID values How to get RECID values nopanel true
...