My Oracle Support Banner

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




To view full details, sign in with your My Oracle Support account.

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

In this Document

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