MES Stateless API

GetAll(Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,String,String,Nullable<DateTime>) Method

Save PDF

GetAll(Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,String,String,Nullable<DateTime>) Method

Save PDF

Last UpdatedNov 06, 2025
2 minute read

The GetAll() method retrieves one or more language string records from the Language table based on the specified filter parameters. If no filter parameters are provided, it retrieves all the language string records from the table.

Syntax

'Declaration
 
Public Overloads Shared Function GetAll( _
   ByVal langId As Nullable(Of Integer), _
   ByVal stringId As Nullable(Of Integer), _
   ByVal grpId As Nullable(Of Integer), _
   ByVal value As String, _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim langId As Nullable(Of Integer)
Dim stringId As Nullable(Of Integer)
Dim grpId As Nullable(Of Integer)
Dim value As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = Language.GetAll(langId, stringId, grpId, value, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> langId,
   Nullable<int> stringId,
   Nullable<int> grpId,
   string value,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

langId: Optional. Holds the ID of the language.
stringId: Optional. Holds the ID of the string.
grpId: Optional. Holds the ID of the string group. This parameter facilitates navigation to many language strings.
value: Optional. Holds the language string value.
lastEditBy: Optional. Holds the ID of a user who added or last updated a language string link record. Defaults to null.
lastEditAt: Optional. Holds the date/time when a language string record was added or last updated. Defaults to null.

Return Value

Returns a DataSet that contains a DataRow for each language string record in the Language table that satisfies the specified filter criteria. If no matching record is found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name	Description
lang_id	An integer that is the ID of the language for which the string is being added, from the Language table.
string_id	An integer that is the ID of the string being added, from the Language table.
grp_id	An integer that is the ID of the string group, which facilitates navigation to many language strings, from the Language table.
string	A string that is the language string value, from the Language table.
context	A string that identifies the context (i.e., the meaning or usage) of the string, from the Language table.
last-edit_comment	A string that contains comments about why the record was added or updated.
last_edit_by	A string that is the ID of the user who added or last updated this record.
last_edit_at	A date/time that indicates when the record was added or last updated.

MES Stateless API