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.

[Shruti Bhosale]

can you please help me with where clause in sc_item_option_mtom with case table.

as we can map clause with request_item field available on table