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

Name and Number

SOLVED
Highlighted
Participant

Name and Number

Is there a way to get like a full system report if there are any differences between the Name and Number of an item?

We are using Windchill 10.0 M030 and most of our items are matched up, but a few of them have contradicting Names and Numbers. I would like to know if there is a way to get a list of all the items with discrepancies?

Attached it what I am looking at trying to match up.

Thanks for any help!

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Name and Number

I think this SQL Query will return what you want.

SELECT

DISTINCT EPMDocumentMaster.CADName "FileName"

,EPMDocumentMaster.name "Name"

,EPMDocumentMaster.documentNumber "Number"

,WTUser.name "Created By"

FROM

EPMDocumentMaster

,EPMDocument

,WTUser

WHERE

EPMDocument.idA3D2iterationInfo = WTUser.idA2A2

AND EPMDocument.idA3masterReference = EPMDocumentMaster.idA2A2

AND (

(

(

LOWER(EPMDocumentMaster.CADName) != LOWER(EPMDocumentMaster.name)

)

OR (

(

LOWER(EPMDocumentMaster.CADName) != LOWER(EPMDocumentMaster.documentNumber)

)

)

)

)

AND EPMDocument.statecheckoutInfo = 'c/i'

ORDER BY

EPMDocumentMaster.CADName ASC;

17 REPLIES 17

Re: Name and Number

I think this SQL Query will return what you want.

SELECT

DISTINCT EPMDocumentMaster.CADName "FileName"

,EPMDocumentMaster.name "Name"

,EPMDocumentMaster.documentNumber "Number"

,WTUser.name "Created By"

FROM

EPMDocumentMaster

,EPMDocument

,WTUser

WHERE

EPMDocument.idA3D2iterationInfo = WTUser.idA2A2

AND EPMDocument.idA3masterReference = EPMDocumentMaster.idA2A2

AND (

(

(

LOWER(EPMDocumentMaster.CADName) != LOWER(EPMDocumentMaster.name)

)

OR (

(

LOWER(EPMDocumentMaster.CADName) != LOWER(EPMDocumentMaster.documentNumber)

)

)

)

)

AND EPMDocument.statecheckoutInfo = 'c/i'

ORDER BY

EPMDocumentMaster.CADName ASC;

Re: Name and Number

I'm continually amazed that people want to make the Number and Name the same.

Why not use some descriptive text for Name?

Re: Name and Number

You know, Mike, people tend to be lazy. Entering twice the same is so much easier, even if it doesn't make sense.

Re: Name and Number

I like how you come into a discussion and just immediately dog on someone's practices instead of trying to enlighten them to a different way of doing something. This is our first Library Manager and we were not aware that you could have the same Name for 2 different parts until Mike's comment.

Mike thank you very much for pointing out that we could do this instead of going back and updating a part number log in an Excel sheet like we always used to.

Re: Name and Number

Thanks Joe,

I'll check out how this query works.

Re: Name and Number

Mike and Hugo...most of the time a system is setup by a VAR or consultant that doesn't have the background to recommend things like this. Their job is to get the company up and running as fast as possible and get on to the next job. We keep Number, Name, and File Name the same for no particular reason other than we were not told a benefit to having them different....NOT lazy, just uninformed at the time. So here is your chance to enlighten us with your experience. Currently we have two text description parameters that are pulled in to WC as attributes. How can changing the name from match to descriptive text help with search when we already have two sentences (attributes) in the system that are searched? The only one I can think of would be that the drawings would now be searchable with a text description (our drawings pull the parameters from the cad parts and assemblies, but do not have descriptions themselves.

Re: Name and Number

Hey Joe, how would I get the ouput from this query to dump to a text file?

Re: Name and Number

After I ran the Query I just right clicked in the results area and clicked on "Save Results As"

There you can choose to save as text file, but it is really jumbled.

I chose Comma Separated Value and it puts it to an Excel file that works very nicely.

Re: Name and Number

In SQL Server Management Studio you can just have it output to a file.

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum! ______________________________ Check out the Windchill Tips Board! We're talking about Whirlpool's use of digital twin, augmented reality, and data-driven design!

The NAVIGATE WORKING GROUP is here! Come innovate with PTC!

Sign up for a Working Group