How to use sub -select?

[lnunes]

I believe that I need to use sub-select on my report.

I am creating a report that counts the number of released parts per ECN.
The report needs to list attributes related to subtypes of Parts in my organization.
It causes multiple lines since for each subtype there will be a new column for the attribute...

I understand that If I use sub-select, I can run the query and concatenate the result in a way to have the attribute in a single column.

[rhart · Accepted solution]

In this case I think you should use the database function concat, or another way could be to create multiple queries and union them

[Marco_Tosin]

In this article you can read how to use concatenate function

How to use Concatenate function in Criteria section of Report in Windchill PDMLink

Here something about sub-types

How to add a sub-type drop-down list of a parent type on report builder

How to get attributes in "QML(Query Builder) Report" which are defined on two different "subtypes" but referring to the same "Global Reusable Attribute"

Here something about sub-select

How to select the latest revision of a Part in a Query Builder report in Windchill PDMLink

Query Builder Report to query latest version of all WTParts in Windchill PDMLink

[anursingh]

Hi @lnunes,

I wanted to follow up with you on your post to see if your question has been answered. 
If so, please mark the appropriate reply as the Accepted Solution. 
Of course, if you have more to share on your issue, please let the Community know so that we can continue to help you. 

Thanks,
Anurag
 

[joe_morton]

I think you can use the Database function "concatenate" in this case.

The Part will only have 1 subtype, so if you concatenate the value of all the subtypes together, you'll get something like "null, null, Value, null". The end result will be just the value you care about.

Here's an example where I do something similar: