Show described by and referenced by document of part in a single report

[AS_10404072]

Show described by and referenced by document of a part in a single report.

Getting duplicate values.

Or is it possible to show described by or referenced document in single column.

[Catalina]

Hi @AS_10404072,

Thank you for your question! 

I’d like to recommend to bring more details and context to your initial inquiry. 

It also helps to have screenshot(s) to better understand what you are trying to do in your process. 

Please refer to this guideline to make your questions more likely to receive a quick and useful answer. 

This will increase your chances to receive meaningful help from other Community members. 

Furthermore, please consult this Community Search guideline as well, which boosts up your chances of finding a resolution to your topic(s) much faster, as well as articles on our Knowledge Base.

Thank you for your participation and please let me know if you need further assistance! 

Best regards,

[Marco_Tosin]

You are trying to do something that is not possible, see support's response to a request same as yours.

Is it possible to have single Query Builder report to fetch Described By Documents and Reference Documents of the WTPart in Windchill PDMLink?

[Hari_Vara]

Hi,

What is the query you are using?

In Reporting, this should be possible by writing the query accordingly to check if its either of the two and then display it in the report column along with the link type (Desc. by or . Reference Doc).

Cheers

Hari

[AS_10404072]

Hi Hari,

Thanks for the reply.

My QML is as below

How can I add the criteria or different joins? So that I can get the reference and describe docs in single column.

If you want some more details, Please let me know.

Thanks,

Akshay