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

JRS - Creating Hyperlinks with the Advanced Query tab (SQL / SPARQL)

Questions
Tags
Users
Badges
David Reilly
(69●7●42) retagged
Jan 11 '19, 7:10 a.m.

Hello hello,


I'm currently using JRS v6.0.2 iFix015 and have been taking to the advanced query section with SPARQL and have returned the results I've been looking for. 

However, one thing I noticed in our LQE-configuration aware reports resulted in a URL that did not contain the selected configuration uri. Instead, the result looked like this: "https://localhost.com/rm/resources/resourceUri?oslc_config.context?"

To the point:
  • Can we pass variables to and from the report builder and the sparql / sql queries? 
  • Is there any way for us to join that configuration context uri to our url? 
  • Is it possible to apply the hyperlink to another attribute? (i.e. Title, ID)
Sincere thanks!
David

0 votes

Comments
David Reilly
Jul 23 '18, 4:06 p.m.

Did some searching and found the following post which was helpful on using variables in the report builder:


Anyone know how I make use of this for the configuration context uri?

1 answer
3,211 views
0 votes

One answer

Permanent link
David Reilly
(69●7●42) edited
Jul 24 '18, 12:40 p.m.

Okay, I guess I have to answer my own question again. 


After generating a decent report, you should see your results with funky column names. You can change them in the SPARQL query or update the column label in the "Format" options. 

In order to get your hyperlinks to display and be usable in your report, change the "Variable Type" for whichever string returns the URL to be URI. Then your report should apply those hyperlinks to the neighboring column, making everyone happy campers. 

    

Column label

Variable

Variable Type

Dng_merged_Requirement1

Dng_merged_Requirement1

Uniform Resource Identifier

1 vote

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.

Ask a question
Guidelines
FAQ
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,014
× 1,381

Question asked: Jul 23 '18, 10:12 a.m.

Question was seen: 3,211 times

Last updated: Jan 11 '19, 7:10 a.m.

Confirmation Cancel Confirm