4 Replies Latest reply: Nov 1, 2014 5:01 AM by Farzaneh Aqabeyki RSS

    Help for using section access with sharepoint list data

    Farzaneh Aqabeyki

      Hi ,

      I have created a report in qlikview with all user's entry-exit times to show them how many hours they work and how many hours they have delay per month, now I wanna publish the report in our sharepoint portal but each of them is suppose to see just her/his report, means when they log in with their usernames and password, the report has to show just those information which is related to them . I made a list in sharepoint (as you can see in the picture) which user's access information and add the below script part in my report script , but it doesnt work did I miss s.th?

       

      Thanks

       

      PersonelInfo:

      LOAD * INLINE [

          RowNumber,PersonelId,ows_Author

        1,9,9;#Mohsen Kermani

          2,10,10;#Mehdi Etehadi

          3,13,13;#Mis Bahrami

          4,30,30;#Mis Shahi

          5,38,38;#Mis Aqabeyki

      ];

       

      AccessInfo:

      LOAD ows_NTNAME as NTNAME,

          ows_SAUSER as SAUSER,

          ows_TABACCESSSHEET1 as TABACCESS.SHEET1,

          ows_TABACCESSSHEET2 as TABACCESS.SHEET2,

          ows_FIELDACCESSDIVISIONFILTER as FIELDACCESS.DIVISIONFILTER,

          ows_Title as ACCESS

      FROM [http://10.130.11.3/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={1D93957E-BD48-428A-B599-3F2D811982C3}&View={61BFBA78-3020-4081-B475-FA0EDBBB944D}] (XmlSimple, Table is [xml/data/row]);

       

      Section Access;

      SATABLE:

      LOAD

      ACCESS,

      NTNAME,

      SAUSER

      Resident AccessInfo;

       

       

      Section Application;

       

      DocSecurity:

      LOAD

      SAUSER,

      TABACCESS.SHEET1,

      TABACCESS.SHEET2,

      FIELDACCESS.DIVISIONFILTER as PersonelId

      Resident AccessInfo;