Results 1 to 3 of 3

Thread: Help on Retrieve Data Selection Business Function

  1. #1

    Help on Retrieve Data Selection Business Function

    Hi,
    I would like to know the usage of the business function RetrieveDataSelection .
    It will be also helpful if there is some other method by which we can retieve the data selection entered by the user.

    Thanx & Regards
    Jiju


  2. #2
    Senior Member
    Join Date
    Jul 2001
    Location
    Colorado
    Posts
    154

    Re: Help on Retrieve Data Selection Business Function

    The implementation of the B9600430 is an object-based implementation. To use the B9600430, you need to do the following:

    1. Create a report with a business view
    2. On the Do Section event, call stop section processing (i.e. do not let the UBE engine do anything)
    3. Put all you ER in the End Section.
    4. Create a variable in ER of type CDHNDL
    5. Call InitSelection (pass in table or view name) it passes an initialized idRecordSet back
    6. Call RetreiveDataSelection (I know it was misspelled) with the idRecordSet and the sectionID. The section ID can be found using UTB with TAMMenus=Show. Look up the RDASPEC record for your UBE. Note that if you just added your UBE and you want the main section this section will be id 1. (It's somewhat of a pain I know)
    7. Add additional data selection with AddSelect.
    8. Call Select to do the selection
    9. Fetch and process records in a business function
    10 when you are done, make sure to call Cleanup and pass in the idRecordSet.

    For a complete end-to-end example, you can look at the report R9647I.

    What you will notice is that the B9600430 is a data selection system (Init, use, cleanup). It is useful to use when you want to get the reports data selection and do non-trivial data selection and processing.

    Cheers,
    Chris Bruce
    www.ReportsNow.com

  3. #3
    Member
    Join Date
    Apr 2001
    Location
    San Diego, CA 92121 USA
    Posts
    40

    Re: Help on Retrieve Data Selection Business Function

    Jiju,
    If you still cannot figure out how to use RetrieveDataSelection BSFN after spending some time to study R9647I, send an email to me, thui@kitchell.com

    I may have some solution for you.
    Tsunghan Tim Hui
    tthui51@hotmail.com
    ERP 8.12, Tool Release 8.98.0.1
    OAS
    DB=SQL 2005
    WS=WINXP
    ES,DS=WIN2003

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.