Skip to main content
5-Regular Member
October 15, 2024
Question

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

  • October 15, 2024
  • 3 replies
  • 812 views

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.

3 replies

Catalina
Community Moderator
October 15, 2024

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,

Catalina | PTC Community Moderator
Marco Tosin
21-Topaz I
21-Topaz I
October 15, 2024

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?

 

 

Marco
16-Pearl
October 15, 2024

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

5-Regular Member
October 15, 2024

Hi Hari,

 

Thanks for the reply.

My QML is as below

AS_10404072_0-1728980828549.png

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