I am using HOPEX V4 CP2.
I have been using the Responsible Org-Unit MetaAssociation for a while now and have just been asked to extend it to include a few more "responsibilities" and produce a few reports.
Adding in the new "responsibilities" is easy enough.
And setting up the MetaPropertyPage and so on was not a concern.
My problem comes when I try to query the data.
I would like to extract Org-Units for an Application where the specified "responsibility" = "Y"
Select [Org-Unit] Inherited Where [Assigned Application]=&"object" And [Assigned Application].["responsibility"] = "Y". for example:
The result includes all Org Units that have an association to the Application and have an association to the "responsibility", but not a combined Application / "responsibility" association.
App1 has Org Unit 1 with Process Manager responsibility
App 1 has Org Unit 2 with IT Manager responsibility
App 2 has Org 1 with IT Manager responsibility
if I run query - Select [Org-Unit] Inherited Where [Assigned Application]="App1" And [Assigned Application].[IT Manager] = "Y" - I would get Org Unit 1 and Org Unit 2 returned, even though Org-Unit 1 does not have a IT Manager relationship with App 1.
My first thought was maybe I added the MetaAttributes to the MetaAssociation incorrectly, so I tried the query on standard Out of the Box config and got the same result.
I have gone through the query documentation and tried to find a similar query but have failed to find an answer.
Can anyone please help with this.??
Solved! Go to Solution.
Thank you so much,
I have been 3 days trying various sqls to try and get this. I didn't know you could use brackets like that.
you need to use brackets after the dot to express the two conditions should be met by a single instance when browsing the link
Select [Org-Unit] Where [Assigned Application].(name like &name And ["responsibility"] = "Y")