Section access- 2 cases

[parpatra]

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.

[alexpanjhc · Accepted solution]

I believe the attached document can help you with this situation.

[Emmanuelle__Bustos]

alexpanjhc

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?

[alexpanjhc]

u wanna sent the qvw?

[Emmanuelle__Bustos]

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

[alexpanjhc]

at least in the document property->opening-> strict exclusion should be checked and prohbit binary load should be checked.

[Emmanuelle__Bustos]

Hi alexpanjhc

Even if i checked both options the behaviour is the same...

[fernando_tonial]

The reduction tables need to be associated with the table that has the data.

See my example.

Best Regards.

[Emmanuelle__Bustos]

Fernando Tonial

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!