Results 1 to 3 of 3

Thread: JDE Object Browser Data Browse

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

    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 {from..to}. 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
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace, NERDup and BusBuild+ Tools

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

  2. #2
    Member nkuebelbeck's Avatar
    Join Date
    Mar 2012
    Location
    Minnesota
    Posts
    556
    #3,#4

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

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

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.