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

We are happy to announce the new Windchill Customization board! Learn more.

"Modified by" condition in Query Builder

FelipeOliveira
1-Newbie

"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

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

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

Thank you Jarrett.

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
Top Tags