Skip to main content
J
jfrancis1-Visitor
1-Visitor
January 6, 2017
Question

Need inputs to create a report

  • January 6, 2017
  • 1 reply
  • 1612 views

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?

1 reply

M
MikeLockwood22-Sapphire I
22-Sapphire I
January 6, 2017

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.

J
jfrancis1-VisitorAuthor
1-Visitor
January 10, 2017

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?

MarcoTosin
MarcoTosin21-Topaz I
21-Topaz I
January 10, 2017

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.

Marco
Terms & ConditionsAccessibility statement