need help with database view

[priyanka chodip]

Hi There,

i have a requirement to get cases with a,b,c groups that has an sla or not
so i created tables below

result looks like below

it is acutally getting SCTASK,Case and other as well.
but i need only Case table data.
please advice on it.

Thankyou

[Dr Atul G- LNG]

Add a condition to task types or numbers starting with ‘CS’ in the result

[priyanka chodip]

Hi,

but the other issue is its fetching all the assignment groups including the group sysids i gave in the whereclause. 

[Dr Atul G- LNG]

Hi @priyanka chodip 

Did you try filtering based on the task type to see if it still shows the Sys ID?

[priyanka chodip]

Hi @Dr Atul G- LNG 

i tired like below and its fetching all cases which has sla and dont have an sla. but i'm unable to achieve the last piece of it to get based of assignment groups.
i need cases with sla and without sla with specific assignment groups.

can you guide me how can i fetch it.
if i give case_assignment_group = 'sys_id' in where clause and try, its fetching call SLAs including sctasks,cases and other.