How can I list all closed incidents showing Resolved By not a member of the Resolved By Group?

[JLeong]

Good day!

How can I list all closed incidents showing Resolved By not a member of the Resolved By Group in Flow Designer?

I need to update all closed incidents with mis matching Resolved By and Resolved By Group. Resolved By Group should be a group that Resolved By is a member of.

The updating part in Flow Designer is easy but I need to list the records first.

Thank you in advance.

Regards,

Jocelyn

[johnfeist]

Hi JLeong,

The easiest thing would be to create a view joining incident and sys_user_grmember (the group membership table).  From there you can use that view as your data source since doing a match to sys_user_grmember on assignment group and resolved by will give you a null if the person is not part of the group.

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

[JLeong]

Hi John,

Could you please help me define the "where clause".

Thank you!

[johnfeist · Accepted solution]

Hi JLeong,

I created it to demonstrate.  Here's the basic definition:

And here's where I define the join

When you structure your query in Flow Designer, filter on state = 6 (resolved) and grmem.user is null/empty.

:{)

[JLeong]

Hi John,

Thanks sooo much for getting back to me!!! This is what I needed!

Appreciate your time and effort!

Regards,

Jocelyn