How are null DB values handled when accessed via a query rule?

Certified Associate Developer

Hello Everyone.

How are null DB values handled when accessed via a query rule? When I use a query rule to retrieve a CDT the isnull() expression returns false on the single object even though the underlying table has null stored as the value.

The field in question is of type Integer and Decimal and I'm running 6.6.1. Instead of isnull() I've actually had to resort to using the len() function on the value after casting it to a string....

OriginalPostID-65941

OriginalPostID-65941

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    I have seen java return a value of 0 when checking isnull against primitive int types so its quite possible this could be happening here. Maybe someone from Appian can confirm.

    Null's can be tricky in RDBMS unless you're querying it natively. On our Oracle instances here I always use the NVL(column1, 999) type syntax rather than trusting or relying on a jdbc driver connection to do what I'd expect!
Reply
  • 0
    Certified Lead Developer
    I have seen java return a value of 0 when checking isnull against primitive int types so its quite possible this could be happening here. Maybe someone from Appian can confirm.

    Null's can be tricky in RDBMS unless you're querying it natively. On our Oracle instances here I always use the NVL(column1, 999) type syntax rather than trusting or relying on a jdbc driver connection to do what I'd expect!
Children
No Data