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

Will Cummings

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??)

0 votes

Comments

Cathy Xu

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

Mar 25 '18, 10:03 p.m.

Cathy Xu

Mar 26 '18, 1:22 a.m.

Maybe try a full load of DCC:

https://jazz.net/forum/questions/223091/jrs-502-shows-owner-attribute-value-as-resource-full-name-missing

Will Cummings

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

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

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

1 answer

2,669 views

0 votes

One answer

Permanent link

Will Cummings

(37●8) 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,
       ....

1 vote

Comments

Kenery Wang

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

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.

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

rational-team-concert

× 42,912

usage

× 12,031

report-builder

× 183

Question asked: Mar 22 '18, 11:44 a.m.

Question was seen: 2,669 times

Last updated: Aug 23 '18, 10:32 a.m.

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

Comments

1 answer

2,669 views

0 votes

One answer

Comments

Your answer

Follow this question

Question details

Related questions