cancel
Showing results for 
Search instead for 
Did you mean: 

Query to Request for IT MANAGER on ASSIGNED APPLICATION

Solved
Highlighted
Contributor

Query to Request for IT MANAGER on ASSIGNED APPLICATION

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

Tags (2)
3 Replies
MEGA

Re: Query to Request for IT MANAGER on ASSIGNED APPLICATION

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

Jerome
Contributor

Re: Query to Request for IT MANAGER on ASSIGNED APPLICATION

As usual, great answer !

 

Is there any doc on ERQL ? Thanks

MEGA

Re: Query to Request for IT MANAGER on ASSIGNED APPLICATION

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

Jerome