Results 1 to 8 of 8

Thread: Searching QBE lines over DD fields

  1. #1
    New Member
    Join Date
    Aug 2002
    Posts
    14

    Searching QBE lines over DD fields

    Hi Everyone

    I have designed a form that does not have a view attached to it. I am trying to query data over data dictionary fields on the grid. How can I query on the DD fields as the fields are greyed out as there is no QBE functionality associated to DD?

    Any help would be appreciated.

    Thanks
    Sai

  2. #2
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,224
    Hi

    I don't understand this?
    If there is no view, where is the data coming from? Are you reading a table and using Insert Grid row Buffer to populate grid data by chance?

    Depending on the form there is a tick box in the form form properties to hide QBE by example. Find Browse have them by default switched on, Headerless Details switched off
    John Danter
    You don't go out looking for a job dressed like that do you, on a weekday?

    E900 TR 9.1.5.3 Unix

  3. #3
    Senior Member
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas
    Posts
    1,416
    Unless a column is bound to a business view there is not any way to enable the QBE cell for that column. So if you are programatically filling the grid (i.e. loading from jdeCache or some other means) and you want filtering you would have to simply add some FC controls and manually filter on those values. The data bound controls (columns/fields bound to a bsvw field) like QBE and FC fields that are flagged as filter fields basically result in the WHERE clause of the SQL statement when the find button is pressed. Unfortunately there is not a "search within results" mechanic for E1 grids. I really wish there was because I have quite a few apps where the grid is filled programatically like I suspect you are doing.
    Brian Oster
    Application Development Manager
    E1: 9.0 (TR9.1.5.1)
    JAS: Weblogic 12.1.2 (Win2012 64 bit)
    ES: Win2008 64 bit
    DB: MSSQL 2008
    WebDev Client: Win7Pro (64 bit)

  4. #4
    New Member
    Join Date
    Aug 2002
    Posts
    14
    Yes, you are correct reading data from a table and loading into Grid Buffer to populate grid data....


    Quote Originally Posted by johndanter View Post
    Hi

    I don't understand this?
    If there is no view, where is the data coming from? Are you reading a table and using Insert Grid row Buffer to populate grid data by chance?

    Depending on the form there is a tick box in the form form properties to hide QBE by example. Find Browse have them by default switched on, Headerless Details switched off

  5. #5
    New Member
    Join Date
    Aug 2002
    Posts
    14
    Thanks for the input

  6. #6
    New Member
    Join Date
    Aug 2002
    Posts
    14
    Yes you are right. Loading data via table into grid buffer before populating the grid.

  7. #7
    Member
    Join Date
    Feb 2001
    Location
    UK
    Posts
    67
    You could create a work table, load it from the table you are currently reading and create a business view over the work table to use in your form. QBE functionality will then be available.
    Last edited by Neal Scarr; 12-06-2017 at 05:03 PM.
    Neal Scarr
    QSoftware Global Limited

    XE SP.24 to E9.2 TR 9.2.0.2

  8. #8
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,094
    Sai,

    QBE values act as modifiers to the SQL WHERE clause JDE generates to query the database. QBE Find/Query does NOT operate on the current contents of your grid.
    If you're going to manually populate the grid you'll have to come up with your own means to filter the data.
    Larry Jones
    E1 9.1 - TR 9.1.5 on Win 2012 R2. Oracle DB 11.2.04
    WebLogic 12.1.3, Wintel, BI Publisher

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company, Oracle or Peoplesoft.