Hello,

I am trying to write a SQL query that finds cases that are created by users of a specific work group.

So I have these:

Workgroup Name: Lets say it is called “XXX”

Workgroup ID: is 123

User who created it is someone in that work group ( workgroup 123 which is XXX)

Now I want to filter all cases like this:

*** WORKGROUP ( WORKGROUP_ID ( CREATED_BY(CASE_ID))) LIKE XXX

I have used this to find those cases that the owner belong to XXX:

&AO.CC_CASE_WORK_GROUP_API.GET_NAME(&AO.CC_CASE_TRACKER_API.GET_WORK_GROUP_ID(&AO.CC_CASE_API.Get_Owner(CASE_ID))) LIKE XXX

Ideally I need something to give me more freedom to filter by case information.

I can use CREATED_BY LIKE ‘USER1’ or CREATED_BY LIKE ’USER2’. The only problem is when a user leaves or join the company, as I have to manually edit the query.

It would also be great if someone can show me how I can find a complete list of “&AO.CC_CASE_ …..”

Thank you in advance.