10 Replies Latest reply on Jul 17, 2017 9:08 AM by Ashwin S Rao

    Add the Static id to the region in oracle apex 5.1.2

    Hanu M

      Hi,

       

      Now i'm working on oracle apex 5.1.2.

      facing problem with adding the static id to the region as Below.

       

      After Appearance attribute there is one attribute called "Advanced" is missing in 5.1.2

      In Advanced attribute we are having one parameter called Static ID there we can add static id to the region.

       

       

       

      Thanks,

      Hanu

        • 1. Re: Add the Static id to the region in oracle apex 5.1.2
          Ashwin S Rao

          That's Strange !!

          I am not able to find this issue in Online workspace.

           

          Try moving to legacy component view and add it

           

          Thanks.

          • 2. Re: Add the Static id to the region in oracle apex 5.1.2
            Hanu M

            Thanks for the responce.

             

             

            Recently i have observed it.

            Now can you please crate one new page and share the same at apex.oracle.com.

            Can you please create one classic report with the below code.

            SELECT

            seq_id,

            APEX_ITEM.TEXT( p_idx => 1, p_value => c001, p_attributes =>'class="upd_class" data-seq-id="'

            ||seq_id

            ||'"  data-col-name="name_val_col"    style="width:6vw"', p_item_id => 'f01_'

            || seq_id ) AS emp_id,

            APEX_ITEM.TEXT( p_idx => 1, p_value => c002, p_attributes =>'class="upd_class" data-seq-id="'

            ||seq_id

            ||'"  data-col-name="name_val_col"    style="width:6vw"', p_item_id => 'f02_'

            || seq_id ) AS Ename,

            APEX_ITEM.TEXT( p_idx => 1, p_value => c003, p_attributes =>'class="upd_class" data-seq-id="'

            ||seq_id

            ||'"  data-col-name="name_val_col"    style="width:6vw"', p_item_id => 'f03_'

            || seq_id ) AS Job,

            APEX_ITEM.TEXT( p_idx => 1, p_value => c004, p_attributes =>'class="upd_class" data-seq-id="'

            ||seq_id

            ||'"  data-col-name="name_val_col"    style="width:6vw"', p_item_id => 'f04_'

            || seq_id ) AS Manager,

            APEX_ITEM.TEXT( p_idx => 1, p_value => c005, p_attributes =>'class="upd_class" data-seq-id="'

            ||seq_id

            ||'"  data-col-name="name_val_col"    style="width:6vw"', p_item_id => 'f05_'

            || seq_id ) AS Dept

            FROM apex_collections

            WHERE collection_name='EMP_INFO'

             

            -----------

             

            Before header add the below process

             

            BEGIN

            IF NOT apex_collection.collection_exists('EMP_INFO') THEN

              apex_collection.create_collection('EMP_INFO');

            ELSE

              apex_collection.truncate_collection('EMP_INFO');

            END IF;

            FOR x IN

            (SELECT empno,

                     ename,

                     job,

                     mgr,

                     deptno

              FROM emp

              ORDER BY 1 ASC

            )

            LOOP

              apex_collection.add_member(p_collection_name => 'EMP_INFO',

                                         p_c001 => x.empno,

                                         p_c002 => x.ename,

                                         p_c003 => x.job,

                                         p_c004=>x.mgr,

                                         p_c005=>x.deptno,

                                         p_c020 => 'O' );

            END LOOP;

            END;

             

             

            Thanks,

            Hanu   

            • 3. Re: Add the Static id to the region in oracle apex 5.1.2
              fac586

              Hanu M wrote:

               

              Now i'm working on oracle apex 5.1.2.

              facing problem with adding the static id to the region as Below.

               

              After Appearance attribute there is one attribute called "Advanced" is missing in 5.1.2

              In Advanced attribute we are having one parameter called Static ID there we can add static id to the region.

              Looks like Show All is not selected in the property sheet options...

              • 4. Re: Add the Static id to the region in oracle apex 5.1.2
                Ashwin S Rao

                How is it going to hide static ID section by adding the above code?

                • 5. Re: Add the Static id to the region in oracle apex 5.1.2
                  Hanu M

                  Thanks Ashwin,

                   

                  Ashwin S Rao wrote:

                   

                  How is it going to hide static ID section by adding the above code?

                  Not for the above code.

                   

                  Can you please try to create one page and one region from you end then you will come to know.

                  At page level :

                  Functions & Global declaration and executes when page load section are also missing in the 5.1.2 release.

                   

                   

                  Thanks,

                  Hanu

                  • 6. Re: Add the Static id to the region in oracle apex 5.1.2
                    d3bruts1d

                    As fac586 already stated, you have the "Show Common" selected in the property options. Click show all.

                     

                    apexproperty..png

                    • 7. Re: Add the Static id to the region in oracle apex 5.1.2
                      Hanu M

                      Thank you Ashwin for your support.

                      Now column properties are showing.

                       

                      Ashwin i have query related to success messages.

                       

                      Process :

                      1 Grid data save - Grid data saved(Success message).

                      2. Data saving - Data saved(Success message).

                       

                      1 Grid data save - Grid data saved(Success message) : it will showing when click on save in the grid.

                       

                      1 Grid data save - Grid data saved(Success message), 2. Data saving - Data saved(Success message) - These two are displaying when click on page submit button.

                      how to separate grid message from page submit button.

                       

                      If you have any inputs then please let me know.

                       

                       

                      Thanks,

                      Hanu

                      • 8. Re: Add the Static id to the region in oracle apex 5.1.2
                        Ashwin S Rao

                        Hey Hanu,

                        Could you please elaborate ?

                         

                        When you say grid , did you mean interactive grid? what do you mean by Data saving?

                         

                        If its IR grid I believe there is section for success message in IR grid process itself.

                         

                        Thanks.

                        • 9. Re: Add the Static id to the region in oracle apex 5.1.2
                          Hanu M

                          Thank you aswin for your response.

                           

                          Below is the scenario.

                           

                          Appreciate if you provide any inputs on this.

                           

                           

                          Thanks,

                          Hanu

                          • 10. Re: Add the Static id to the region in oracle apex 5.1.2
                            Ashwin S Rao

                            Hi Hanu,

                            Looks like you want to have custom button instead of IR grid save button to save grid changes.

                             

                            You can have a dynamic action on click of save button (Page level button) and use the code below.

                             

                            apex.region("emp").widget().interactiveGrid("getActions").invoke("save");

                             

                            Here "emp" is the static id of your current grid region.

                             

                            Please refer this How to hack APEX Interactive Grid Part 3 – HardLikeSoftware

                             

                            Thanks.