Skip to main content
1-Visitor
Jan 6, 2017 6:27 AM UTC
Question

Need inputs to create a report

Hi, is it possible to run a report to signify if there is a primary document attached to a container?

Also can we see who the author/owner of a document is?

3 replies

22-Sapphire I
Jan 6, 2017 4:07 PM UTC

When you say "a container" do you mean a WTDocument?

If so, it's a matter of reporting on the "content" of the WTDocument - which can be shown as either Primary or Attachment (just like on the Content tab of the Document).  Also directly available to report Last Modified and Modified By for the last version.

Translate
jfrancis1-VisitorAuthor
1-Visitor
Jan 10, 2017 12:16 AM UTC

Yes i need to get all documents with a primary content.

I am having trouble figuring out how to create the query in 'report management utility' to achieve this.

Could you help me achieve this?

Translate
MarcoTosin
21-Topaz II
Jan 10, 2017 7:30 AM UTC

If you are not familiar with query builder, I suggest you to join this group Reporting and to read carefully this document Resource for reporting, particularly this two attached presentations.

https://www.ptcusercommunity.com/servlet/JiveServlet/download/6348-83-73173/_Reporting6.2.pptx

https://www.ptcusercommunity.com/servlet/JiveServlet/download/6348-83-80037/091130_Reporting_QueryBuilder.ppt

To achieve your result you could start from this report https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS167918 but you have to change your sub select.

Translate
Marco