3 Replies Latest reply: Dec 15, 2017 2:04 PM by ULISES YAIR OGAZ RSS

    QSense: How to get the current stream name

    ULISES YAIR OGAZ

      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.