Blog

Find Roles with assignments in a Workflow

Roles in Maximo are used to represent a specific person or a group of people that can be used in workflows, communication templates and escalations. If you need to find which roles are used in a specific workflow you can use an SQL query like this. SELECT wfnode.title, wfnode.description, wfa.roleid, r.descriptionFROM wfnodeJOIN wfassignment wfa ON […]

Scroll to top