Skip to main content
G
GregOlson16-Pearl
16-Pearl
May 21, 2018
Question

Querying the System

  • May 21, 2018
  • 1 reply
  • 1530 views

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?

1 reply

B
BrianToussaint19-Tanzanite
19-Tanzanite
May 21, 2018

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.

G
GregOlson16-PearlAuthor
16-Pearl
May 21, 2018

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

Terms & ConditionsAccessibility statement