8 Replies Latest reply: Jun 17, 2013 3:01 PM by emmanuelle bustos RSS

    Section access- 2 cases

    Partha Patra

      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:

       

      USERUSER_LOB

      USER1

      SALES
      USER2CAPITAL MARKETS
      USER3CREDIT RISK
      USER4SALES
      USER5CREDIT RISK

       

       

      DOCUMENT Table:

      DOCUMENTDOC_LOBDOC USERS
      DOC1

      SALES

      USER1
      DOC2SALESUSER2
      DOC3CREDIT RISKUSER3
      DOC4CREDIT RISKUSER4
      DOC5CAPITAL MARKETSUSER5

       

      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.