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

Querying the System

Highlighted
Level 11

Querying the System

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?

2 REPLIES

Re: Querying the System

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.

Re: Querying the System

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