Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Help for using section access with sharepoint list data

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;

4 Replies
kuba_michalik
Contributor III

Re: Help for using section access with sharepoint list data

Have you enabled Initial Data Reduction Based On Section Access in Document Properties : Opening ?

Also, if you want those stars to work (I assume they are to mean "everything"?), you need to put

STAR is *;

before loading the DocSecurity table. Otherwise it will look for users who have literal stars as their PersonelID.

It is prudent to put

STAR is;

right after loading this table, to turn it off again (it will remain in effect for already loaded data).

Not applicable

Re: Help for using section access with sharepoint list data

Hi Jakub ,

Yes , due to my searches for sloving my problem I have enabled Initial Data Reduction Based On Section Access in Document PropertiesmOpening tab  and also I added STAR is * in the right place but it still doesnt work ! I think  there is something about table relations or like this . and it's interesting that the filter seems to work when a user run the report exe file , but any effect when try to open it on the web ! how they can be different?!

kuba_michalik
Contributor III

Re: Help for using section access with sharepoint list data

Do you mean the Section Access works when opening qvw app in the QlikView desktop locally, but doesn't when opening it on the Access Point? That would be very strange. Just to be sure, by not working you mean just the filter not working, not the app failing to open at all on the Access Point?

Not applicable

Re: Help for using section access with sharepoint list data

Hi Jakub

Yes I mean just the filter not working.

Community Browser