I'm working on a dashboard widget/nag device for tracking ticket sla's, and I'd like to be able to set the ticket number as a hyperlink. I've tried a couple ways that I can think of, but it turns out ugly real fast (plus it doesn't work). Anyone know the correct way to do this? screen shot of attempted output below.

If you ran a regular Ticket Report, the ticket name is linkified to the link. Because you are writing an SQL report, this doesn't apply. You actually weren't far off. It looks like your HTML was a little malformed. Here is an example that works for me when running a portion of your SQL and turning the ticket ID into a link to the ticket on the helpdesk:

oi, just realized how stupid that attempt would've been anyway, as it wouldn't work in any report except the one it was created at anyway. blah, there has got to be a better way.

is there a macro that I'm missing? one that would be something like %spiceinstalllocation% to be used in these? sorry to be so dense, but I see this code get generated by the spiceworks provided widgets, I just have no idea how they're doing it.

Its going to be very difficult to link-ify a ticket in a report the way you are doing it. You have the right idea that you can append the ticket ID to the URL to get a view of a single ticket.

Some report 'links' are special cased, like device names. This is done internally with code designed for that specific purpose. SQLite does not interpolate column results into strings.

That said, you can always write a plug-in to linkify the ticket IDs AFTER the report was rendered on the page. This can be accomplished by jumping into the table and replacing the cell contents with the link itself.

Its going to be very difficult to link-ify a ticket in a report the way you are doing it. You have the right idea that you can append the ticket ID to the URL to get a view of a single ticket.

Some report 'links' are special cased, like device names. This is done internally with code designed for that specific purpose. SQLite does not interpolate column results into strings.

That said, you can always write a plug-in to linkify the ticket IDs AFTER the report was rendered on the page. This can be accomplished by jumping into the table and replacing the cell contents with the link itself.

If you ran a regular Ticket Report, the ticket name is linkified to the link. Because you are writing an SQL report, this doesn't apply. You actually weren't far off. It looks like your HTML was a little malformed. Here is an example that works for me when running a portion of your SQL and turning the ticket ID into a link to the ticket on the helpdesk:

Scott, Rob you guys freaking rule! thanks for the help, and thanks for pointing out what I was doing wrong- I may feel stupid as a brick for not seeing it sooner, but at least it's because you showed me the right way to do it, and didn't berate me for missing it!

Scott, Rob you guys freaking rule! thanks for the help, and thanks for pointing out what I was doing wrong- I may feel stupid as a brick for not seeing it sooner, but at least it's because you showed me the right way to do it, and didn't berate me for missing it!

Anyway, off to publish- thanks again!

Ha, I did nothing...got too busy here to check back in with you (in any real capacity). Glad you got it worked out!

Scott rules ;)

0

This discussion has been inactive for over a year.

You may get a better answer to your question by starting a new discussion.