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:
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.
Solved! Go to Solution.
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?
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!