JRS (CLM 6.0.6.1) - Show text as a clickable URL in Reports
Hi,
If I place a requirement "Title" next to a "URL" column in a JRS Report using LQE, the two are merged and I get a clickable link.
However, if I try and move the URL field next to the Id instead, or change the Title to be a custom expression, I end up with a separate column with the messy URL in it.
How do I format the columns in a JRS report, or configure the custom expression/SPARQL so that it uses the URL as a clickable link for the Title or Id without a separate column?
...without manually editing the SPRQL query for the report (i.e. using the UI)?
Thanks,
Glyn
|
One answer
David Honey (1.3k●1●7)
| answered May 25 '22, 11:00 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER You have to keep the title and URL as adjacent columns.
Comments I know that's the case normally, however, if i remove the "Title" column and replace it with the custom expression using SUBSTR(title,1,50) to trim the title length to less than 50 characters, AND have the URL next to this new column, the URL has it's own column.
That's the current design. I do not think that is customisable.
I'm wondering if there is a SPARQL function that will combine my new title with the URL to make a clickable URL. In the custom expression editor there's a URL format.
David Honey
commented May 25 '22, 11:49 a.m.
| edited May 25 '22, 11:50 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
It looks like you could use SPARQL expressions to construct an HTML hyperlink of the form
|