Download Custom Excel by Select Query on button click ( without IR/IG Report )

-



Note 1:- Pre-rendering only advisable if you want to generate excel from Interactive Grid Page other wise below process you can directly call from submit Page --> process 

Note 2:-  If calling from submit Page (button) --> then make sure Reload on Submit should be "Always" on page property

 1) Create Blank Page --> Pre-Rendering --> Before Header --> Process --> Download Excel 

declare
    l_highlights     apex_data_export.t_highlights;
    l_context        apex_exec.t_context;
    l_export         apex_data_export.t_export;
    l_print_config    apex_data_export.t_print_config;
begin
    -- apex_data_export.add_highlight(
    --     p_highlights          => l_highlights,
    --     p_id                  => 1,
    --     p_value_column        => 'HIGHLIGHT1',
    --     p_display_column      => null,
    --     p_text_color          => '#FFFF',
    --     p_background_color    =>  '#F5B642');
    l_context := apex_exec.open_query_context(
        p_location    => apex_exec.c_location_local_db,
        p_sql_query   => 'select rownum as "SR.NO",
                                 INCITMTYP as "ITEM.TYPE",
                                 prtpfx as "PRTPFX",
                                 item_code as "PART CODE",
                                 item_name as "DESCRIPTION",
                                 unit as "UNIT",
                                  null as "BATCH.NO",
                                 null as "Prod.Date",
                                 null as  "Exp.Date",
                                 txt6 as "COUNTRY OF ORIGIN",
                                  null as "QTY",
                                 null as "RATE",
                                 null as  "VAT%"                           
                                 from item_mast'); 

-- l_print_config := apex_data_export.get_print_config(
--         p_body_font_color             => '#4B4540',
--         p_page_header                 => 'Header - ????',
--         p_page_header_font_color      => '#4B4540',
--         p_page_header_font_size       => 14,
--         p_page_header_font_weight     => apex_data_export.c_font_weight_bold,
--         p_page_footer                 => 'Footer - ????',
--         p_page_footer_font_color      => '#4B4540',
--         p_page_footer_font_size       => 14,   
--         p_page_footer_font_weight     => apex_data_export.c_font_weight_bold,
--         p_border_width                => 1,
--         p_border_color                => '#4B4540');                            
    l_export := apex_data_export.export (
                        p_context      => l_context,
                        p_format       => 'XLSX',
                        p_print_config => l_print_config,
                        p_highlights   => l_highlights );
    apex_exec.close( l_context );
    apex_data_export.download( p_export => l_export );
exception
    when others then
        apex_exec.close( l_context );
        raise;
end;




2) Now Go to Interactive Grid Page --> Create Button and on click redirect on above blank page 








 

Comments

Post a Comment

Popular posts from this blog

Telegram Integration with Oracle

-
 How to Integrate Telegram with Oracle Apex 1) create Telegram Account in your Mobile like whatsapp 2) Ones you register in telegram apps serach for BotFather 3) To Create New Bot u need to enter below command  /newbot  Alright, a new bot. How are we going to call it? Please choose a name for your bot. Macsbot Good. Now let's choose a username for your bot. It must end in `bot`. Like this, for example: TetrisBot or tetris_bot. MacsOmanBot Done! Congratulations on your new bot. You will find it at t.me/MacsOmanBot. You can now add a description, about section and profile picture for your bot, see /help for a list of commands. By the way, when you've finished creating your cool bot, ping our Bot Support if you want a better username for it. Just make sure the bot is fully operational before you do this. Use this token to access the HTTP API:<Here you will prompt with your api> 4) /mybots (this command will return the list of bots which you have created) ...
Read more

Row Initialization event on the IG region (Set Default value for column of Row)- Oracle Apex

-
1)  Create a dynamic action for the Row Initialization event on the IG region. 2) Event :- Row Initialization    Action :- Execute Java Script code     Set Fire on Initialization to No' var val,     model = this.data.model,     rec = this.data.record,     erec =  $v("P404_ITEM_CODE"),     erec1=$v("P404_COMPCD"),     meta = model.getRecordMetadata(this.data.recordId); if ( meta.inserted ) {     val = model.getValue(rec, "ITEM_CODE")     if ( val.v === val.d )       { model.setValue(rec,"ITEM_CODE", {d:apex.item("ITEM_CODE").displayValueFor(erec), v: erec});     }     val = model.getValue(rec, "COMPCD");     if ( val.v === val.d ) {         model.setValue(rec,"COMPCD", {d:apex.item("COMPCD").displayValueFor(erec1), v:erec1});     }     }
Read more

The username or password for the connection pool named |apex||, are invalid, expired, or the account is locked

-
  1. Execute the following command from SQL Plus as the SYS user:  Conn sys/Pass@xe as sysdba  (connect as container if 12c then  ALTER SESSION SET container = CDB$ROOT;) Alter user ords_public_user identified by xxxx; ALTER USER ORDS_PUBLIC_USER ACCOUNT UNLOCK; Connect as PDB Conn sys/Pass@xepdb1 as sysdba (if 12c  ALTER SESSION SET container = PDB1;) Alter user APEX_PUBLIC_USER identified by xxxx; Alter user APEX_REST_PUBLIC_USER identified by xxxx; Alter user APEX_LISTENER identified by xxxx; 2. Unlock the users: ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK; ALTER USER APEX_REST_PUBLIC_USER ACCOUNT UNLOCK; ALTER USER APEX_LISTENER ACCOUNT UNLOCK; ALTER USER ORDS_PUBLIC_USER ACCOUNT UNLOCK; 3. Now create a profile for the APEX related users: Create profile apex_public_profile limit password_life_time unlimited; 4. Assign the profile to the APEX users: alter user apex_public_user profile apex_public_profile; alter user apex_rest_public_user profile apex_public_pr...
Read more