Hi Gurus,
I need to create 3 packages based on the same model , however these packages will have filters on the COMPANY-ID
like
PACK1 == filter on COMPANY-ID='HU'
PACK2 == filter on COMPANY-ID='HM'
etc
This is required because an user can be a member of 1 or more companies, and he would need to create different reports on the packages....
If I am not clear, pl let me know and I will try to explain my situation better.
many thanks
Pleaseeconsider 3 different Packages that are virtually identical... only different data... and instead consider using Data-Level (Row level) security. This way you will not have to maintain 3 sets of Namespaces/Queries/Items.
Based on your Authentication Provider, you have access to what Groups the active user belongs to, and with that information, you can limit the rows to only those that correspond to their company(s). 1 set of Namespaces and queries, whose data is controlled seamlessly by the user's credentials.
If you choose to stay with 3 Packages, you will need a layer of Model Queries in 3 seperate Namespaces that will represent each company. The model Queries will differ (from namespace to namespace) only in that they will have a filter that limits the data to a specific (and different) company.
Packages, unfortunately for you, are just collections of metadata objects and are not subject to have filtering done explicitly on it or its contents. That is done in the Query Subject object.
many thanks for the reply. Your first suggestion is great.
I made a Data Security in the company table and assigned filters to specific User groups and kept just 1 package.
many thanks :-)