cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

"Modified by" condition in Query Builder

SOLVED
Highlighted

"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.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: "Modified by" condition in Query Builder

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 solution in original post

3 REPLIES 3

Re: "Modified by" condition in Query Builder

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 solution in original post

Re: "Modified by" condition in Query Builder

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

Re: "Modified by" condition in Query Builder

Thank you Jarrett.