Skip to main content
F
FelipeOliveira1-Visitor
1-Visitor
December 8, 2014
Solved

"Modified by" condition in Query Builder

  • December 8, 2014
  • 2 replies
  • 1722 views

Dear,

Can I make a condition in the query builder to bring me only documents modified by a particular person?

Modified_By.jpg

There is no Colunm "Modifiedy By".

Thank You.

Felipe.

Best answer by JarrettOberg

Hi Felipe,

Here is an article that shows an example on wtpart doing a similar function.

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS176778

Notice it is important to select from wtdoc, the wtdocmaster, and wtuser.

join doc with masterReference to docmaster

join doc with modifier to user

Then you will be able to add the condition desired.

Thank you,

Jarrett

2 replies

J
JarrettOberg1-VisitorAnswer
1-Visitor
December 8, 2014

Hi Felipe,

Here is an article that shows an example on wtpart doing a similar function.

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS176778

Notice it is important to select from wtdoc, the wtdocmaster, and wtuser.

join doc with masterReference to docmaster

join doc with modifier to user

Then you will be able to add the condition desired.

Thank you,

Jarrett

    F
    FelipeOliveira1-VisitorAuthor
    1-Visitor
    December 11, 2014

    Thank you Jarrett.

    MarcoTosin
    MarcoTosin21-Topaz I
    21-Topaz I
    December 11, 2014

    Felipe,

    here in the community I wrote a document about reporting, which collects information from many sources (the article posted by Jarrett is already in this document).

    http://communities.ptc.com/docs/DOC-6348

    You can also join this group: http://communities.ptc.com/groups/reporting

    And maybe vote up this two ideas:

    http://communities.ptc.com/ideas/4634

    http://communities.ptc.com/ideas/4659

    Marco
      Terms & ConditionsAccessibility statement