Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
In the hidden script below i have coded
Section Access;
LOAD * INLINE [
ACCESS, USERID, REVIEW_FLAG
ADMIN, X113861, Yes
ADMIN, X113861, No
ADMIN, A015681, Yes
ADMIN, A015681, No
USER, X113547, Yes
];
Section Application;
in the main tab
T1:
LOAD Month, REVIEW_FLAG
FROM
As a admin i can able to log on and view both flag Yes and No
But as user i can't login , its showing as access denied, can you help me on this
I checked all the ways by selecting the initial data reduction int he settings but the user(X113547) can't able to open.
i have attached the file and sample data,to open hidden script password is test.
Are you testing this in QV Desktop or on a server?
I guess it's the former and you probably get in using the first few accounts because of them being ADMINs. Most probably, there isn't any value linking from SectionAccess to Section Application.
A first change I would implement is to not only put the link field name in upper case, but also the values in both Section Access and Section Application. E.g. in your hidden script, change the load into something like:
LOAD * INLINE [
ACCESS, USERID, REVIEW_FLAG
ADMIN, X113861, YES
ADMIN, X113861, NO
ADMIN, A015681, YES
ADMIN, A015681, NO
USER, X113547, YES
];
and change the link values in your Excel as well. In Section Access this isn't really necessary because the Section Access code will do that automatically anyway. But doing this in SA too will make you pay attention.
AFAIK you don't need passwords if you don't want to. But in that case security will be non-existent...
Hi,
Make sure you give the password field also.
Regards,
Kaushik Solanki
as per my requirement my client don't want the password..
Hi,
Strict Exclusion | If this check box is marked in combination with Initial Data Reduction Based on Section Access, strict exclusion will be used when reducing the data. This means that access to the document will be denied whenever the field values in the section access reduction fields lack matches in their corresponding section application field. This, however, does not apply for users with Admin status, who instead will see the unreduced data set if there are no matches. |
USER, X113547, Yes
Hope it helps
What is the password for the hidden script.
Regards,
Kaushik Solanki
TEST is the password
hi there is Yes value in the REVIEW_FALG field, pls see the qvw file and sample data file
Hi,
both field value must be in upper.
Use upper(REVIEW_FLAG) as REVIEW_FLAG
and try
Regards
Are you testing this in QV Desktop or on a server?
I guess it's the former and you probably get in using the first few accounts because of them being ADMINs. Most probably, there isn't any value linking from SectionAccess to Section Application.
A first change I would implement is to not only put the link field name in upper case, but also the values in both Section Access and Section Application. E.g. in your hidden script, change the load into something like:
LOAD * INLINE [
ACCESS, USERID, REVIEW_FLAG
ADMIN, X113861, YES
ADMIN, X113861, NO
ADMIN, A015681, YES
ADMIN, A015681, NO
USER, X113547, YES
];
and change the link values in your Excel as well. In Section Access this isn't really necessary because the Section Access code will do that automatically anyway. But doing this in SA too will make you pay attention.
AFAIK you don't need passwords if you don't want to. But in that case security will be non-existent...
Uncheck strict exclusion.
I tried and works