Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

0 votes



One answer

Permanent link

You have to keep the title and URL as adjacent columns.

0 votes

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.

It looks like you could use SPARQL expressions to construct an HTML hyperlink of the form <a href='uri'>text</a> . It looks like RB renders that as an HTML hyperlink in the report results. Watch out for HTML escaping the text part.

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,019
× 7,495
× 1,325
× 481
× 360
× 25

Question asked: May 25 '22, 10:56 a.m.

Question was seen: 1,370 times

Last updated: May 25 '22, 11:50 a.m.

Confirmation Cancel Confirm