It's all about the answers!

Ask a question

How do I get "Resource Full Name Missing" to show up as blank or "Unassigned" in Report Builder?


0
1
Will Cummings (376) | asked Mar 22 '18, 11:44 a.m.
edited Mar 22 '18, 1:04 p.m.

I have a  report the shows Stories and Tasks, with an Owner (Owned By) column.  In the CCM Plan views, unassigned work items will display "Unassigned".  In the Report Builder, these report as "Resource Full Name Missing".  This not only takes up much space, but in a large report with many as-yet unassigned items, it buries those that are assigned.


Is there a way to make Report Builder show "Unassigned" or better yet, just blanks (empty string) for those?  If so, specifically how?  I can use the Advanced edit feature if need be, but not well versed on syntax and available functionality there.


Example:
What I Want    (blank, "--", or even "Unassigned" is acceptable)
Task ID    Planned For    Status    Owner             
17216      Backlog        New       --
17217      Backlog        New       --
17218      Backlog        New       --
17265      Sprint 2       Done      John Doe
17278      Backlog        New       --
17279      Backlog        New       --
17301      Backlog        New       --

What I Get:
Task ID    Planned For    Status    Owner             
17216      Backlog        New       Resource Full
                                    Name Missing 17217      Backlog        New       Resource Full
                                    Name Missing 17218      Backlog        New       Resource Full
                                    Name Missing 17265      Sprint 2      Done     John Doe 17278      Backlog       New       Resource Full
                                    Name Missing 17279 Backlog        New       Resource Full
                                    Name Missing 17301     Backlog        New       Resource Full
                                    Name Missing
Thanks.

Rational 6.0.1 RM, QM, CCM, and Report Builder (RS??)


Comments
Cathy Xu commented Mar 25 '18, 8:37 p.m.

Hi Will,

What is the value of "Owner By" attribute is set for those Tasks, such as 17216, 17217, 17216, etc. from CCM Web UI?



Cathy Xu commented Mar 26 '18, 1:20 a.m. | edited Mar 26 '18, 1:22 a.m.

Will Cummings commented Mar 26 '18, 10:18 a.m. | edited Mar 26 '18, 10:21 a.m.

Hello Cathy -

As mentioned above, the value of the "Owned By" field in the CCM UI is "Unassigned".

This is not a case of missing data, but rather a case of absent data being represented differently between CCM & the Report Builder.  One says "Unassigned", the other says "Resource Full Name Missing".  The former is correct, the latter is slightly misleading and definitely more verbose. 

I would like to have the report builder query result in something less verbose, ideally a blank or a couple dashes, but even "Unassigned" would suffice.


Kenery Wang commented Aug 23 '18, 5:36 a.m. | edited Aug 23 '18, 5:36 a.m.

Same issue here, except the version of Rational CLM I'm using is v6.0.2 iFix016.


All the work items without owner assignment show 'Resource Full Name Missing' in owner field when I use Report Builder to build report, which leads to a severe problem that if I want to sort out work item without owner assignment by setting a condition 'Owner is not set value', it won't work.


Will Cummings commented Aug 23 '18, 10:32 a.m.

Sort, or filter?  What happens if you look for the condition "Resource Full Name Missing"?  Sorry, I've not used the graph view yet, so don't know its particular quirks. 

showing 5 of 6 show 1 more comments

One answer



permanent link
Will Cummings (376) | answered Apr 05 '18, 11:15 a.m.
edited Apr 05 '18, 4:53 p.m.

 Turns out that all I needed to do was edit the generated query ("Advanced" option) as follows:


Before:
SELECT ....
       T4.FULL_NAME,
       ....
After:
SELECT ....
       CASE When T4.FULL_NAME = 'Resource Full Name Missing'
              Then '--'
              Else T4.FULL_NAME
            END as FULL_NAME,
       ....


Comments
Kenery Wang commented Aug 23 '18, 5:39 a.m.

If you customize the query statements, you lose the opportunity to drill down to work item list from a graph view. Not an acceptable solution for me in this case, hoping IBM can solve it asap.

Your answer


Register or to post your answer.