How to create a report for change requests and related change tasks

Rama Rao · ‎05-15-2024

Hello,

I want to create a report for all the change requests and change tasks where configuration item is service management.

I have created a report on change_task table but we have some change requests has no change tasks. I need to show all the change requests with or without tasks in the report. Is that possible?

Can anyone please help me on this?

Thanks in advance,

Jitendra Diwak1 · ‎05-15-2024

Hi @Rama Rao,

This can be achieved by using the Database View. here database view is used to combine two table into one and then you report on it. here I am attaching the snapshot as per your requirement.

To create the database view please navigate like type database view in navigator>System Definition>Database View

Please click on New and fill the name and save the form then in related list there is View Table and click on new button and Table name, Variable prefix and where clause and save them after saving both table there is button on database view then click on related links under Try it button then you will be able get all the change request with Ctask and where no task has created. After you need to report on this table u_change_request(it is name from database view field(Name). Please try this.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Thanks

Jitendra

Please accept my solution if it works for and thumps up.

View solution in original post

Maik Skoddow · ‎05-15-2024

It's not really clear what you want to see in the report. The headline says "a report for change requests and related change tasks". But in last sentence to write "show all the change requests with or without tasks in the report". So what exactly do you want to see?

Rama Rao · ‎05-15-2024

Hello @Maik Skoddow ,

For example, some change requests have no change tasks and I want to see that change requests also in the report. Because change tasks are created when a change request is in the implement or review state and when we create a report on the change_task table, it shows only the implement, review, and close state change requests but I need all change requests(new, asses,...etc).

if not clear the requirement. Please provide your email ID and will connect 1:1

Thanks in Advance,

AndersBGS · ‎05-15-2024

Hi @Rama Rao ,

I agree with @Maik Skoddow - your statement is not clear. If you create a report based on the change_task, then you automatically say "I want to see all changes where change task is related". If you create the report based on the change_request table, then you instead reporting on change request no matter if there is 1 or more change task related.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Rama Rao · ‎05-15-2024

Hello @AndersBGS ,

Please check once and help me with this issue.