Change Request/Change Task Database view
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-27-2016 11:56 AM
I need to report on Change Requests opened in a given date range and on their related Change Tasks (if any).
I've created a database view joining the change_request and change_task tables. My where condition is as follows:
change_request prefix = cr where clause = EMPTY left join = false
change_task prefix = ct where clause = ct_change_request = cr_sys_id left join = false
My understanding is that this should yield all Change Requests and any Change Tasks whose "Change Request" field value matches a Change Request sys_id.
What I get instead is only Change Requests that have Change Tasks related as well as those Change Tasks. We often have Change Requests with no Change Tasks related (yet) and need to see those in the report as well. For some reason this is eluding me. Any help would be greatly appreciated.
- Labels:
-
Analytics and Reports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2016 08:44 AM
Hi Rashmi,
Creating a single view with hundreds of fields sounds like a bit of an administrative issue as well as confusing to any users trying to consume that. Have you thought about using this property to show extended fields on lists and reports?
(change INSTANCE to your instance name)
