Skip to main content
B
BrianSullivan10-Marble
10-Marble
September 30, 2010
Question

Lifecycle Template Iteration

  • September 30, 2010
  • 3 replies
  • 867 views
Hello.

Does anyone know of how to tell (or wrote a script, report) what iteration of a Lifecycle Template a specific object (cad. Doc, etc) has in PDMLink?


1. Updated Lifecycle Template to include a few New Transitions

2. Updating Objects (File/New/Reassign Life Cycles)

This functionality does not update objects that are currently Checked-Out. With 100,000 files it is not convenient to stop and write down the non-updated objects either.

Is it traceable via Report Manager? Visible on a Search or Details Page?

How have others tracked what iteration their objects are on.

Brian Sullivan



3 replies

P
pyalavarthi1-Visitor
1-Visitor
September 30, 2010
I use the following sql script to find the lifecycle iteration of a given
part number. You can use it as starting point to write a generic script.

*select M.name,L.iterationida2iterationinfo
from lifecycletemplate L, lifecycletemplatemaster M
where M.ida2a2=L.ida3masterreference and
L.ida2a2 in (*
* select P.ida3a2state
from wtPart P, wtPartMaster M
where M.ida2a2=P.ida3masterreference and
P.latestiterationinfo=1 and
M.wtpartnumber in ('07002334')*
*)*


Regards,
Prathap <">http://goo.gl/LuT5>



On Thu, Sep 30, 2010 at 2:26 PM, Brian Sullivan
<->wrote:

> Hello.
>
>
>
> Does anyone know of how to tell (or wrote a script, report) what iteration
> of a Lifecycle Template a specific object (cad. Doc, etc) has in PDMLink?
>
>
>
> 1. Updated Lifecycle Template to include a few New Transitions
>
> 2. Updating Objects (File/New/Reassign Life Cycles)
>
>
>
> This functionality does not update objects that are currently Checked-Out.
> With 100,000 files it is not convenient to stop and write down the
> non-updated objects either.
>
>
>
> Is it traceable via Report Manager? Visible on a Search or Details Page?
>
>
>
> How have others tracked what iteration their objects are on.
>
>
>
> Brian Sullivan
>
>
>
>
>
>
>
M
MikeLockwood22-Sapphire I
22-Sapphire I
September 30, 2010
I forget exactly where but in several places you can choose to show the LC iteration, via customized Views in tables.

Have not yet found a way to report via query builder but must be do-able.
D
ddemay1-Visitor
1-Visitor
September 30, 2010
Doable as a customization, but there is nothing that track the actual
iteration number on lifecycles, types, or workflow templates as they
implementing the iterated java interface, but not versioned. This means no
iteration column in the database to easily query. To do what you want, you
have to get the object identifier of the assigned template iteration and
figure out where it is in the list of total iterations. Iterations are
handled by the branching identifier and common mastered object identifier.



It's not a difficult customization, just no direct way to extract as a clean
report.



Dave


Terms & ConditionsAccessibility statement