Skip to Content
avatar image
Former Member

MII 12.1 TimeUnavailable insted of nulldate

Hi,

I'm currently facing a problem in MII 12.1.

I have a SQL query template, that executes a sql statement on an ORACLE database like

select field from table

The field is of datatype date and can be null.

I'm calling this sql query in a transaction and iterate over the result rows with a repater.

In the repeated code I wan't to do different things depending on if the field is null or not.

In MII 12.0 I used the conditional action and added the following as input:

Repeater_0.Output{/Row/field}==nulldate

But in MII 12.1 this condition always returns false. The only way I found to get this working was to use the following condition

Repeater_0.Output{/Row/field}=="TimeUnavailable"

It seems to me that it is not possible to get null values from date fields in a transaction?!

If I do the same for a char field and compare with nullstring, it does work.

Does anyone know this behaviour and has a solution?

Regards Timo

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 15, 2010 at 09:24 AM

    Timo,

    what version of 12.1 are you using?

    The function "nulldate" should return "TimeUnavailable" like in 12.0. [In this thread|http://forums.sdn.sap.com/click.jspa?searchID=48350486&messageID=8655469] it is mentioned that there has been an error in 12.1.3 and a fix for this.

    Michael

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      That's exactly what I've done now.

      I'll come back here and post the relevant information when the SAP support has answered or pointed out a solution to me.

      Timo

  • avatar image
    Former Member
    Aug 04, 2013 at 07:46 PM

    Try using NVL or NVL2 function it might solve your problem.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2013 at 02:09 AM

    Does anybody solve this issue? I always received a true with a conditional using:

    qrySQLgetLast.Results{/Rowsets/Rowset/Row/initialdate} != nulldate

    qrySQLgetLast.Results{/Rowsets/Rowset/Row/initialdate} != ""

    qrySQLgetLast.Results{/Rowsets/Rowset/Row/initialdate} != "TimeUnavailable"

    qrySQLgetLast.Results{/Rowsets/Rowset/Row/initialdate} != null

    qrySQLgetLast.Results{/Rowsets/Rowset/Row/initialdate} != nullstring

    Can you help me, please

    Add comment
    10|10000 characters needed characters exceeded