topic Does OMIT in Section Access work with hidden script? in QlikView

Does OMIT in Section Access work with hidden script?

Anonymous — Wed, 11 Feb 2015 00:46:18 GMT

I first created section access security with admin and user where user could not see cost because I had restricted it with an OMIT. I did the same this time with hidden script. Can any one help me why.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, OMIT

ADMIN, ADMIN, ADMIN123

USER, USER1, USER123, COST

];

Section Application;

this same script is working in a regular script environment. i.e. with out hidden script

Re: Does OMIT in Section Access work with hidden script?

Anonymous — Thu, 12 Feb 2015 21:53:01 GMT

Can Someone answer??

Re: Does OMIT in Section Access work with hidden script?

Anonymous — Fri, 13 Feb 2015 09:35:32 GMT

I think there is no difference between normal script and hidden script.

Instructions for using the OMIT field just say that the values in omit column don't need to be in upper case but must have the exact case of the fields names to omit.

I don't find other information... maybe you can also try to add * for ADMIN as following:

ADMIN, ADMIN, ADMIN123, *

Elena

Re: Does OMIT in Section Access work with hidden script?

maxgro — Fri, 13 Feb 2015 10:00:41 GMT

PFA

seems it works

user password

ADMIN ADMIN

hidden script password

hidden

Re: Does OMIT in Section Access work with hidden script?

Anonymous — Fri, 13 Feb 2015 10:24:45 GMT

Hello,

I have attached qvw.just check the same.

Thanks

Re: Does OMIT in Section Access work with hidden script?

maxgro — Fri, 13 Feb 2015 11:15:27 GMT

add the 2 flags

password for hidden script in attachment is hidden

Re: Does OMIT in Section Access work with hidden script?

Anonymous — Fri, 13 Feb 2015 11:24:06 GMT

Check abc BINARY

Thanks

Re: Does OMIT in Section Access work with hidden script?

Anonymous — Fri, 13 Feb 2015 11:28:01 GMT

Hello,,

Check below hidden script

pwd ADMIN123

Thanks

Re: Does OMIT in Section Access work with hidden script?

maxgro — Fri, 13 Feb 2015 11:54:11 GMT

It works in the same way

Add the flags (to binary), reload, save, reopen with user1 and (see image) for user1 field c is missing

Re: Does OMIT in Section Access work with hidden script?

Anonymous — Fri, 13 Feb 2015 12:08:37 GMT

Hello,

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, OMIT

ADMIN, ADMIN, ADMIN123

USER, USER1, USER123, c

];

Section Application;

when u login with USER, c will b omitted but hidden script option will not be available.

And if similarly u login with ADMIN with option of omit u will get hidden script as admin takes all the access.

CHECK DIS ITS AS PER YOUR REQUIREMENT AND LEMME KNOW.

Thanks

Re: Does OMIT in Section Access work with hidden script?

Anonymous — Mon, 23 Feb 2015 18:19:56 GMT

Thank you all for your help. I still have not solved this problem, that is: the file with hidden script - OMIT is not working. The file w.o. hidden script is working as authorized. please advice. I have attached the 2 files here.

1) Omit section access :- regular file

2) Hidden script :- hidden script file !

Re: Does OMIT in Section Access work with hidden script?

Anonymous — Mon, 23 Feb 2015 18:40:23 GMT

sorry, forgot to give you the pass words

Pass to hidden script: unicco160.

Thank you

Re: Does OMIT in Section Access work with hidden script?

Colin-Albert — Mon, 23 Feb 2015 18:44:01 GMT

The field names for your OMIT fields must be uppercase for OMIT to work.

Your Cost field must be renamed to COST in your data table for Omit to work.