Select record viewing
Posted: 2016-04-11 16:26
Hi all,
I have started a new project today using Appgini 5.5 and have ran in to a problem which I haven't seen a solution to on the board. Wondering if anybody can help.
The scenario is as follows;
Its a revenue management system used by multiple companies and agents of these companies.
So lets say Company A & Company B are competing companies using the system. Obviously we don't want them seeing each others data so normally I would set the GROUP (Company) permission to only be able to view,edit etc. it's own group.
That's great it works but then Company C comes along who is a service provider who is collecting revenue for say Company A & B.
Again Company C is set up as a group and only has permission to see/edit it's own group.
So now for example Company A also needs to see records relating to itself from Company C (but not the records relating to Company B).
My solution reasoning so far;
When writing a record a Company needs to be assigned to the record. for A & B this would ideally be Automatically assigned but Company C would get a drop down menu with the companies that it had contracts with only (in this example A & B).
The permissions for the above would be controlled by the DATABASE ADMIN only, not the companies.
So I have no clue how the above would work but then following on from this;
Again the DATABASE ADMIN would be able to grant access for say Company A to see Company C records but only ones that had their above variable set to Company C.
This is as far as I got. Hope that I have been somewhat clear. If anybody has any ideas that would be great! And thanks a lot for reading!
I have started a new project today using Appgini 5.5 and have ran in to a problem which I haven't seen a solution to on the board. Wondering if anybody can help.
The scenario is as follows;
Its a revenue management system used by multiple companies and agents of these companies.
So lets say Company A & Company B are competing companies using the system. Obviously we don't want them seeing each others data so normally I would set the GROUP (Company) permission to only be able to view,edit etc. it's own group.
That's great it works but then Company C comes along who is a service provider who is collecting revenue for say Company A & B.
Again Company C is set up as a group and only has permission to see/edit it's own group.
So now for example Company A also needs to see records relating to itself from Company C (but not the records relating to Company B).
My solution reasoning so far;
When writing a record a Company needs to be assigned to the record. for A & B this would ideally be Automatically assigned but Company C would get a drop down menu with the companies that it had contracts with only (in this example A & B).
The permissions for the above would be controlled by the DATABASE ADMIN only, not the companies.
So I have no clue how the above would work but then following on from this;
Again the DATABASE ADMIN would be able to grant access for say Company A to see Company C records but only ones that had their above variable set to Company C.
This is as far as I got. Hope that I have been somewhat clear. If anybody has any ideas that would be great! And thanks a lot for reading!