Wednesday, April 27, 2011

BI Publisher: XDOXSLT:IS_NUMERIC Not Handling Negative Numbers


We have an inbuilt function IS_NUMERIC in BI Publisher template builder.  This function is mainly used to validate whether a given value is a numeric value or not. Based on that, this function will return either TRUE or FALSE.


But according to the recent bug:12401094, this function treats the negative sign (-) as a character value and returns FALSE.

for example –1245.00 will be considered as character value and it will be return FALSE.

So developers, beware of this bug and do not waste time in thinking your code have some issue :)

Note: I got this information in the XDO email group where, this issue was raised by Kavipriya Krishnaswamy and confirmed as bug by Kathy Gao and Pieter Breugelmans.


No comments:

Post a Comment