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

JRS Custom Expression documentation

Questions
Tags
Users
Badges
Lita Gribben
(11●2) Dec 30 '20, 3:29 p.m.

 I'm trying to create better reports on JRS and I am having no luck finding documentation on what can be done with Custom Expressions. The few resources only go into a couple of options, and I've been able to find more random options on this forum or other pages (for example GROUP_CONCAT), so I imagine there's different expressions that can be used. Is there anywhere where all these are documented?

0 votes

2 answers
4,829 views
0 votes

2 answers

Permanent link
Bartosz Chrabski
(3.6k●2●29●50) Dec 30 '20, 3:33 p.m.

 Hi Lita,


You should start with SparQL documentation: https://www.w3.org/TR/sparql11-query/.

0 votes

Permanent link
Daniel Moul
FORUM MODERATOR / JAZZ DEVELOPER (5.0k●13●18) Dec 31 '20, 10:38 a.m.

Actually I think Lita is asking about the option newly added in V7 to create a custom expression in a column of data on the "Format Results" tab of the guided UI (rather than using an advanced query).  The available functions differ by database (Data warehouse with Db2, Oracle or SQL Server) or LQE.


I'm not aware of good documentation or examples (yet).

0 votes

Comments
Bartosz Chrabski
Dec 31 '20, 10:56 a.m.
Daniel, GROUP_CONCAT is function which you can use directly in "Format Results" without even touching Advanced Queries. I think what everyone are missing is list of LQE functions that are supported by ELM 7.0.X.

Lita Gribben
Jan 14 '21, 2:22 p.m.
You're correct Daniel. The custom expression provides some options you can click on, but looking through the forum I happened to find GROUP_CONCAT which has been useful but it's not an obvious option on JRS and I was hoping there was some documentation from IBM that I missed about this and other functions. 

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,144

Question asked: Dec 30 '20, 3:29 p.m.

Question was seen: 4,829 times

Last updated: Jan 14 '21, 2:22 p.m.

Confirmation Cancel Confirm