MES Stateless API

GetAll Method (QmSpecAttrLink)

Save PDF

GetAll Method (QmSpecAttrLink)

Save PDF

Last UpdatedNov 06, 2025
2 minute read

The GetAll() method retrieves one or more qm specification attribute link records from the Qm_Spec_Attr_Link table, as specified by the filter parameters. Passing no filter parameters will retrieve all qm specification attribute link records from the table.

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal qmSpecId As Nullable(Of Integer), _
   ByVal attrId As Nullable(Of Integer), _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim qmSpecId As Nullable(Of Integer)
Dim attrId As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = QmSpecAttrLink.GetAll(qmSpecId, attrId, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> qmSpecId,
   Nullable<int> attrId,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

qmSpecId: Optional. Holds the ID of the qm specification linked.
attrId: Optional. Holds the ID of the attribute linked.
lastEditBy: Optional. Holds the ID of a user who added the link record.
lastEditAt: Optional. Holds the datetime when a link record was added.

Return Value

Returns a DataSet that contains all the records in the Qm_Spec_Attr_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
qm_spec_id	An Integer which is unique to the qm specification.
attr_id	An Integer which is unique to the attribute.
attr_desc	A string which identifies the description of the attribute.
predefined	A boolean which identifies whether there is a set of possible values defined for this atribute.
data_type	An integer which identifies the data type of the attribute. 0=string, 1=drop down from values defined in attr_set table, 2=integer, 3=currency, 4=color, 5=datetime, 6=floating point number, 7=percent, 8=checkbox, 9=non-editable, 10=time of day.
entry_type	An integer which identifies the entry type of the attribute. 0 = value only, 1 = notes only, 2 = value and notes.
visible_in_queue	An boolean which identifies whether the attribute is visible in the queue of jobs.
visible_in_inv	A boolean which identifies whether the attribute is visible in inventory.
last_edit_comment	A string that contains comments about why the record was 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