Perhaps the answer is to retrieve the promotions seperately e.g. getPromotionsForPage(pageId, countryCode).
On May 22, 9:52 am, Matthew <[email protected]> wrote: > Hi > > Is it possible to filter the retrieval of manytomany objects? I've > looked at readByPropertyMap() but this only allows you to filter the > top level object but not the siblings in a manytomany relationship. > > Example: I'm retriving a Page object which has a manytomany > relationship with Promotion objects i.e. PageA has X promotions linked > to it. Even though PageA has say 6 promotions linked to it I need to > filter based on session configuration e.g. if the user is on the > Australia version of the website they can only see 4 of the 6 > promotions. The filter is a flag on the Promotion table > "showAu","showNz" etc. > > Perhaps there is a better way to do this by re-modeling the database > so the Page objects are only joined to Promotion objects per country, > however I'm sure you'd still have the same problem. > > In more general terms: the 6 Promotions are related to PageA when you > are managing the relationships via an admin system but when it is > published to the user the promotions need to be filter based on their > locale. > > Platform: Transfer 1.1, CF 7 > > Cheers > Matthew --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
