My Oracle Support Banner

E1: GRID: Frequently Asked Questions on the Query by Example (QBE) Line (Doc ID 2114144.1)

Last updated on MARCH 08, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 and later
Information in this document applies to any platform.

Purpose

This document covers some frequently asked question on the Query by Example functionality found within E1.  See Document 649443.1 E1: GRID: How to Use the Query by Example (QBE) Line for further details.

Questions and Answers

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
Purpose
Questions and Answers
 Question 1: What causes a QBE Column to be disabled or grayed-out?
 Question 2: How to search for a blank value in QBE line?
 Question 3: Is it possible to do QBE search on associated description field ?
 Question 4: How to Auto Populate a QBE Line?
 Question 5: When attempting to perform a QBE search based on a value of zero, why is the zero value not retained?
 Question 6: How can I default the cursor to the first QBE column on the grid? 
 Question 7: Is there a way to control QBE line case sensitivity?
 Question 8: Query Limits with Padded Data Items
 Question 9: Why am I Unable to Search for Correct Data for Amount Fields with Currency?
 Question 10: Can QBE be able to filter or search in double byte language?
 Question 11: Is there an API or business function that will return the complete QBE value including the operator?
References

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