"Modified by" condition in Query Builder

[FelipeOliveira]

Dear,

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

There is no Colunm "Modifiedy By".

Thank You.

Felipe.

[JarrettOberg · Accepted solution]

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

[FelipeOliveira]

Thank you Jarrett.

[Marco_Tosin]

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