E1: GRID: Advanced Query Management Displays Only Comparison Operators '!=' and '=' for Integer Data Item INT01
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