SQL Action Parameters

The following system parameters can be used when creating a SQL Action in Kuika:

Table Example
Parameter Description
@currentpage Represents the page number.
@pagesize Determines the number of records returned per page.
@kuikausername Represents the name of the logged-in user on Kuika.
@kuikauserid Represents the user's identity (GUID).

Using these parameters you can create paging, user-based data filtering and dynamic SQL queries. Especially when working with large data sets, you can optimize your queries by dividing the data into pages with @currentpage and @pagesize parameters .