Skip to Content

MDOQuery type Delete with datetime filter

Hi, experts!

I created MDOQuery of mode "Delete" with Filter Expression like

[Field1] BETWEEN [Param.1] AND [Param.2]

It causes error

This kind of expression works fine for "Select" mode and I guess it's because of corresponding values "Timestamp" in Parameter Type column in Parameters section. But there is no such column in "Delete" mode. So, the question is how to construct dynamic filter expretion to delete records from MDO applying datetime filter?

MII 15.1.2.12, DB Oracle 12c, Open SQL 7.10

Regards,

Petr

oym0b.png (8.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 09 at 03:59 PM

    In the SQL query go to parameters tab. then tick the the use Typed Parameters. Then set the one of the parameter as type "TimeStamp" then use that parameter in the where clause for dates.


    Regards,

    Abhijeet

    Add comment
    10|10000 characters needed characters exceeded

    • Abhijeet, thanks! I've forgot about this option on Parameters tab. It was enabled in another MDOQuery, but it was off in this one.

      Regards,

      Petr