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
Discy Latest Questions
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
I have found several examples on how to loop through an IG and get the selected rows. I'm looking for a way to get the current selected row? For example, if there are 5 rows and the user selects row number 3, I want to get the value of COL4 or ROW3. How do i do that? Thanks in advance
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 ...
Hi Vinish, Thanks for all your post. Really amazing and easy tutorial for all Apex Developers. Actually i have to create a page with (one form with two editable interactive grids) with one Save button. I just followed your master_detail blog and try to create a page. But while trying to save , getting an PL/SQL numeric value error. Please help me to solve this issue.
Hi, I am working on IG and on update of Start and End Position I am calling a Validation which returns the duplicate exists or not for the same identifier. When I press Save. It gives me error for "Identifier" item "Must have value" (But Identifier do have value) Please refer to the screenshot. Also I felt that if I change any item in IG and immediately press save it does not take into account the new value. Do we have to handle it explicitly? Regards, Richa
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
Hi everyone, When I add row on Interactive Grid, I save report normally. But when I add one new column A ( A get id_user, link to another page) and column B(id_user) , I press save, it not save B. I think because A and B have same value so, the IG don't understand the value A or B. I want to save IG normally includes B column, and A is just area I use to link to another page, don't save A column. Thank you for your time and in advance.
Hi, I have a Sale Invoice page and want to fill IG when user select order number from dropdown and a Dynamic action fill the records into IG from orderItem table. how to achieve this using java script. Just like fill a Oracle Tabular Form from cursor. Thanks