E1: GRID: Advanced Query Management Displays Only Comparison Operators '!=' and '=' for Integer Data Item INT01

(Doc ID 1670895.1)

Last updated on NOVEMBER 01, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.


Advanced query defined on grid column associated to business view column INT01 only allows for the != and = comparison operators.

The QBE field itself allows result filtering based on operators =, !=, >, >=, < and <=

The data item INT01 is standard and it is defined as an INTEGER numeric value with 4 digits.

Expectation is that Advanced Query should allow for the same comparison operators as QBE.

   Figure1: Query management form only shows 2 comparison operators




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms