11-03-2022 03:44 PM
Does MEGA have documentation on the ERQL language?
I look up on the internet and I didn't find anything that explain the terms and syntax to use in that language.
Solved! Go to Solution.
06-04-2022 01:27 PM
Yes, that should be in a simialr place in the V5 documentation
06-04-2022 12:03 PM
If it is not too late ....
Full documentation about how to use ERQL, syntax, examples is in the Power studio part of the documentation in HOPEX V2 I use today.
Maybe at the same place for V5 ?
06-04-2022 07:30 AM
The key to understanding the search tool in HOPEX is really to understand the meta model.
The search syntax is straight forward: Select Meta Class where Condition
The condition is then either relating to an Attribute or to a Meta Association (or a string of Meta Associations !).
Select [Org-Unit] where [Designed Organizational Process] = &name
Strings of meta associations can be connected using the . (dot)
Select [Organizational Process] where [Person Assignment].[Business Role]="Organizational Process Owner"
When using abstract metaclass use : to build the relation
Select [Organizational Process] where [System Used].[System Specification]:[Application]
06-04-2022 12:25 AM - edited 06-04-2022 12:33 AM
@epr-corpo There IS documentation, as @hsoegaard mentioned - but ERQL usage is still very challenging for new users IMHO.
I've probably spent few hours on ERQL and I can't say I've much better at it than I started.
ON the other hand - I never read a single line of documentation on servicenow filitering/querying syntax and I was able to use it from day 1.
For example, this simple HOPEX query stumped me.
List applications where "Name of Person" is "Financial Controler" .
The ERQL wizard is a nice concept - but it didn't help me. It did not have "Responsibility" or "Financial Controler" role.
Finally - plain old list of applications "Menu >> Applicaions" which shows a list of all applictions - can be filtered easilty - which is nice. But, out-of-box setup doesn't display any of the responsibility columns nor can they be added by hand through V5 web GUI (probably can with Stuidio?) .
Hopefully you found the documenation more helpful and ERQL learning easier.
11-03-2022 04:44 PM