Oracle Apex: Interactive Grid Get Selected Rows Example

For the current selected employee, you have to click on the grid not on the checkbox or set multi-select property off for the grid.

For multi-select, it will populate the P9_EMPIDS correctly.

You can do it. Follow this example:

Create a hidden item for example, P3_SIDS and set the default value as the SQL query and add the following SQL query in it:

select '[' || LISTAGG('"' || COLUMN_VALUE || '"' ,',') WITHIN GROUP (ORDER BY 1) || ']' as c from (
Select yourSIDScolumn a from yourtable where PKID = :P3_PKID), TABLE(APEX_STRING.split(a,':'))

Now create a DA on Page Load to Execute JavaScript code and add the following JS code in it:

var objt= JSON.parse($v("P3_SIDS"));
var ig$ = apex.region("YourIGStaticID").widget();
ig$.interactiveGrid("setSelectedRecords",objt);

This is the tested code, works correctly.

To add the selected row to a collection follow these steps:

Click on the process tab and create an Ajax callback process something like below:

Declare
  n_empno Number;
Begin
  If Not apex_collection.collection_exists('EMP_COLLECTION') Then
    apex_collection.create_collection('EMP_COLLECTION');
  End If;

  Select
    Count(1)
  Into n_empno
  From
    apex_collections
  Where
    collection_name = 'EMP_COLLECTION'
    And c001 = :p25_empno;

  If n_empno = 0 Then
    apex_collection.add_member(p_collection_name => 'EMP_COLLECTION', 
    p_c001 => :p25_empno, 
    p_c002 => :p25_ename, 
    p_c003 => :p25_esal);
  End If;

End;

Also, create 3 hidden items, P25_EMPNO, P25_ENAME, P25_SAL used in the above code.

You can give the process name as populate_collection.

Now change the on selection change dynamic action code as below:

var i, i_empids = ":", i_empid, i_ename, i_sal,

model = this.data.model;

for ( i = 0; i < this.data.selectedRecords.length; i++ ) {
   
  i_empid = model.getValue( this.data.selectedRecords[i], "EMPNO");
  i_ename = model.getValue( this.data.selectedRecords[i], "ENAME");
  i_sal = model.getValue( this.data.selectedRecords[i], "SAL");

  apex.item( "P25_EMPNO" ).setValue (i_empid);
  apex.item( "P25_ENAME" ).setValue (i_ename);
  apex.item( "P25_ESAL" ).setValue (i_sal);
   
  apex.server.process('populate_collection',
{
  pageItems : '#P25_EMPNO,#P25_ENAME,#P25_ESAL'
}
,
{
  dataType : 'text', success : function(data)
  {
   if(data != 'SUCCESS') ;
  }
}
);
   
  i_empids += model.getValue( this.data.selectedRecords[i], "EMPNO") + ":";
   
}

apex.item( "P25_EMPID" ).setValue (i_empids);

The above JavaScript code will call the ajax callback process populate_collection and it will populate the collection EMP_COLLECTION.

To test you can create an interactive report on the same page with the following SQL query:

select 
  c001,
  c002,
  c003
 from apex_collections
 where collection_name = 'EMP_COLLECTION'

This is just a quick example, you can enhance it more.

If you have the pagination type scroll, it will work fine. But if you using pagination as page type, then create a dynamic action on page change event of the IG and copy the existing ids to another hidden item.

Create one more hidden item, for example, P9_EMPIDS_1

DA to execute JavaScript on page change event:

apex.item("P9_EMPIDS_1").setValue(apex.item("P9_EMPIDS").getValue());

I didnt find the solution to disable it right now, but you can select only if the invoice type owed. For example, in the following code, it will select only employees if invoice type is equal to OWED:

var i, i_empids = ":", i_empid, inv_type,

model = this.data.model;

for ( i = 0; i < this.data.selectedRecords.length; i++ ) {
   
  inv_type = model.getValue( this.data.selectedRecords[i], "INV_TYPE");

  if (inv_type == "OWED") {
    i_empids += model.getValue( this.data.selectedRecords[i], "EMPLOYEE_ID") + ":";
  }
}

apex.item( "P9_EMPIDS" ).setValue (i_empids);

Now if even the user will select the paid invoice, but it will not select the employee here.

You mean, you want to focus on record recently added?

You need to truncate the collection before loop. Below is an example:

var i, i_empids = ":", i_empid,

model = this.data.model;

// below line will clear the item and will take the effect on select/deselect.
// you can clear your collection at this point.
apex.item( "P9_EMPIDS" ).setValue ('');

for ( i = 0; i < this.data.selectedRecords.length; i++ ) {
    
    i_empid = model.getValue( this.data.selectedRecords[i], "EMPLOYEE_ID");
    
    i_empids += model.getValue( this.data.selectedRecords[i], "EMPLOYEE_ID") + ":";
    
}

apex.item( "P9_EMPIDS" ).setValue (i_empids);
apex.item( "P9_CURRENT_EMPID" ).setValue (i_empid);