SQL Action Parameters

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

• @currentpage: Represents the page number.
• @pagesize: Specifies the number of records to return per page.
• @kuikausername: Represents the name of the user logged into Kuika.
• @kuikauserid: Represents the user’s identifier (GUID).

You can use these parameters to implement pagination, user-based data filtering, and dynamic SQL queries. Especially when working with large datasets, you can optimize your queries by dividing the data into pages using the @currentpage and @pagesize parameters.