Custom Reporting -- hotlinks
Is there an easy way to write a report using a custom query with hotlinks to other areas of the system?
I've tried getting the query to output the appropriate anchor tag in its select, but the output seems to be sanitized.
Example:
SELECT chdt.CHANGEID 'Change ID',chdt.TITLE 'Title'
FROM ChangeDetails chdt
inner join apprstagetochange astc on chdt.changeid =astc.changeid
inner join approvaldetails ad on astc.approval_stageid = ad.approval_stageid
where statusid = 1
I'd like the changeid to hotlink to the appropriate change.
Thanks,
Jason Weiss
I've tried getting the query to output the appropriate anchor tag in its select, but the output seems to be sanitized.
Example:
SELECT chdt.CHANGEID 'Change ID',chdt.TITLE 'Title'
FROM ChangeDetails chdt
inner join apprstagetochange astc on chdt.changeid =astc.changeid
inner join approvaldetails ad on astc.approval_stageid = ad.approval_stageid
where statusid = 1
I'd like the changeid to hotlink to the appropriate change.
Thanks,
Jason Weiss