Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to set Dynamic Query Parameters in MDO query

Dear Experts,

I'm using MII 15.0.

I've created a MDO object.

And I've created a MDO query which mode is : insert.

It works well when I put fix value in Insert Query tab Attribute Value.

My question is :

  1. How to set a dynamic parameter in Insert Query tab, and then insert the data dynamically?
  2. How to test the MDO query with a dynamic parameter?
  3. How to test the Transaction with a dynamic parameter MDO query?
  4. Is there any document of how to use the MDO in MII?
  5. Is there a management tool to manage the MDO tables? to CRUD the records in MDO table more easily.

Thank you!

Best Regards!

Feng Sihao

Tags:
replied

HI Feng,

In any MDO Query Template where you want to 'dynamic' values, map a Param.x template property to each MDO Attribute that you need to insert/update. You can also user Param.x template properties in the Filter and Sort expressions. When you assign or use a Param.x property, enclose it in [] like this:

example attribute mapping:

example Where clause:

where Attribute1 =='[Param6]'  //note that you have to quote strings like this.

You can assign a data type to the Params, and assign a default value to a Param. I recommend that you assign a data type to each used Param tha exactly matches the data type of the MDO attribute that you want to map to, or when used in a Sort of Filter expression.

There are no MDO Management tools that I know of, you have to build MDO Queries for all Insert/Update/Delete queries, and manage the MDO object from MII Workbench.

Regards, Steve

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question