Hi Bharath, 

I created a database view based on your instructions but on the sc_task table, but when I did a -Try It- I received this:  //"Error MessageSyntax Error or Access Rule Violation detected by database ((conn=40938431) Unknown column 'sctsk_sys_id' in 'on clause"

I tried it with and without left join on both tables...still same results. I have the admin role

Any advice?