2 Replies Latest reply: Sep 19, 2016 10:29 AM by Noha Salem RSS

    connecting tags in qmc with section access in app

    Noha Salem

      Hi all,

       

      I have been trying to connect the tags done in the qmc with the section access in app

       

      and have done the following so far but it keeps giving me unknown error so far every time I am trying to connect with the app

       

      any suggestions what I am doing wrong?

       

       

       

      LIB CONNECT TO 'QSR';

       

      LOAD 'USER' AS "ACCESS",
           UserDirectory&'\'&UserId AS USERID;  
      [Users]:
      SELECT "UserId",
      "UserDirectory"
      FROM "public"."Users";


      INNER JOIN "Users":
      LOAD Tag_ID,
      User_ID;

      [TagUsers]:
      SELECT "Tag_ID",
      "User_ID"
      FROM "public"."TagUsers";

      INNER JOIN "TagUsers":
      LOAD ID,
      Name AS _SERIALNUMBER;

      [Tags]:
      SELECT "ID",
      "Name"
      FROM "public"."Tags";

       

      Section Access;

      LOAD * Resident "Users";


      Load * Inline
      [ACCESS,USERID,_SERIALNUMBER
      USER,BI\nohas,6159
      ];

      Section Application;

       

       

      Thanks in advance