MES Stateless API

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

Save PDF

GetAll(Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,String,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, as specified by the filter parameters. Passing no filter parameters will retrieve all language string records from the table. This overload includes the context filter parameter.

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 context 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 context As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = Language.GetAll(langId, stringId, grpId, value, context, lastEditBy, lastEditAt)

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

Parameters

langId: Optional. Holds the ID of the language.
stringId: Optional filter parameter. 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.
context: Optional filter parameter. Holds the meaning or usage of the string.
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