It's all about the answers!

Ask a question

How to concatenate columns in an LQE-based report?


Kot T. (1.5k11219) | asked Jul 16 '21, 10:14 a.m.
JAZZ DEVELOPER

 How can I concatenate columns in an LQE-based report in JRS?

2 answers



permanent link
Kot T. (1.5k11219) | answered Jul 16 '21, 10:22 a.m.
JAZZ DEVELOPER
edited Jul 16 '21, 10:28 a.m.
LQE-based reports use SPARQL so you will have to consult documentations on how to write SPARQL queries.

To combine 2 string columns in a report, you can add a CUSTOM EXPRESSION column and enter an expression in it. For example, in a simple report where you list all defect workitems in a particular project, you can concatenate the ID and Tile column into one column by using the following custom expression:
concat(str($Defect:Id$), ": ", str($Defect:Title$))

Note that Defect in the expression is the workitem type selected in the report (it appears in the 'Attribute Of' dropdown). The name maybe different.


Another example of the expression to concatenate multiple columns:
concat(if(bound($Defect:Title$), concat(str($Defect:Id$), ": ", str($Defect:Title$)), ""), "  ", if(bound($Story:Title$), concat(str($Story:Id$), ": ", str($Story:Title$)), ""))

sample output


permanent link
Kot T. (1.5k11219) | answered Sep 02 '21, 9:56 a.m.
JAZZ DEVELOPER

 For both DW and LQE based reports, the columns can be combined simply by adding the columns and giving them the same label. The following message will appear when you add such columns.


message

Your answer


Register or 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.