Database view on case table variables and sla table

[Shruti Bhosale]

Hello,

I want to create report on SLA details on case table.

But case records are created through record producer and it has variable editor and variables on that case record.

on report its not showing variables in report.

can you please suggest how i can develop database view for this it will be helpful.

Thanks and Regards,

Shruti B.

[Sohail Khilji]

Hi @Shruti Bhosale,

You need to create  a databased view with 3 tables.

1. Case table.

2. SLA table.

3. Variable table. (sc_item_option_mtom, question_answer)

[Shruti Bhosale]

[Sohail Khilji]

Hi @Shruti Bhosale ,

This will not show you the varaibles you will have to include the variables table in database view execeptionally...

[Shruti Bhosale]

Variables are not showing up as columns in report.