topic RE: Cannot return search results of latest version of WTPart in Windchill

Cannot return search results of latest version of WTPart

brian_beard — Wed, 02 May 2018 17:35:56 GMT

Hello,I have created a query within Query Builder that allows me to put a begin date and end date and for the period, the search results will show me WTParts. There is one problem, however. The search results should only return the latest version of a part.Rather than the search results

Cannot return search results of latest version of WTPart

MikeLockwood — Wed, 31 Mar 2010 20:04:08 GMT

Criteria, Latest, value (constant) = 1

RE: Cannot return search results of latest version of WTPart

brian_beard — Wed, 31 Mar 2010 20:08:42 GMT

The only thing I see in the Part (wt.part.WTPart) class is the "Latest Iteration" attribute. I do not see just a "Latest" attribute. Could you describe in more detail whether or not the "Latest" attribute that you are telling me about is available in this class or another class?

Thanks in advance.

RE: Cannot return search results of latest version of WTPart

brian_beard — Thu, 01 Apr 2010 19:34:00 GMT

Also, I should mention that I am currently leveraging the "Latest Iteration" attribute which will return results of the latest iteration of a part as the name implies. The problem with this is that the same part could have multiple rows or instances within the search. For example, part number 0001 may have search results 3 times, one for the most current iteration of each revision. See below.

Number | Version

0001 | A.4

0001 |B.5

0001 |C.3

The only thing that should show up in this case would be part number 0001 version C.3 because it is the most current version.

0001 | A.4

RE: Cannot return search results of latest version of WTPart

brian_beard — Thu, 01 Apr 2010 19:35:50 GMT

Please disregard the extra "0001 |A.4" at the bottom of my last reply. That was a mistake.

RE: Cannot return search results of latest version of WTPart

LiuLiang — Fri, 02 Apr 2010 16:02:58 GMT

Most of our part reports require to list only the part(s) with latest iteration on its latest revision.

I haven't found a better way to find latest revision than listing the part with the maximum value of versionSortID against the same master.

I have attached my sample report on how we query it currently. I would like to see if other users have better way to achieve this goal. Thanks.

In Reply to Brian Beard:

Please disregard the extra "0001 |A.4" at the bottom of my last reply. That was a mistake.

RE: Cannot return search results of latest version of WTPart

VincentQuesnoit — Thu, 08 Apr 2010 08:49:57 GMT

That solutionlooks better than mine.

I was doing a NOT EXISTS other where other.versionSortID>current.versionSortID

I guess I'm going to use the maximum function in the future.

Thanks,

In Reply to Liu Liang:

Most of our part reports require to list only the part(s) with latest iteration on its latest revision.
I haven't found a better way to find latest revision than listing the part with the maximum value of versionSortID against the same master.
I have attached my sample report on how we query it currently. I would like to see if other users have better way to achieve this goal. Thanks.

In Reply to Brian Beard:
Please disregard the extra "0001 |A.4" at the bottom of my last reply. That was a mistake.

RE: Cannot return search results of latest version of WTPart

brian_beard — Thu, 22 Apr 2010 18:46:41 GMT

For the future, here is some information if anyone runs into the situation we have. Since the Design view of parts in classified and not our other views, we needed to show the latest version whereview = "Design". I built upon the query that was posted so I came up with something like this that returns the latest version of the design view of a part.

Criteria:

Part (wt.part.WTPart).versionInfo.identifier.versionSortId

Sub-select

Sub-select:

- From:

Part (wt.part.WTPart)
- Alias: Part (wt.part.WTPart) 1
View
- Alias: View 1

- Join:

Part (wt.part.WTPart) 1 to View 1
Association: View

- Select:

MAX function of Part (wt.part.WTPart) 1.versionInfo.identifier.versionSortId

- Criteria:

AND
View 1.Name = Design
AND
Part (wt.part.WTPart) 1.Master Reference.Object Id.Id = Part (wt.part.WTPart).Master Reference.Object Id.Id