Manage Learn to apply best practices and optimize your operations.

Fast Sort For Multi-Value Fields

I developed this script as an efficient way to sort multi-value fields. We
added a Sort button to the address book template group form so that group
administrators could simply add people to the end of the group and click the
sort button to re-order the list. The script can also be used in the exiting
event of a field to sort the entries. I've also used it to generate a single,
sorted keyword list from two sources.
Sub Click(Source As Button)
Dim workspace As New NotesUIWorkspace
Dim uidoc As NotesUIDocument
Dim doc As NotesDocument
Dim k As Integer
Dim i As Integer
Dim j As Integer
Dim h As Integer
Dim r As Integer
Dim memberArray() As String
Dim temp As String

Set uidoc = workspace.CurrentDocument
Set doc = uidoc.Document

'Build an array of values to sort
For k = 0 To Ubound(doc.FieldNameToSort)
Redim Preserve memberArray(1 To k+1)
memberArray(k+1) = Cstr(doc.FieldNameToSort(k))

'Set up for Shell sort algorithm
h = 1
Do While h < k
h = (h*3)+1
h = (h-1)/3
If h > 3 Then
h = (h-1)/3
End If

'Shell sort algorithm
Do While h > 0
For i = 1+h To k
temp = memberArray(i)
j = i-h
Do While j >0
If memberArray(j)>temp Then
memberArray(j+h) = memberArray(j)
memberArray(j) = temp
Exit Do
End If
j = j-h
Next i
h = (h-1)/3

'Write new field value to back-end doc and reload front-end doc
Call doc.ReplaceItemValue("FieldNameToSort", memberArray)
Call uidoc.Reload

End Sub

Dig Deeper on Domino Resources - Part 6

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...