Automatically navigation menu expand & collapse

Go to Page 0: Global Page   Create Page Load Dynamic Action: Action: JavaScript Code: $('#t_Body_nav #t_TreeNav').on('click', 'ul li.a-TreeView-node div.a-TreeView-content', function(){    $(this).prev('span.a-TreeView-tog…

Conditionally Status Color

SELECT COLUMN_1, COLUMN_2, case when STATUS=1 then    '<span style="font-size:12px;letter-spacing: .3px;display: inline-block;padding: .4rem .66666667rem;font-size: 89%;     font-weight: 500;     line-height: 1;     text-align: center; …

Column Freeze In Interactive report

I want to freeze the First  two columns and Last two columns in my Interactive Report. My first two columns: 1. Shop Id 2. Shop Name My Last two columns : 1. Status Code 2. Check_column ============================================= Go to Inline CSS:…

Predefine Number wise Data/Row Insert in Interactive Grid (by Ajax Callback)

First Look at the picture. I want to Data/Row Insert Predefine number-wise .  ========================================== Step 1: ==== Create Two Interactive Grid Regions. 1.   Predefine number Region. --- Static ID:  Show_Dept 2.  Predefine number …

Interactive Grid Checkbox And Insert Table to Table by Ajax Callback

Step:1 ==== Create two Interactive Grid Regions. My 1st Region--> Details Collection (For Insert the checkbox value) My 2nd Region-->  SIM Request Of Approved List (For Checkbox Region) Step:2 ==== Function and Global Variable Declaration: // …

Insert-update (Form) by Ajax Callback

Step:1 ===== Go to Ajax Callback Process. Create Process. Name:  INSERT_PAYMENT Type: Execute Code PLSQL Code: DECLARE     V_PK_ID         NUMBER;     V_AUTO_NUMBER   NUMBER;     V_INVOICE_NO   VARCHAR2 (50); BEGIN     IF :P31_ID IS NULL     THEN   …

Interactive Grid Region size And Runtime Toolbar search field

Execute when Page Loads: ================= $(document).ready(function () {     let h = $(window).height() * 78 / 100;     $("#invoicereg_ig").css("height", `${h}px`); // invoicereg -- Static ID }); $(document).ready(function () {…

Database Value Null but using Parameter this null value

User Name: Kamrul Department: NULL Designation: NULL You Must be used a Parameter when condition this--> AND (:P22035_DEPARTMENT  IS NULL OR   DEPT   =:P22035_DEPARTMENT)  AND (:P22035_DESIGNATION IS NULL OR    DESIG =:P22035_DESIGNATION)

Load More
That is All