Database View not pulling tickets data which were cancelled by the requestor or fulfiller.

[Zaman Sm]

Hello,

I wanted to make a report of group approval (sysapproval_group) which will contain a specific field/question from the RITM and the value as well (for specific assignment group). I have created a database view (see attached image), which is not pulling the request/approval information for cancelled requests.

Please feel free to ask any question if my question isn't clear.

Thanks a lot in advance 

[Anubhav24]

Hi @Zaman Sm ,

I would suggest you to make the database view join conditions one by one like you first execute the database view for only two tables then add the third table and then check the results.

Also check whether left join is true or false .

Please mark helpful/correct if my response helped you.

[Zaman Sm]

Hey thanks for the response, could you provide me an existing example for it, if possible.

That would be greatly appreciated. 

[Anubhav24]

Hi @Zaman Sm 

I had created one database view recently on three tables if you want I can share that.

[Zaman Sm]

That would be great!!

Thanks in advance.