It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×12,002
×7,461
×1,290

question asked: Jul 16 '21, 10:14 a.m.
question was seen: 1,091 times
last updated: Sep 03 '21, 12:47 a.m.

Related questions

How to concatenate columns in an LQE-based report?

0
Kot T. (1.5k●1●13●19) | asked Jul 16 '21, 10:14 a.m.
JAZZ DEVELOPER

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

2 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Kot T. (1.5k●1●13●19) | 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

0
permanent link
Kot T. (1.5k●1●13●19) | 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.