topic QSense: How to get the current stream name in App Development

QSense: How to get the current stream name

Anonymous — Fri, 15 Dec 2017 15:10:10 GMT

Hi everybody!

Is there any function or instruction that retrive the current stream name that is running the Qsense application on the server?

I developed an application “DATA_Mayuda” in the hub server. The application connects to a database. Then read a table, generate a QVD, and finally drop the table. All that works well.

LIB CONNECT TO 'Mesa de Ayuda QA';

WorkOrder:

SQL SELECT * FROM servicedesk.workorder;

STORE WorkOrder into [lib://QlikShared/_Test\Mesa de Ayuda\QVD\workorder.qvd];

Drop Table WorkOrder;

Now, I need to store the QVD file according to the current stream. But I don´t know how to resolve it.

LIB CONNECT TO 'Mesa de Ayuda QA';

WorkOrder:

SQL SELECT * FROM servicedesk.workorder;

-- FunctionThatRetriveCurrentStream (vCurrentStream); ?????

If vCurrentStream = “Testing” then

STORE WorkOrder into [lib://QlikShared/_Test\Mesa de Ayuda\QVD\workorder.qvd];

Else

STORE WorkOrder into [lib://QlikShared/_Production\Mesa de Ayuda\QVD\workorder.qvd];

End if

Drop Table WorkOrder;

Thanks in advanced.

Ulises Yair Ogaz | Analista Técnico/Desarrollador JDE - SISTEMAS

Laboratorios Casasco S.A.I.C.

Re: QSense: How to get the current stream name

Peter_Cammaert — Fri, 15 Dec 2017 16:11:10 GMT

You posted a Qlik Sense question in a forum called "QlikView App Development". Please move your question to an appropriate Qlik Sense forum by following the steps specified here: QlikCommunity Tip: How to move your discussion thread

Thanks.

Re: QSense: How to get the current stream name

felipedl — Fri, 15 Dec 2017 16:16:20 GMT

Hi Ulises,

There's no function to get the stream of an app in the script side.

For what you want, you could do two apps differentiating between Test and Prod environment.

Would be the same code, but with different stores.

- Test env

LIB CONNECT TO 'Mesa de Ayuda QA';

WorkOrder:

SQL SELECT * FROM servicedesk.workorder;

STORE WorkOrder into [lib://QlikShared/_Test\Mesa de Ayuda\QVD\workorder.qvd];

Drop Table WorkOrder;

- Prod env

LIB CONNECT TO 'Mesa de Ayuda QA';

WorkOrder:

SQL SELECT * FROM servicedesk.workorder;

STORE WorkOrder into [lib://QlikShared/_Production\Mesa de Ayuda\QVD\workorder.qvd];

Drop Table WorkOrder;

Re: QSense: How to get the current stream name

Anonymous — Fri, 15 Dec 2017 19:04:46 GMT

Thanks Peter. I've moved it to Qlik Sense - App Development & Usage

Ulises Yair Ogaz | Analista Técnico/Desarrollador JDE - SISTEMAS

Laboratorios Casasco S.A.I.C.

Re: QSense: How to get the current stream name

pjaredchurch — Thu, 23 Aug 2018 23:59:07 GMT

You can do this using the Qlik monitoring connector:

Here is the function I've done this morning (based on the load script in the Operations Monitoring app) to do exactly the same issue you're looking at.

The function is based on the load script from the Operations Monitoring App:

https://help.qlik.com/en-US/sense/June2018/Subsystems/Monitoring/Content/OperationsMonitor/Operations-monitor-app.htm

You pass the ObjectID of the app you care about (you can get that using function: DocumentName()) and when the function completes the global variable 'vReturn' will hold either the Stream name or 'Unpublished'.

SUB fGetAppStream(id)

LIB CONNECT TO 'monitor_apps_REST_app';

RestConnectorMasterTable:

SQL SELECT

"id" AS "id_u4",

"name" AS "name_u3",

"published",

"__KEY_root",

(SELECT

"name" AS "name_u2",

"__FK_stream"

FROM "stream" FK "__FK_stream")

FROM JSON (wrap on) "root" PK "__KEY_root";

// LET NumRows_monitor_apps_REST_app = NoOfRows('RestConnectorMasterTable');

map_stream:

Mapping LOAD

[__FK_stream] AS [__KEY_root],

[name_u2] AS Stream

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_stream]);

App_Stream:

LOAD

[id_u4] AS ObjectId,

name_u3 as [App Name],

ApplyMap('map_stream',__KEY_root,'Unpublished') as [App_Stream]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__KEY_root])

and id_u4='$(id)';

;

DROP TABLE RestConnectorMasterTable;

if NoOfRows(App_Stream) <> 1 then

trace ERROR;

set vReturn='Unpublished';

else

let vReturn = peek('App_Stream','0','App_Stream');

end if;

drop table App_Stream;

ENDSUB

Re: QSense: How to get the current stream name

yann_courtet — Mon, 17 Dec 2018 17:16:09 GMT

This should be simpler, and should always work based on database integrity.

// Get The Stream Name or Unpublished 
let vDoc = DocumentName();

LIB CONNECT TO 'Repository';
 
APPS:
LOAD ID as App_ID, Stream_ID;
SQL SELECT "ID", "Stream_ID" FROM "QSR"."public"."Apps" WHERE "ID" = '$(vDoc)';

LEFT JOIN(APPS)
LOAD ID as Stream_ID, Name as Stream_Name;
SQL SELECT "ID", "Name" FROM "QSR"."public"."Streams";

let vStream = peek('Stream_Name',0,'APPS');

If IsNull(vStream) then 
	let vStream = 'Unpublished';
end if;

drop table APPS;

Re: QSense: How to get the current stream name

Raymzzz — Thu, 10 Mar 2022 14:07:58 GMT

Hi Yann,

when I run this code, I get the message : "Connection 'Repository' not found". Do you have an idea what could be wrong? Thanks in advance.

Re: QSense: How to get the current stream name

yann_courtet — Thu, 10 Mar 2022 14:32:09 GMT

You should create a connection to your repository database first.

Re: QSense: How to get the current stream name

hewemel1 — Tue, 21 Feb 2023 16:43:35 GMT

Thanks for this solution. It works like a charm.

Does it bring a security issue? And if yes, how could this be handled?

(In my environment, many apps with several developers would profit from using this mechanism in their scripts: Based on the stream, folder connections for include commands and for QVD data read/write could be switched when an app goes from a DEV stream to a PROD stream. But then, the qliksense service user need to have access to the repository db connection. Using this, any developer can fully read the repository, after its app has been published... We have just started the migration from QlikView to Qlik Sense. So, my knowledge is still very limited. Please excuse if my question does not make sense...)

Re: QSense: How to get the current stream name

marcionaraujo — Mon, 15 Sep 2025 22:29:17 GMT

Could I make a specific App that store this data (list of Apps with Streams) into a QVD, so i just provide the needed information, not the full connection?