Method GetNextID for DialogNextID not working anymore?

Question

Hi people, 
 I've recently tried to call the method "GetNextID" on a DialogNextID object using a script. It seems that calling this method does not affect the loaded DialogNextID object. I was wondering if anyone else ran into this problem in 8.0.1. 
 My script below tries to set a DialogNextID to a specific NextNumber throught the object layer (I am ware the same can be achieved through SQL, but why should the callmethod not work in this instance?) 
 Has anyone else tried to use the NextID method already? Thanks for your feedback! 
 
 Public Sub CCC_Set_StartingCount_GlobalID( ByVal globalIDCount As Integer , Optional ByVal resetCounter As Boolean = False ) 
 ' Get or create GlobalID Counter 
 Dim f As ISqlFormatter = Session.SqlFormatter 
 Dim globalID As IEntity = Nothing 
 If Not Session.Source.TryGet(Query.From( "DialogNextID" ) _ 
 .Where(f.Comparison( "Ident_DialogNextID" , "GlobalID" , ValType.String)) _ 
 .GetQuery, globalID) _ 
 Then 
 globalID = Session.Source.CreateNew( "DialogNextID" ) 
 globalID.PutValue( "Ident_DialogNextID" , "GlobalID" ) 
 globalID.Save(Session) 
 End If 
 If Not resetCounter Then 
 ' Set GlobalID counter to appropriate count 
 If CInt (globalID.GetValue( "NextNumber" )) < globalIDCount Then 
 While Not CInt (globalID.GetValue( "NextNumber" )) = globalIDCount 
 
 Debug.WriteLine( CStr (globalID.GetValue( "NextNumber" ))) 
 End While 
 End If 
 Else 
 ' Reset GlobalID Counter 
 CCC_Run_SQLWithResult( String .Format( "UPDATE DialogNextID SET NextNumber = 0 WHERE {0}" , 
 f.UidComparison( "UID_DialogNextID" , globalID.GetValue( "UID_DialogNextID" )))) 
 End If 
 End Sub

Markus Weiss-Ehlers · Accepted Answer

Resetting DialogNextID.NextNumber using the object layer and GetNextID is a bad idea and should not be considered. Please remember that any execution of GetNextID issues a write to the database. So when you are iterating the counter by adding 1 at a time, this puts an unnecessary load onto the database server. 
 If you need to constantly change your NextNumber then it is better to delete the entry in DialogNextID and create a fresh one correctly initialized with your new number. 
 In regards to your claim that calling GetNextID does not change the already loaded object, this is true because it wouldn't make sense to do so in a multi-user environment. At the time the local entity would have been updated, another user (or thread, job service, anything) could have called the same method and your local entity would have been invalid again. 
 By the way, the intended use of DialogNextID is not to read the value from NextNumber but to use the function GetNextID to fetch the next number directly and immediately. A requirement to be able to make that function call, is to load the Entity with the EntityLoadType.Interactive (The same requirement applies to a method call of GetNextID ). 
 Sample: Fetch the next value from DialogNextID 
 Dim globalID As IEntity = Nothing
Dim nextID As Integer

If Session.Source.TryGet(Query.From("DialogNextID"). _
 Where(f.Comparison("Ident_DialogNextID", "GlobalID", ValType.String)). _
 GetQuery, EntityLoadType.Interactive, globalID) Then
 nextID = CInt(globalID.CallFunction("GetNextID"))
End If
 
 You can subsequently call the function and the value will always return the next valid value, regardless what the current value of the NextNumber property. 
 HtH

Markus Weiss-Ehlers · Answer

I tried this again and it works in my environment in the Designer (Script Tester) and in the Object Browser with the short form of the template that calls my script sample. 
 Two things that you need to consider 
 
 The function call GetNextID will return the current value from DialogNextID.NextNumber and update its value in the database afterward. Please keep that in mind as a single test run could fool you into thinking that the value isn't incrementing. 
 In the Script Tester, you have to turn the use of transactions off. Another thing that could fool you into thinking that the value isn't incrementing. 
 
 Anyways, if it still not working in your case you do have a working sample by integrating the code into the template. And be assured that this is working in the next service pack of 8.0 (my environments have newer hotfix builds running than 8.0.1 so if it is running in my environments but not in your 8.0.1 it will be running in 8.0.2 for sure).

Endpoint Privilege Management

Method GetNextID for DialogNextID not working anymore?

Top Replies