Skip to main content
E
ErikZabokrtsky12-Amethyst
12-Amethyst
March 5, 2014
Solved

Name and Number

  • March 5, 2014
  • 2 replies
  • 10230 views

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!

    Best answer by jkent

    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;

    2 replies

    J
    jkent1-VisitorAnswer
    1-Visitor
    March 5, 2014

    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;

      E
      ErikZabokrtsky12-AmethystAuthor
      12-Amethyst
      March 5, 2014

      Thanks Joe,

      I'll check out how this query works.

      M
      22-Sapphire I
      MikeLockwood22-Sapphire I
      22-Sapphire I
      March 5, 2014

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

      Why not use some descriptive text for Name?

        H
        HugoHermans12-Amethyst
        12-Amethyst
        March 5, 2014

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

          E
          ErikZabokrtsky12-AmethystAuthor
          12-Amethyst
          March 5, 2014

          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.

            Terms & ConditionsAccessibility statement