Skip to main content
G
gmehta1-Visitor
1-Visitor
January 7, 2016
Solved

Is there a way to Search Check in comments for CAD or Documents

  • January 7, 2016
  • 3 replies
  • 4761 views

Even in Advanced search I cannot find the check-in Comments field.

If we modified a objects for CAR-XXX then in the future we can search the check-in comments for all objects in the specific product / project or library for CAR-XXX. We would instantly in the future what objects were modified for CAR-XXX.

I was also thinking may be some type of report may be able to provide this info?

Thank You

Best answer by gmehta

Hello Bob,

Based on your advice and PTC this was the final QML and it work well

thx

3 replies

E
ehowanice12-Amethyst
12-Amethyst
January 7, 2016

In 9.1 I had this issue and resorted to a sqlplus query like this:

select
epmdocumentmaster.documentnumber,
epmdocumentmaster.name,
epmdocument.noteiterationinfo,
epmdocument.createstampa2,
epmdocument.updatestampa2

from
EPMDOCUMENT,EPMDOCUMENTMASTER
where
epmdocument.ida3masterreference=epmdocumentmaster.ida2a2
and
epmdocument.noteiterationinfo like '%CHECKIN COMMENT GOES HERE%'

B
bsindelar1-Visitor
1-Visitor
January 7, 2016

You could use QueryBuilder to make a 2-column report:

  • Column 1 is the EPMDocument (with a link to the object)
  • Column 2 is the Iteration Note (check in comment)

You can then run the report and provide a criteria on the check-in comment, thus giving you the same capability as search.

Let me know if you'd like assistance building this report or with any other Windchill questions you may have.

G
gmehta1-VisitorAuthor
1-Visitor
January 7, 2016

Hello Bob,

I think we have decided to use a similar approach using a QML report. Its for office documents (as that's what we needed it for).

I have attached

 

Main issue now is we want to be able to search all iterations as the specific comment we are looking for may be in a previous iteration comment for the object (the QML I got from PTC only looks for latest object comment)

 

Second is we need a way to also have the object number displayed as the QML shows name etc but not the number. It’s the unique object number generated by WC

 

B
bsindelar1-Visitor
1-Visitor
January 8, 2016

Assuming you are importing this QML into querybuilder, you can accomplish what you are looking for by:

  1. Remove the "latestIterationInfo=1" criteria to get all iterations (you may want to include revision and iteration as columns of the report to make it easier to interpret).
  2. Add the unique identifier as an attribute for the report (I assume you are referring to what the DB calls the ida2a2 value.  In QueryBuilder for EPMDocument, for example, you want the "EPMDocument.Persist Info.Object Identifier.Id" attribute).  I finstead you are referring to the "EPMDocument Number" field, just take the "EPM Document.Number" attribute in QueryBuilder off the EPMDocument table.

Hope this helps!

G
gmehta1-VisitorAuthorAnswer
1-Visitor
January 14, 2016

Hello Bob,

Based on your advice and PTC this was the final QML and it work well

thx

Terms & ConditionsAccessibility statement