Results 1 to 4 of 4

Thread: JDE Object Browser Data Browse

  1. #1
    Senior Member craig_welton's Avatar
    Join Date
    Oct 2000
    Litchfield, CT

    JDE Object Browser Data Browse

    Hi folks,

    I've had several people ask about some capabilities in the Data Browse tool, so I figured I would post here ...

    1. You can drag columns to create your own customized "view" of the table or view. When dragging, hold down the shift key and it will go into turbo mode. This makes it faster to get those columns to the left.

    2. Double click the column header to sort on the column. Keep double clicking to cycle through Asc, Desc and no sort. The order of the sorted columns in the grid controls the ORDER BY clause in the query.

    3. Select a range of values (SQL BETWEEN) using the syntax {}. So for F0101 AB records between 100 and 500 {100..500}

    4. Select list of values (SQL IN) using the syntax {x,y,z}. So for F0101 AB records 100,200 and 500 {100,200,500}

    5. Save your Query (column order, filter values) to a file to use again from Data->Save Query menu option.

    I'm thinking of creating a column finder tool in the Data Browse window where you can type in the DD item name and it will find the column for you.

    thanks for the continuing support,
    Craig Welton
    PatWel Group Inc.
    Home of the FREE JDE Object Browser, JDETrace, NERDup and BusBuild+ Tools

    E1 9.0 Wintel SQL 2008
    E1 9.2 iSeries

  2. #2
    Member nkuebelbeck's Avatar
    Join Date
    Mar 2012

    this is gonna change my life. thanks for posting this.
    E1: 9.2 | TR: | JAS: WebLogic | ES: OS400
    DB: DB2 | WebDev Client: Win7Pro (64 bit), VS 2013

  3. #3
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Cork, Ireland
    I didn't know about the range, that's epic. I knwo about the list. So thanks

  4. #4
    Another one which could be very helpful is a way to copy paste values from excel or list into query tool for the list of values . If you plan to make list like sql query using the IN clause , then I assume copy paste functionality will come with it someway to enable that and we would be relieved of inserting each value one by one by pressing small + sign .

    Another one (which is probably for Oracle ) is if they can provide a way to use SL Date -1 or SL date + 1 and something like that would be great and we dont have to create processing options and handle it internally by set selection

Thread Information

Users Browsing this Thread

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

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 and, or Oracle.