> For the complete documentation index, see [llms.txt](https://docs.cloudio.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cloudio.io/creating-datasources/working-with-datasources/creating-a-data-source/defining-a-pre-query/pre-query-variables.md).

# Pre-query variables

| **Variable**       | **Description**                                                                                                                                                                                                 | **Datatype**        |
| ------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------- |
|                    |                                                                                                                                                                                                                 |                     |
| **data**           | An RPCModelData instance that contains user's input from the search panel                                                                                                                                       | RPCModelData        |
| **whereClause**    | The system generated whereClause, if any                                                                                                                                                                        | StringBuilder       |
| **params**         | Binds values in an array of objects                                                                                                                                                                             | ArrayList\<Object>  |
| **selectClause**   | The select portion of the SQL query                                                                                                                                                                             | StringBuilder       |
| **fromClause**     | The from portion of the query                                                                                                                                                                                   | StringBuilder       |
| **orderByClause**  | The order by clause of the query, if any                                                                                                                                                                        | StringBuilder       |
| **fullSQL**        | selectClause + fromClause + whereClause + orderByClause                                                                                                                                                         | StringBuilder       |
| **db**             | An instance of ScriptUtil class                                                                                                                                                                                 | NA                  |
| **dateUtils**      | An instance of DateUtils class                                                                                                                                                                                  | NA                  |
| **user**           | The username of the signed in user                                                                                                                                                                              | NA                  |
| **userid**         | Userid of the signed in user                                                                                                                                                                                    | Double              |
| **subDomain**      | The subdomain of the current application                                                                                                                                                                        | NA                  |
| **dsName**         | The alias name of the current datasource                                                                                                                                                                        | NA                  |
| **skipQuery**      | To skip the query execution, set this to true while [defining datasource details](/creating-datasources/working-with-datasources/creating-a-data-source/defining-data-source-details.md)                        | boolean             |
| **rows**           | The data to be returned to the browser when skipQuery is set to true while [defining datasource details](/creating-datasources/working-with-datasources/creating-a-data-source/defining-data-source-details.md) | List\<RPCModelData> |
| **skipPagination** | To fetch all the rows in at once, set this to **Y** while [defining datasource details](/creating-datasources/working-with-datasources/creating-a-data-source/defining-data-source-details.md)                  | NA                  |