Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a QVW, which has 2 mutually exclusive data sets. One is USER information and another is DOCUMENT information. The USER section access needs to controlled by USER_LOB (line of bsuiness) and DOCUMENT section access is controlled by DOC_LOB.
Here is an example:
USER TABLE:
USER | USER_LOB |
---|---|
USER1 | SALES |
USER2 | CAPITAL MARKETS |
USER3 | CREDIT RISK |
USER4 | SALES |
USER5 | CREDIT RISK |
DOCUMENT Table:
DOCUMENT | DOC_LOB | DOC USERS |
---|---|---|
DOC1 | SALES | USER1 |
DOC2 | SALES | USER2 |
DOC3 | CREDIT RISK | USER3 |
DOC4 | CREDIT RISK | USER4 |
DOC5 | CAPITAL MARKETS | USER5 |
When USER1 Logs in, he should be able to see the data only for SALES from USER table (USER1 and USER4) and the 2 documents from DOCUMENT table (DOC1 and DOC2).
My problem is I do not how to use the section access based on 2 conditions.
Thanks in advance.
I believe the attached document can help you with this situation.
I believe the attached document can help you with this situation.
Hello.
Can you explain why if a use the code in that pdf and using the * for the admin, when it opens the document it's supposed to see all data but instead of it it only sees the ADMINGROUP (attached) data but can see anything else, i been having this problem with many documents and if i look at the table view and right clic on the aplication table and PREVIEW the data that is not shown has the value "Total" i don't understand this behaviour can you help me?
u wanna sent the qvw?
alexpanjhc Of course the qvw is attached and you will see i'm using the same script in the document in comment above "8QV9____Multi_Column_Data_Reduction.pdf
User: Admin
Pass: Admin
at least in the document property->opening-> strict exclusion should be checked and prohbit binary load should be checked.
Hi alexpanjhc
Even if i checked both options the behaviour is the same...
The reduction tables need to be associated with the table that has the data.
See my example.
Best Regards.
I tested it and works! So we always has to create that last table to make the association and so the use of "star is *" works.
I'll try with other documents thank you in advance!