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.