I need help to create a report that shows the RITM record and the tasks associated with them

[nico2]

Hello, 

 I need help to create a report that shows the RITM record and the tasks associated with them, I have the first part correct. 

I'm unable to add the task and task.description that are associated to the RITM record.  Any ideas are welcome. 

See attachment. 

[Dennis R · Accepted solution]

Are you sure you don't mean the Catalog Task [sc_task] table instead of the Task [task] table? It's a bit confusing because catalog tasks are numbered with the prefix TASK, but I think that's the actual table you're looking for.

Run your report against that table and include the Request Item, Number, and Short Description columns. For the filter, if you want to filter on the task fields, that's easy enough. If you want to filter on the requested item fields (such as filtering out any tasks that belong to closed requested items), just scroll all the way down to the bottom and select Add Related Fields, then choose Request Item==>Requested Item fields, then choose the field on the requested item table you want to filter on (for example, State).

Hope this helps,
--Dennis R

[Ujjawal Vishnoi]

Create your report on Catalog task table(sc_task) and first select show related field in the filter.

Then select 

Then select the condition on parent field.

Also you can show the available column from parent.number etc.

Hope this helps.

Regards

Ujjawal