Question about Database Security profile

LATTALI AHMED
LATTALI AHMED Active Partner
10 Comments Second Anniversary 5 Likes
in Platform

Hello,

 

 

 

I have an entity "Product" with 3 parents in the same level (Activity, Agency and Society)

 

              ---> Activity

Product ---> Agency

              ---> Society

 

Each user has access to one society, (To achieve that, I Filtered on the entity "Society" in the database security).

 

However Every user should have access to all members of the entities "Activity" and "Agency" even if he doesn't have products that are related to this members.

 

Is it possibl#e to achieve that in the database security profile ?

 

Thanks

any help would be appreciated.

 

 

Best regards

Ahmed Lattali

Answers

  • Alexander Kappes
    Alexander Kappes Employee
    Fourth Anniversary 250 Likes 100 Comments 5 Answers

    Dear Ahmed Lattali,

     

    thanks for your request.

     

    It is not possible doing such because of the relationship idea BOARD implemented.

     

    When you select one Society, BOARD is doing the following:

     

    1. depending to your select it looks for all related Products

    2. depending to the products the other aggregations (Agency and Activity) are selected.

     

    When the user didn´t have products related to a special Agency or Acitivity the element isn´t visible for him.

     

    For sure you can solve using Dummy Elements inside your product to see all Agencies and Activities but in my opinion it doesn´t really make sense.

     

    Hope it helps

     

    regards


    Alexander Kappes

  • LATTALI AHMED
    LATTALI AHMED Active Partner
    10 Comments Second Anniversary 5 Likes

    Dear Alexander Kappes,

     

     

    Thanks for your reply,

     

    In my opinion, I think it makes sense depending on the business. If we say for example, next year a society "A" will start selling new products that belong to Activity  "C" for the first time. These new products are going to be created in Board directly because they don't exist in their ERP.

    When a society "A" user creates a product using ATO pager he/she will not have the possibility to choose Activity "C".

     

    Dummy Products seem to be the only way to achieve that.

     

    Thanks Alexander  again for your help,

     

    Best regards

    Ahmed Lattali

Categories