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	boolean
rows	The data to be returned to the browser when skipQuery is set to true while defining datasource details	List<RPCModelData>
skipPagination	To fetch all the rows in at once, set this to Y while defining datasource details	NA