AnsweredAssumed Answered

get %nextrevision% through the api

Question asked by Jeremy Schmidt on Aug 25, 2011
Latest reply on Aug 29, 2011 by Jeremy Schmidt

Like • Show 0 Likes0
Comment • 9

EPDM transitions have a predefined function to get the the next revision (%nextrevision%) based on the revision components of the destination state. Is there a way to duplicate this functionality through the API? I have found ways to get the revision scheme of the destinate state, get the current revision value, but not to get what that next value will be. I could write some complex code to get the next value based on its current revision scheme, current revision value, and destination state, but I'd rather not unless I really have to. I need to get the value pre-state change, so that I can cancel the transition if necessary.

No one else has this question

Outcomes

9 Replies

Wayne Matus Aug 25, 2011 5:28 PM
Mark Correct
Correct Answer
IEdmFile5::IncrementRevision
Like • Show 0 Likes0
Actions
- Jeremy Schmidt @ Wayne Matus on Aug 25, 2011 5:36 PM
  Mark Correct
  Correct Answer
  I do not want to increment the revision, but rather get what the value would be if it were incremented.
  Like • Show 0 Likes0
  Actions
  - Wayne Matus @ Jeremy Schmidt on Aug 25, 2011 5:46 PM
    Mark Correct
    Correct Answer
    Sorry, I miss understood. I think you will have to figure out the next revision value like you said, brute force method.
    Like • Show 0 Likes0
    Actions
Cyrus Elworth Aug 26, 2011 12:18 PM
Mark Correct
Correct Answer
Look up AllocSerNoValue in the API reference guide, there is example code at the bottom of the page that does what your after.
Like • Show 0 Likes0
Actions
- Jeremy Schmidt @ Cyrus Elworth on Aug 26, 2011 12:22 PM
  Mark Correct
  Correct Answer
  That's the right idea, but unless I'm missing something, that command is for a serial number, not a revision number. I need the exact same thing for a revision number.
  Like • Show 0 Likes0
  Actions
  - Kent Keller @ Jeremy Schmidt on Aug 26, 2011 1:47 PM
    Mark Correct
    Correct Answer
    I had to solve this using SQL in API. But our Revision Scheme is list based. Here is my SQL. Perhaps you can gleen some ideas from it.
    
    select d.DocumentID, d.Filename, d.LatestRevisionNo as LatestVersion, rg.Counter,
    case
    when rg.Increment = 0 then
    (Select Data from RevGeneratorList rl where rg.RevGenID = rl.RevGenID and rl.CounterIndex = rg.Counter -1)
    else
    (Select Data from RevGeneratorList rl where rg.RevGenID = rl.RevGenID and rl.CounterIndex = rg.Counter)
    end as NextRevision
    from Documents d inner join revgencounters rg on d.DocumentID = rg.DocumentID
    where d.Filename = '550264-02.SLDDRW'
    Like • Show 0 Likes0
    Actions
    - Wayne Matus @ Kent Keller on Aug 26, 2011 4:00 PM
      Mark Correct
      Correct Answer
      This might be easier running stored proceedure dbo.RG_GetNextUserRevValue
      
      exec dbo.RG_GetNextUserRevValue 74, 10
      
      where 74 is @documentID and 10 is @transitionID
      Like • Show 1 Like1
      Actions
  - Cyrus Elworth @ Jeremy Schmidt on Aug 26, 2011 4:18 PM
    Mark Correct
    Correct Answer
    My fault there, you can do what your after in the API but it can get complicated depending on the revision scheme. Basically on the state change event, use the revision manager interface to collect all of the revision numbers in that files revision scheme. Then grab the current revision of the file and count your way through to the next. Like I said it gets complicated when you have multiple revision components.
    Like • Show 0 Likes0
    Actions
    - Jeremy Schmidt @ Cyrus Elworth on Aug 29, 2011 12:54 PM
      Mark Correct
      Correct Answer
      This is what I had started and was hoping to avoid. Unfortunately, I see no other way, except querying the database as others had suggested. Thanks everyone for your input.
      Like • Show 0 Likes0
      Actions

get %nextrevision% through the api

Outcomes

Related Content

Recommended Content