Show TOC

Function documentationMDO Query Locate this document in the navigation structure

 

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.

Features

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.

  • 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.

Activities

To create an MDO query in the SAP MII Workbench, choose   File   New   MDOQuery.  

You must save the query on the Catalog tab in the appropriate project and folder.

To test the MDO query, choose   Tools   Test  .