Report on both Change request table and change task table and display fields of both tables

[Bernard12]

Hi Ladies & Gentlemen,

I'd simply like to report on both Change request table and change task table and display fields of both tables.

For instance, something like: report with the following conditions:

• on all Changes with Planned end date on Last Month
• With Change tasks of the Change with State not closed

and displaying fields of both tables:

• Fields from Change Request table: Number, Planned end date, short description (of the Change Request)
• Fields from Change task table: short description (of the Change task) and State (of the Change task)

PS:

• Unfortunately, we don't have Performance Analytics.
• I don't have the admin role.
• I'd like to achieve what I asked without having to build a database view.
• In System Properties > UI Properties: "Allow base table lists (task, cmdb_ci, etc.) to include extended table fields (incident_state, os_version, etc.), and allow filtering on extended table fields" is set to YES.

[sachin_namjoshi]

Create a report on change_task table and you can dot walk to change_request table fields like below

Click on + sign next to change_request table and you can access all columns

Regards,

Sachin

[Bernard12]

Hi Sachin,

Many thanks for having answered so rapidly. I forgot to tell you I had already reached that point. The problem still annoying me is that I need to select the Changes in table Change request where the tags have a certain value (I raised another post for that specific point).

Is there any other solution you could suggest me where I could start by the table Change Request ?

Kind regards.

Bernard

[Adam Stout]

You can only dot-walk up, not down.  If you can't filter on tags, then that is the issue to resolve.

[sachin_namjoshi]

Change request and change task has 1 to many relationships.

Database view between change_request and change_task is the only option which will work for you due to all limitations you listed above.

Regards,

Sachin