04-07-2016 05:12 PM
Hi,
There is a link between Application and ORG-UNIT. The Meta-Association is called [ASSIGNED APPLICATION]
So if you want to retrieve all ORG-UNIT assigned to an application this query will work :
Select [Org-Unit] Where [Assigned Application].[Name] ="My Application"
But I'm getting very strange results when I want only [IT MANAGER] using this query :
"Select [Org-Unit] Where [Assigned Application].[Name] ="MyApplication" And [Assigned Application].[IT Manager] ='Y'
In some cases, I'm getting also Business Manager, Risk Manager...
What is the correct query in "typed" meta-association ? Thanks
Solved! Go to Solution.
06-07-2016 03:35 PM
Hello hdrapin
See HOPEX Studio, Query syntax, section 'Grouped conditions'
http://community.mega.com/t5/HOPEX-V1R2-V1R3/HOPEX-V1R2-V1R3-Technical-Articles/ta-p/8061
05-07-2016 09:34 AM
As usual, great answer !
Is there any doc on ERQL ? Thanks
04-07-2016 05:16 PM - edited 04-07-2016 05:19 PM
Hello haring
With ERQL queries, you have to 'factor' the MetaAssociationEnd so that the 2 conditions are considered with a AND operator
Rather than
Select [Org-Unit] Where [Assigned Application].[Name] ="MyApplication" And [Assigned Application].[IT Manager] ='Y'
Try this
Select [Org-Unit] Where [Assigned Application].([Name] ="MyApplication" AND [IT Manager] ='Y')