Skip to main content

Idea pipeline (top 25)

Filter by idea status

Filter by product

1967 Ideas

Additional Generated session variables for Windows GUIOpen

The idea:I would like to have the log_session_id for relating to the session in Thinkwise and the application_id in addition to the filled columns. ----------------------------I'm trying to use some of the values described in this chapter:https://docs.thinkwisesoftware.com/docs/sf/business_logic#generated-session-variablesHowever, when I'm inserting those values into a (temporary) table. Most of the values are empty.This happens when using the ‘startup procedure’, but also a random ‘context procedure‘.How can I retrieve those values?The GUI used is the Windows gui: Code used:/*testing purposes*/CREATE TABLE ##Test( TimeStampert DATETIME, tsf_ipv4 NVARCHAR(100), tsf_ipv6 NVARCHAR(100), tsf_appl_lang_id NVARCHAR(100), tsf_use_log_session_id NVARCHAR(100), guid NVARCHAR(100), tsf_appl_id NVARCHAR(100), tsf_appl_alias NVARCHAR(100), tsf_original_login NVARCHAR(100), tsf_is_public_request NVARCHAR(100));DECLARE @tsf_ipv4 NVARCHAR(100) = CAST(SESSION_CONTEXT(N'tsf_ipv4') AS VARCHAR(100));DECLARE @tsf_ipv6 NVARCHAR(100) = CAST(SESSION_CONTEXT(N'tsf_ipv6') AS VARCHAR(100));DECLARE @tsf_appl_lang_id NVARCHAR(100) = CAST(SESSION_CONTEXT(N'tsf_appl_lang_id') AS VARCHAR(100));DECLARE @tsf_use_log_session_id NVARCHAR(100) = CAST(SESSION_CONTEXT(N'tsf_use_log_session_id') AS VARCHAR(100));DECLARE @guid NVARCHAR(100) = CAST(SESSION_CONTEXT(N'guid') AS VARCHAR(100));DECLARE @tsf_appl_id NVARCHAR(100) = CAST(SESSION_CONTEXT(N'tsf_appl_id') AS VARCHAR(100));DECLARE @tsf_appl_alias NVARCHAR(100) = CAST(SESSION_CONTEXT(N'tsf_appl_alias') AS VARCHAR(100));DECLARE @tsf_original_login NVARCHAR(100) = CAST(SESSION_CONTEXT(N'tsf_original_login') AS VARCHAR(100));DECLARE @tsf_is_public_request NVARCHAR(100) = CAST(SESSION_CONTEXT(N'tsf_is_public_request') AS VARCHAR(100));INSERT INTO ##TestVALUES( SYSDATETIME(), @tsf_ipv4, @tsf_ipv6, @tsf_appl_lang_id, @tsf_use_log_session_id, @guid, @tsf_appl_id, @tsf_appl_alias, @tsf_original_login, @tsf_is_public_request);