MES Stateless API

GetAll Method (JobExecStorageExecLink)

Save PDF

GetAll Method (JobExecStorageExecLink)

Save PDF

Last UpdatedNov 06, 2025
2 minute read

The GetAll() method retrieves one or more job execution/storage execution link records from the Job_Exec_Storage_Exec_Link table, as specified by the filter parameters. Passing no filter parameters will retrieve all job execution/storage execution link records from the table.

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal entId As Nullable(Of Integer), _
   ByVal storageEntId As Nullable(Of Integer), _
   ByVal applyToCons As Nullable(Of Boolean), _
   ByVal applyToProd As Nullable(Of Boolean), _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim entId As Nullable(Of Integer)
Dim storageEntId As Nullable(Of Integer)
Dim applyToCons As Nullable(Of Boolean)
Dim applyToProd As Nullable(Of Boolean)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = JobExecStorageExecLink.GetAll(entId, storageEntId, applyToCons, applyToProd, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> entId,
   Nullable<int> storageEntId,
   Nullable<bool> applyToCons,
   Nullable<bool> applyToProd,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

entId: Optional filter parameter. Holds the ID of the entity.
storageEntId: Optional filter parameter. Holds the ID of the storage entity.
applyToCons: Optional filter parameter. Holds a flag that, if set to true, specifies that the job can consume items from a storage entity. The default is true.
applyToProd: Optional filter parameter. Holds a flag, if set to true, specifies that the job can produce items from a storage entity. The default is true.
lastEditBy: Optional filter parameter. Holds the ID of the user who added or last updated a job execution/storage execution link record.
lastEditAt: Optional filter parameter. Holds the date/time when a job execution/storage execution link record was added or last updated.

Return Value

Returns a DataSet that contains all the records in the Job_Exec_Storage_Exec_Link table that satisfy the specified filters. If no matching records are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name	Description
ent_id	An integer that is the ID of the entity.
storage_ent_id	An integer that is the ID of the storage entity.
apply_to_cons	A Boolean that is a flag that specifies whether the job can consume items from the storage entity.
apply_to_prod	A Boolean that is a flag that specifies whether the produced items can be stored in the storage entity.
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