List Report links - how to change them?

axelortiz · ‎04-29-2014

I have a List report based on the Project Task Link table. In the results I am displaying the Top Project, the Project Task Link, and the Linked.Task (in this case it is Change Request). When the report produces the list of results, the link off the Change Request points to the Project Task Link. I would like to change this link to point to the actual Change Request. Is this possible? If so, how is this accomplished? Thanks.

andrew_venables · ‎04-30-2014

I think you may have misunderstood, screenshots with similar example in's below. What you need to do is replace the dot-walked fields for 'number' with the reference fields themselves, so you have:

and what you need to get to:

Notice how you have used the Change Request.Number and i have just used Change Request. I didn't press the green plus, i just chose the reference field and moved it right to the selected bucket.

Give that a go!

View solution in original post

Slava Savitsky · ‎04-29-2014

For easier understanding of your question, could you please add a screenshot of your report? Thanks.

Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/

axelortiz · ‎04-29-2014

Hi Slava,

Attached is an image with screenshots of the report and the result of clicking on the CHG record link that ServiceNow produces. I can understand why it defaults to the Project Task Link record since the report is built from the pm_project_task_link table. However if I try to create a similar report from the change_request table I get an error (The element type "td" must be terminated by the matching end-tag "</td>".). So at this point I am only able to create this report list using the pm_project_task_link table. Thanks.

Bhavesh Jain1 · ‎04-29-2014

I see that the first field in your list layout is change request number. Normally the first field always points to the table on which we are doing reporting and in this case it is Project Task Link. Move this field to 2nd or 3rd position in the list layout and check.

andrew_venables · ‎04-30-2014

Hi Axel, You need to change the first column in your report to just be the 'Linked Task' field without dot-walking to the 'number' column on that table. Because the number column is usually the display column anyway this will not change anything on your report but will fix your issue.

Andy