You use this function to do one of the following:
Select and return the data associated with a manufacturing data object (MDO)
Insert, update, or delete the data persisted for the custom attributes of a persistent MDO
Join two or more persistent or joined MDOs, that is, the Join query combines rows from the specified tables and views and returns a XML document in illuminator format representing the result of the join.
For more information about MDOs, see Manufacturing Data Object.
An MDO query includes the following template categories:
Data Source
On this screen, you select the server where the MDO is stored and the MDO.
You also select one of the following modes:
AttributeList
Returns a list of the MDO attributes with their associated attribute configuration
Delete
Deletes persisted data
Info
Returns a list of the MDO properties, including name, description, and the custom properties and values defined in MDO configuration
Insert
Inserts persisted data for an MDO with custom attributes only. Persisted data cannot be inserted for an MDO with a data provider and data attributes.
ModeList
Returns the available modes, in this list, for an MDO query
Select
Selects and returns the data for an MDO. For a persistent MDO, the persisted data is returned. For an on-demand MDO, the data provider is executed in real time and the data is returned. To join two are more persistent MDOs, select the MDOs and choose Join from the Modes field.
Update
Updates persisted data for an MDO with custom attributes. You cannot update data attributes associated with a data provider.
Join
Performs joins on two are more selected persistent MDOs. Returns the result of the joins based on the joins defined in the join query panel.
General
For more information, see General Query Parameters.
Date Range
For more information, see Date Range for Queries.
Select Query
If you are using Select mode, you use this screen to configure your query. You can select attributes from the Available Attributes list, which are attributes from the MDO. For more information about the expression and Date Column fields on this screen, see SQL Query Parameters.
Join Query
If you are using Join Query mode, you use this screen to join two or more persistent MDOs and/or Joined MDOs. You can select attributes from the Available Attributes list. You can join tables based on Inner Join and Left Outer Join, and set conditions for the query. For more information on joining MDOs, see Join Query for MDOs.
The expression used for defining Joins must be assigned to Joins parameter in a specific format.
Example
<Joins><Join IsMinimized="true" JoinType="INNER JOIN" LeftTable="Migration/MIIOBJ/Employees1" RightTable="Migration/MIIOBJ/Employees2"><Condition LeftCondition="[Migration/MIIOBJ/Employees1.eid]" Operator="=" RightCondition="[Migration/MIIOBJ/Employees2.eid]"/></Join/><(><<)>/Joins>
Update Query
If you are using Update mode, you use this screen to configure your query.
The attributes from the MDO are listed in the Available Attributes list. You can update custom attribute values only; you cannot update attributes associated with the data provider.
You can use the Filter Expression to update specific records in the persisted data.
Insert Query
If you are using Insert mode, you use this screen to configure your query.
The attributes from the MDO are listed in the Available Attributes list. You can update custom attribute values only.
You can use the Filter Expression to update specific records in the persisted data.
Delete Query
If you are using Delete mode, you use this screen to configure your query.
The attributes from the MDO are listed in the Available Attributes list.
You can use the Filter Expression to update specific records in the persisted data. If you do not provide a filter statement, all records in the persisted data are deleted.
Object Parameters
You use this screen to specify the values for MDO parameters, which are used by the MDO query to specify the MDO persisted data records to be selected, inserted, updated, or deleted based on the mode.
Parameters
You use this screen to specify the value for parameters defined in the MDO query attribute values or filter statement.
You use the Parameter Type dropdown to select the data type for the parameter. The system checks the parameter value against the selected data type.
Transformation
For more information, see Transformation.
Security
You use this screen to authorize roles to read or write to an MDO.
To create an MDO query in the SAP MII Workbench, choose
You must save the query on the Catalog tab in the appropriate project and folder.
To test the MDO query, choose
.