Tuesday, October 24, 2017

exportButton Item Style in Oracle OAF

  • The exportButton item style is used to export the displayed data of either a region or all regions on a page to a comma separated value (csv) file. Only the beans that are rendered will be exported. 
  • Each region on the exported file will have a row of column names followed by the results.
  • In Windows, clicking on the export button will open a dialog that asks you to either open or save the exported file. You could view the Excel file either by opening it directly or saving and then opening it.
  • exportButton can be used as follows:
  1. Exporting the data of all regions on a page: For this, create a contentFooter region under the pageLayout region of that specific page. Then add an "Export Button" to the contentFooter region. If more than one button needs to be added to the contentFooter, then they should be put under a flowLayout region, which should then be added to the contentFooter.                                
  2. Exporting data of a specific region on a page: For this, create an "Export Button" under the region whose data you want to export. Then, in the container object, position this export button and set a view usage name for this export button. The data of this VO will be exported.
The java bean associated with this Item Style is: OAExportBean

No comments:

Post a Comment

Query to get the Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...