Negative Values are not storing on the DFF Field created for a Page (Doc ID 2387827.1)

Last updated on APRIL 20, 2019

Applies to:

Goal

On : 11.12.1.0.0 version, Classification

How to use the Between Operator for Staring Negative(-1) values?

Between operator is not fetching expected results

Based on a requirement to store negative number(Through a Custom DFF) in a custom number attribute for which  created a custom character attribute due to system limitation.

This attribute is used in an expression for getting sum(custom character attribute) which has been achieved by converting the character to number. Now, there exists a challenge with classification wherein it is supposed to put following criteria on a couple of custom character fields.

Condition 1 : Value < 100 (should consider -ve values as well)
Condition 2 : Value > 0

Condition 2 SEEMS to be achievable by putting a condition [is not like '-%']
For condition 1, tried the following and it doesn't work as expected.

1) is between 0 to 100 OR is like '-%'

**Is Between is also considering a value greater than 100
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.