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 123User 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 XXXIdeally 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.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.