I want to select records on IG on page load through apex.region("S_KRAFTSTOFFE").call("setSelectedRecords",[$v('P17_BEZ_ID')]) wherein the 'P17_BEZ_ID' has value "'Super Plus 98','Super 95','Diesel','Super E10','Ad blue (Gebinde)','Autogas (LPG)'" My problem is because P17_BEZ_ID is a string i cannot directly assign to setSelected records Please see the attachment in short i want to assign a string "'Super Plus 98','Super 95','Diesel','Super E10','Ad blue (Gebinde)','Autogas (LPG)'" to an IG with each element of string as one row of the IG  

Hallo Vinish,   i read your articles on oracle apex topics and i find them very helping.  Its my first question an oracle apex on such platforms please answer me to motivate to ask more questions.   I have an IG and i want to add a radiogroup column in this report. I have the following query   select * from ( select KDID, TO_CHAR(RABKORR,'99G990D99') as RABKORR, TO_CHAR(ADAT, 'DD.MM.RRRR') as ADAT, APEX_ITEM.RADIOGROUP (1,decode(art, 'F',                    'Teilnehmer',                    'T',                     'Station')   )art2, decode(art, 'F',                    'Teilnehmer',                    'T',                     'Station')   AS art,                     TSID, TO_CHAR(QDAT, 'DD.MM.RRRR') as QDAT from TMASOWN.GAZRABKORR where TFSID = :APP_USER  ) the art2 column is what i need to show as a radiogroup column, but i am not able to get desired output. Please correct my approach. Thanks Ranu

Page 1 has list of groups. When selecting a specific group, it opens up modal page to show group members in Page 2 (page item P2_GROUP which contains group name), where I have IG based on sql query that has rowid (no PK in table) and contains cStatus field, where the values are A(ctive) or I(nactive). Row selector can select all records when checked. In IG Attributes, Edit is not enabled. Button "Toggle Status" correctly toggles status, using update statement. Button "Delete Inactive Members" (DELETE_MEMBERs), when clicked, should execute process "Delete Inactive Members", which has server-side condition "When Button Pressed"=DELETE_MEMBERS, Execution Scope: For created and modified rows.  PL/SQL code: Delete from Table1 where cStatus='I' and cGroup=:P2_GROUP In my group, there are 2 members. One has cStatus=I. I select all rows, click on "Delete Inactive Members". 1 of the records is Nothing happens. I then enable Edit, and uncheck "Add Row" and "Update Row", but leave "Delete Row" Checked. Allowed Row Operations Column=Rowid. It didn't make a difference if Allowed Row Operations Column was not set. I get error message: Interactive Grid 'Edit List Members - IG' doesn't have a primary key column defined which is required for editing or in a master detail relationship. What should be done ...

How do I populate non-database fields on a detail form (master-detail) during fetch in Apex?

I have top region with min value and max value. in another region I have interactive grid column name order value. when user put any value must be between min and max value of top region.   How to perform this validation after got focus. thanks and regards