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 

[KevinBellardine]

One thing to check would be any query business rules on the target tables that would be filtering your results