New in IC2007-1: Calculated to-do persons

The InnoCielo 2007-1 release adds support for calculating to-do persons and groups via VBScript expressions. Users can be specified as a simple list, but also as an array of 1-dimensional arrays, or as a 2-dimensional array in order to achieve grouping. Below are some basic examples of these expressions. Note that calculated groups are not yet available in WebAccess.

This example function returns a simple list of usernames.

Function SimpleUsers
    'Just 
 1D array with UserName (short logon names)
    SimpleUsers 
 = Array("User1", "User2", "User3") 
End Function

This example returns a two dimensional array. Each row in the array consists of a groupname a username and an optional fullname. Users will be shown categorized by the group.

Function TableUsers
    'Users is programmatic table (2D array)
       'Column 0 - group name
       'Column 1 - UserName (short logon name)
       'Column 2 (if any) - User Full Name
    Dim users(2,2)
    users(0,0) = "Group 1"
    users(1,0) = "User1"
    users(2,0) = "User 1 full name"
    users(0,1) = "Group 2"
    users(1,1) = "User2"
    users(2,1) = "User 2 full name"
    users(0,2) = "Group 1"
    users(1,2) = "User3"
    users(2,2) = "User 3 full name"
    TableUsers = users
End Function

This example returns a two dimensional array filled with the contents of a table in the Vault.

Function QueryUsers

    'Users 
 is query result table (2D array)

        'Column 
 0 - group name

        'Column 
 1 - UserName (short logon name)

        'Column 
 2 (if any) - User Full Name

    QueryUsers 
 = Vault.Table("Users").GetValues(,,Array("Group","User","FullName"))

End Function

This example returns a simple array of 1-dimensional arrays where the first element in each sub array is a group name and all other elements are usernames.

Function GroupedUsers

    '1D 
 array of 1D arrays for each group entry

    'Group 
 entry is 1D array

        'Element 
 0 - Group name

        'Element 
 1 - Group Users

            'Group 
 Users is 1D array of UserNames

    GroupedUsers 
 = Array ( _

        Array 
 ("Group 1", Array("User1", "User2")), _

        Array 
 ("Group 2", Array("User1", "User3", "User4")), 
 _

        Array 
 ("Group 3", Array("User2", "User3")) _

    )

End Function

24798 Expression to calculate user list