This is the scenario. Two "organizations" (im avoiding the use of the word entity) sharing the same personnel. The idea is to handle artworks between those two "organizations". Being the same personnel, the idea is to share the backend, that way when the artwork is being loaded in orgA, can be later transferred or lend to orbB without retyping all the information.
From the front perspective, it must be two separated webpages. Each webpage must show the objects from that org and also the ones lent by the other.
We were thinking in one providence and two pawtuckets, pointing to the same database. But in order to have the front isolation, we must implement a filter.
Is this possible having two main collections holding the object and do the filtering in each pawtucket?
in pawtucket for orgA i would filter "collection a" and in pawtucket for orgB, filter "collection b".
Would be also possible to filter with relations, like "belongs to collection a" and "lent to collection a" and same with b.
How could i implement this filtering using pawtucket configuration?
Is this possible?
Is another way to achieve this?