Resequence Items in a Query?

MichaelQ

How can I recalculate sequential numbers in the rows of a sorted query?

Each row/object has a "Sequence" attribute.
Say the starting number must be 40.
Each subsequent row must increment by 2.

My understanding is that the "Increment" command increments the existing attribute value whereas I need to recalculate/overwrite that value based on the value of the previous row.

Thanks.

aware_support

The core of the task should be done by a sub-process that takes current instance of the object as input (ThisObject):

// find the previous row
FIND Object WHERE Object.SeqNo < ThisObject.SeqNo ORDER BY Object.SeqNo DESC TAKE BEST 1
// increment current instance
IF SEARCH_COUNT > 0 Then
ThisObject.SeqNo = ThatObject.SeqNo + 2
ELSE
ThisObject.SeqNo = 40 // first one

The calling process should just find all objects and call the sub process
FIND ALL Object
SubProcess

MichaelQ

Will the SubProcess inevitably process the objects found by the FIND ALL OBJECT in a random sequence, or can the FIND ALL OBJECT have an ORDER BY Object.Attribute to force the SubProcess to process them in a sequence?

I tried an ORDER BY but it didn't seem to work consistently.

Thank you.

aware_support

In 8.0 processing of objects in the Context will be done in the random order and ORDER BY in FIND will be ignored.

This is fixed in 8.1