Data Type Management in Session Variables

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, you can perform data type conversion using the CAST function.

1. In the Data Sources module, click the + icon next to the Actions title in the left panel.
2. Select the New SQL Action option.
3. Write your query using SQL Editor. (Example SQL query:)

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

4. Save the query by clicking the CREATE button.

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

Testing SQL Action

To test the defined SQL Action:

• Run the SQL Action by clicking the Test button on the right sidebar.
• Check that the query returns correct results based on the values from the Session Variable.
• Make sure that the Session Variable values are dynamically flowing into the SQL query.

By following these steps, you can use Session Variables effectively in your applications.