Rules Engine: Defining version string

Offline Morten Sørensen Fri, Dec 5 2014 2:47 AM

Hey all

Hope someone can help me with this. Because I'm not quite seeing the full picture.

Where do I define the Rules Engine's default version string: XYY.ZZ...???

According to the document "ProjectWise Rules Engine Guide_v2.docx" I can have the Rules Engine control the versioning of documents in PW, by using the action type "CHANGE_REV_NO".

The default version string is: XYY.ZZ
X = prefix letter
YY = Major numerical revision
ZZ = Minor numerical revision

But where do I, for example, define the prefix letter (X)..??

Thanks..!!

Top Replies

0 Offline Arturas Zidonis Fri, Dec 5 2014 9:26 AM
Hi,

I think you cannot change this prefix letter from ProjectWise interface.

However, if you know 'Micorosoft SQL Server Management Studio' good enough you can change this prefix letter in Stored Procedure named 'wreIncrementVersionNumber' under ProjectWise database.
By default there should be two stored procedures (under ProjectWise database > Programmability > Stored Procedures > wreIncrementVersionNumber). Modify this storedprocedure and change the letter 'P' in this row - SET @revisionPrefix = 'P'.

Regards,
Arturas
Cancel
Up 0 Down

Verify Answer

Reject Answer

Cancel
0 Offline Philip Las Gourgues Tue, Jun 16 2015 3:00 AM in reply to Arturas Zidonis

Hi Arturas,

This is very strange that the prefix can't be changed. I was hoping to set the prefix to equal my revision letter/number and the numerical version to be appended to that to create the full vesion number.

So for revision A you'd have versions A.01, A.02, A.03 etc
Then for revision B you'd have versions B.01, B.02 etc
And so on

I was then going to use a state to change from alphabetic to numeric major revision after the document was approved for construction

So first approved for construction revision would be 0 and versions of that would be 0.01, 0.02 etc
Then for first post AFC revision it would be 1 with versions 1.01, 1.02 etc.

I'm guessing this is not possible?

Regards,

Philip Las Gourgues
Cancel
Up 0 Down

Verify Answer

Cancel
0 Offline Arturas Zidonis Tue, Jun 16 2015 3:53 AM in reply to Philip Las Gourgues

Hi Philip,

In ProjectWise Rules Engine the default revision string is XYY.ZZ as written in documentation and this cannot be changed from ProjectWise Interface.

So the only way changes could be done is in stored procedures on a database.

Regards,
Arturas
Cancel
Up 0 Down

Verify Answer

Cancel
0 Offline Philip Las Gourgues Tue, Jun 16 2015 4:08 AM in reply to Arturas Zidonis

Hi Arturas,

Thanks for your reply. I'm happy to conform with that default revision string format but I'm guessing I can't change 'X' to match the revision letter of the document? This is the part I find very puzzling. I would have thought only having this set to "P" would satisfy very few users.

Regards,
Philip Las Gourgues
Cancel
Up 0 Down

Verify Answer

Cancel
0 Offline Arturas Zidonis Thu, Jun 18 2015 4:40 AM in reply to Philip Las Gourgues

Hi Philip,

My colleague sent me a tip how 'X' can be changed from ProjectWise Interface. So this could be done by changing the default value of the custom revision attribute 'REV_RV' in the examples template, from P0.1 to A0.1. But I'm not sure if this will work for you cause you want to change the prefix to be the same as revision.
Are you changing revision attribute manually? maybe this could be achieved by using Select Statement in 'REV_RV' default value..

Regards,
Arturas
Cancel
Up 0 Down

Verify Answer

Cancel