Folks, My app has some 50+ entities. About 2 third of them have data that is specfiic to a Region, the rest of the entities is Region agnostic.
Example: Article toMany Descriptions Article is Region agnostic but can have Region specific descriptions, thus Descriptions have an optional toOne to Region Background: A user of the app is assigned a Region during login. He must be allowed to only see Region agnostic data or objects that are assigned to the current Region only. What I want is a generic way to have something like the following SQL generated by the Frameworks: select * from article where some_selection_criteria; -- no region reference select * from description where some_selection_criteria (AND REGION_ID IS NULL OR REGION_ID = A_GIVEN_REGION_ID); This must also function for queries like: select all articles that have description for region XYZ. I am thinking along the following lines: attach some code deep in the framework to add such a restricting clause to where for every select for any region specific table. How would I do this? Any better ideas? Thanks a lot ---markus--- _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
