ERQL - How to queary for object creator name?

[BenAvdicevic]

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

[BenAvdicevic · Accepted solution]

@affanahmad THank you!

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

[affanahmad · Accepted solution]

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.