How to get a report of the URL address of WTparts?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How to get a report of the URL address of WTparts?
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...
Solved! Go to Solution.
- Labels:
-
Other
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Binesh,
I ran across the solution. For MS SQL you basically have to convert the branch identifer to text.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Thank you
Binesh Kumar
Medtronic - MITG
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Binesh
I exchanged the server name and tried to execute, but unfortunatly it did not work. Take a look at the message:
Thank you in any case.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am trying to do the same thing, only for WTDocuments. When I add the Branch Identifier into the Concatenate function, the report ceases to function.
Any ideas on what I am doing wrong?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Mark,
Are you getting any error? Your QML works fine on my dev system by removing the criteria. I know SQL server has some issues with functions in report manager.
Thank you
Binesh Kumar
Medtronic - MITG
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No error. The report just doesn't return any results.
We are running MS SQL so maybe that is the issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Binesh,
I ran across the solution. For MS SQL you basically have to convert the branch identifer to text.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Daniel,
Can you check if the solution from Marc works for you.
Regards,
Bhushan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Bhushan
It is works now. At least for WTParts.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Marc
I followed your instructions using the train of thought for WTParts and it works!
Thank you.
Thank you everybody to contribuite to my question.
I confess. I am not a IT professional and your help is very appreciated.
Best Regards.
