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.

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

 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.


Your answer

Register or to post your answer.