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
replied

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.

Regards,
Christian

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