Query to Request for IT MANAGER on ASSIGNED APPLICATION

[hdrapin]

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

[jhorber]

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

[hdrapin]

As usual, great answer !

Is there any doc on ERQL ? Thanks

[jhorber · Accepted solution]

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')