Hi,
I'm not sure about how to model the following case:
- I have business objects (vendors) and make a comparison of each pair of them, so a comparison is always related to two business objects
- The comparison is symetric, so I only want to have one comparison dataset: aRb or bRa but not both.
- I need a query which gets a business object (a) and returns all other business objects (b), so that a comparison result exists: aRb or bRa
Has anyone a hint how to model this cleanly? Currently I have a result object with two fields for the business object, but with that I always have to write something like "select result.firstVendor where result.secondVendor = paramValue union select result.secondVendor where result.firstVendor = paramValue"...
Thanks in advance,
Thorsten
|