cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

ERQL - How to queary for object creator name?

BenAvdicevic
Honored Contributor

Hello,

 

I am trying to use ERQL to search for all repository objects (e.g. applicaitons, application systems, flows, exchange contracts) created by a specific user.

 

For example,

 

SELECT application WHERE creator.name LIKE "Ben"

  /* This returns a list of applications crated by a Person whos name contains "Ben" */

 

Its not clear to me how to get to the object creator in HOPEX metamodel.


Thanks in advance for any tips.

Ben

2 Replies

BenAvdicevic
Honored Contributor

@affanahmad THank you!

Only thing I had to change is to add # characters -  "#Test#" !


affanahmad
New Contributor

Hello,

You can use these types of attributes as column names as you see while fetching data.

For example

Creator Name:
Select [Application] Where [Creator Name] Like "Test"

Reading Access Area

Select [Application] Where [Reading access area]

Thanks and enjoy Hopex.