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

"Modified by" condition in Query Builder

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.

JarrettObergAnswer
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

View in thread

3 replies

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

Translate
    FelipeOliveira1-VisitorAuthor
    1-Visitor
    December 11, 2014

    Thank you Jarrett.

    Translate
    MarcoTosin
    MarcoTosin21-Topaz II
    21-Topaz II
    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

    Translate
    Marco
      Terms & ConditionsAccessibility statement