Forum Discussion

reddy6400's avatar
reddy6400
Frequent Visitor
6 years ago

Dynamic Row Level Security-with Distinct Location ID

Hi All, Please suggest how to implement Dynamic Row Level Security for my below scenario.   I have 2 tables.One is main report data table(sales by Location) and 2nd table is Location table. My 2n...
Need Help
reddy6400's avatar
reddy6400
Frequent Visitor
6 years ago

nandukrishnavs 

 

Sorry,Data in SALES_BY_LOCATION has same multiple Location ID's.
I have mutile Location ID's in both the tables(many to many).

I have to get distinct Location ID from Table 2 and join to table1.

reddy6400's avatar
reddy6400
Frequent Visitor
6 years ago

nandukrishnavs ..Getting below error when i join both the tables.

 

 

  • nandukrishnavs's avatar
    nandukrishnavs
    Community Champion
    6 years ago

    reddy6400 

     

    What is the error message?

     

    if your location id and sales combination is repeating, you can select both column and remove duplicate. If the sales values are different, then you can group by location id. (Edit Query)

    • reddy6400's avatar
      reddy6400
      Frequent Visitor
      6 years ago

      nandukrishnavs 

       

      When i drag Email ID(Table-2) to the report.It is giving me below error.

       

       

      • nandukrishnavs's avatar
        nandukrishnavs
        Community Champion
        6 years ago

        reddy6400 

        Click on see details, and see what is the error message.