-
-
Re: get %nextrevision% through the api
I do not want to increment the revision, but rather get what the value would be if it were incremented.
-
Re: get %nextrevision% through the api
Sorry, I miss understood. I think you will have to figure out the next revision value like you said, brute force method.
-
-
-
Re: get %nextrevision% through the api
Look up AllocSerNoValue in the API reference guide, there is example code at the bottom of the page that does what your after.
-
Re: get %nextrevision% through the api
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.
-
Re: get %nextrevision% through the api
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'
-
Re: get %nextrevision% through the api
This might be easier running stored proceedure dbo.RG_GetNextUserRevValue
exec dbo.RG_GetNextUserRevValue 74, 10
where 74 is @documentID and 10 is @transitionID
-
-
Re: get %nextrevision% through the api
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.
-
Re: get %nextrevision% through the api
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.
-
-
-