Session Variables

1. After logging into the Kuika platform, open the project you will work on from the “Apps” screen.

2. Go to the “Data Sources” module. In the Data Sources module, you can view the data sources, actions and tables in the application you are developing, add a new data source, a new action and a new table.
3. Click “Edit” from the three dots in the Session Variables field on the right sidebar.

Configure the following fields from the modal that opens:

Variable field

• Key: This is the key or name you specify for the session variable. The key identifies the variable and you can access the data using this name within the system. For example, “user_id” for a user name or “username” for a language preference.
• Value: The value you set when defining the Session Variable. For example, the value of the “user_id” key could be the unique ID number of a user, or the value of the “username” key could be a name such as “user1”.
• Read Only: Determines whether the Session Variable is read only or not. If “Read Only” is checked, the session variable is read only and its value cannot be changed. If unchecked, the value of the variable can be changed during the session.

Then you can add the variable by clicking on the “ADD” button on the right side and save it with the “SAVE” button.

When using Session Variables in SQL queries, the data type of the returned data must match the data type expected by the SQL query.

If necessary, the CAST function can be used to convert the Session Variable to the appropriate data type.

1. Click on the “+” icon next to the “Actions” title on the left panel in the Datasource module.
2. Select “New SQL Action” from the drop-down menu.
3. Write your SQL query via SQL Editor. Example:

SELECT CAST(SESSION_CONTEXT(N'user_id') AS NVARCHAR(100)) AS UserName

      4. Click on the “CREATE” button at the top right.

This method ensures that the Session Variable is processed with the correct data type.

Testing SQL Action

After defining SQL Action and Session Variables, test your query:

1. Run the SQL Action by clicking on the “Test” button on the right sidebar.
2. Make sure that the query returns correct results based on the values from the Session Variable.
3. Verify that the Session Variable values are dynamically passed to the SQL query.