MES Stateless API

GetFromGroups Method

Save PDF

GetFromGroups Method

Save PDF

Last UpdatedNov 06, 2025
2 minute read

The GetFromGroups() method checks if the user is in the User_Name table. If not, it checks if the security mode is set to OS Group. If the security mode is set to OS Group, it checks to see if any of the supplied SIDs match the SID of any group in the Grp_Name table. If so, the user is added to the User_Name table. Finally, the user's entry in the User_Name table is returned.

Syntax

'Declaration
 
Public Shared Function GetFromGroups( _
   ByVal userId As String, _
   ByVal securityIds() As String _
) As DataSet

'Usage
 
Dim userId As String
Dim securityIds() As String
Dim value As DataSet
 
value = UserName.GetFromGroups(userId, securityIds)

public static DataSet GetFromGroups( 
   string userId,
   string[] securityIds
)

Parameters

userId: Required. Holds the ID of the user.
securityIds: Required. Holds an array of SIDs that represent the OS groups to which the user belongs.

Return Value

Returns a DataSet with a single row containing the details for the specified user.

The columns of the returned DataSet are described below.

ColumnName	Description
user_id	A string that is the ID of the user.
user_desc	A string that is the description of the user.
encrypt_pw	A string that is the encrypted password of the user.
active	An integer that is a flag that specifies whether the user is active.
hourly_cost	A double-precision floating point number that identifies the cost of labor per hour.
email_address	A string that is the external e-mail address of the user.
lang_id	An integer that is the preferred language of the user.
def_dept_id	An integer that is the default labor department of the user.
last_login	A datetime value that identifies the last login time of the user.
last_pw_change	A datetime value that identifies the datetime when the password was last changed.
auth_method	An integer that identifies the authentication type.
def_lab_cd	An integer that identifies the default labor code for the user.
smtp_server	A string that identifies the name of the user's SMTP server.
pop3_server	A string that identifies the name of the user's POP3 server.
email_account	A string that identifies the name of the user's e-mail account.
email_pw	A string that identifies the password of the user's email account.
spare1	A string that is the contents of the spare1 field.
spare2	A string that is the contents of the spare2 field.
spare3	A string that is the contents of the spare3 field.
spare4	A string that is the contents of the spare4 field.
last_edit_comment	A string that is the comment about why the record was added or changed.
last_edit_by	A string that is the user ID of the user who added or last edited this record.
last_edit_at	A datetime that identifies when the record was added or last modified.
mod_id	The current modification ID of the record in the table. This ID is binary number that increments each time the record’s table row is modified. Optionally used for optimistic concurrency control when performing updates or deletes.
row_id	An integer that is the row identifier of the record.

MES Stateless API