Skip to Content

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

Ho to handle "---" in filter of Delete Query?

Hi guys

once again a question.

I got a MDO having 3 columns A B C.

In there is a dataset looking like ['a', NULL, NULL] what looks like ['a', '---', '---'] in MII.

Want to delete this using a Query.

My Fiterexpression looks like [A] = [Param.1] AND [B] = [Param.2] AND [C] = [Param.3]

Tried to pass "---", "", nothing...but nothing works.

Any idea?

Thanks for your support!

Former Member

You could try using the stringif function in the link editor when you assign your params. Something like stringif(<value>=="---", " IS NULL", " = " & <value>  ) may work. I haven't used MDO that much but usually MII just does a replace of your [Param.1] so you typically can pass an '=' in the param etc.


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question