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

Report Studio: How to change empty values in query?

Hello,

I use outer join query in Report Studio. It returns all test cases and verdicts.
For test cases that didn't run it returns empty values, so I have

Test Case-----Verdict-----

TC1 Passed
TC2 Failed
TC3
TC4 Passed

How I could change empty value to 'Not Run'?

-thanks in advance

0 votes



3 answers

Permanent link
Hi, you could add some calculations in the data item for your verdict. I've done things like this for other fields, and used something similar to this:

IF ( = '')
THEN ( 'Not Run' )
ELSE ( )

0 votes


Permanent link
. IS NULL)
THEN ( 'Not Run' )
ELSE ( . )

0 votes


Permanent link
Look at some of our sample report reports that ship with RQM to see how
this is done. You can add an expression to the query item such as

If ..=NULL THEN "Not Run" ELSE ..

Hope this helps,
Peter.



On 4/19/2012 8:17 PM, timur.markunin wrote:
Hello,

I use outer join query in Report Studio. It returns all test cases and
verdicts.
For test cases that didn't run it returns empty values, so I have

Test Case-----Verdict-----

TC1 Passed
TC2 Failed
TC3
TC4 Passed

How I could change empty value to 'Not Run'?

-thanks in advance

0 votes

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.

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

Question asked: Apr 10 '12, 7:57 a.m.

Question was seen: 10,743 times

Last updated: Apr 10 '12, 7:57 a.m.

Confirmation Cancel Confirm