Querying the System

[GregOlson]

I have an excel list that came out of our ERP system (name and rev).  I need to check rev level against Windchill.  How do I get Windchill to take this list and fetch current latest rev level?

[BrianToussaint]

I would take your Excel list of numbers and make it a one line list that has a ";" in between each number and copy it to the Search area of Windchill. You must have Index searching turned off though. I think that there is a limit to the number of characters in one search though.  You can have "*" in the search criteria as well.  It is the Keyword search.

It would look like this:

12345;12367;12378;12456;12678 etc,etc.

Then you could export the list to Excel from Windchill and do some comparisons within Excel.

[GregOlson]

Thanks for the info Brian...since asking this question I went and talked with our SQL DB guy.  Very simple search on his end got me the info needed.

Greg