Skip to main content
D
dfrancisco1-Visitor
1-Visitor
February 16, 2016
Solved

How to get a report of the URL address of WTparts?

  • February 16, 2016
  • 1 reply
  • 6817 views

Hello community!!!

I am trying to get a report that list de URL address of WTParts. I have tried some joins between Part e URL link in query build report without success.

Does anybody knows how to do it?

Thanks a lot in advance...

Best answer by mdebower

Binesh,

I ran across the solution.   For MS SQL you basically have to convert the branch identifer to text.

20160226-111828.png

1 reply

B
BineshKumar11-Visitor
1-Visitor
February 16, 2016

If you want just the Windchill Information link you can just add the top level object type to the select list. If you are looking to get the actual URL use concat function and generate URL using branch identifier.

parturl.png

Thank you

Binesh Kumar

Medtronic - MITG

    D
    dfrancisco1-VisitorAuthor
    1-Visitor
    February 17, 2016

    Hello Binesh

    I exchanged the server name and tried to execute, but unfortunatly it did not work. Take a look at the message:

    Capturar1.JPG

    Thank you in any case.

    B
    BineshKumar11-Visitor
    1-Visitor
    February 17, 2016

    Hello Daniel,

    Could you try recreating a new query from query builder? The only table in From is Part and the the select should be as I have in my screenshot

    Thank you

    Binesh Kumar

    Medtronic - MITG

    Terms & ConditionsAccessibility statement