Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X
Hello,
I have a query that returns only the ID of a related item, but I need also the Summary .
The related field is of "relationship" type.
I searched PTC knowledge base and find no solution:-(
Any hints on this?
Thank you
Cristina
Solved! Go to Solution.
Related Items are allways and only identified by their ID.
You have now 2 Options:
1. Change the view Options of your Client's items view to allow "Wrapping" table content. This allows you to see Details isn the same view (not available in oder Integrity Versions). If you still only see the related items ID, there might be a "problem" in your Integrity setup, as relationships can be either shown as Table-View or CSV (which would be ID only). Only your MKS Admin can change that.
2. use a report.
Report allow you to collect and display far more information that the (1 dimensional) query. There should be prepares report recipies available in your installation that make it easy to create and configure just the report you want.
HTH
Matthias
Hi Cristina,
please specify your use case:
Do want to run a query
- in the GUI
- via CLI
- inside Report
- using the JAVA or C API
A bit more context would be very helpful.
Hello Matthias,
I have a query in GUI, searching for all CRs and I want to see with which planned release they are associated.
So, each line looks like: CR_ID, CR_Type,CR_Summary, Planned_SW_Release
But the Planned_SW_Release only shows me the ID of that SW Release, not the Summary. The ID is just a number :-).
Is there a way to put there the Summary?
I also need to mention that the Planned SW Release field is of relationship type.
Thanks,
Cristina
Related Items are allways and only identified by their ID.
You have now 2 Options:
1. Change the view Options of your Client's items view to allow "Wrapping" table content. This allows you to see Details isn the same view (not available in oder Integrity Versions). If you still only see the related items ID, there might be a "problem" in your Integrity setup, as relationships can be either shown as Table-View or CSV (which would be ID only). Only your MKS Admin can change that.
2. use a report.
Report allow you to collect and display far more information that the (1 dimensional) query. There should be prepares report recipies available in your installation that make it easy to create and configure just the report you want.
HTH
Matthias
Hello Matthias,
The "Wrapping" solution is what I need. I do not know why I did not think of it .
Thank you very much for your help 🙂
Cristina