Below JS DA does not work with LOV column. it throws error NAN. Any idea to get it work with LOV column. var model = apex.region("igitems").widget().interactiveGrid("getViews", "grid").model; var n_amt, n_totamt = 0; col_amt = model.getFieldKey("AMOUNT"); model.forEach(function(igrow) { n_amt = parseInt(igrow[col_amt], 10); if (!isNaN(n_amt)) { n_totamt += n_amt; } }); apex.item("Px_AMOUNT").setValue(n_totamt);
Discy Latest Questions
hi all, working at apex.oracle.com how i can add a Text as Header on IG after [Add Row] button? i want to save screen area. regards problem solved from here (static text): https://www.stinolez.com/2018/10/25/interactive-grids-more-customization/ can i change size and color? if yes, please guide.
How to calculate total debit and total credit in this ig. I am using below code but it is not working as per expectation. var model = apex.region("igitems").widget().interactiveGrid("getViews", "grid").model; var totcreditAmount = 0; var totdebitAmount = 0; model.forEach(function(r) { var actionType = model.getValue(r,"VOU_DRCR").v; if (actionType == 'C'){ var v_cramount = parseFloat(model.getValue(r,"VOU_FNETAMT")); alert(v_cramount); totcreditAmount += v_cramount; } else var v_dramount = parseFloat(model.getValue(r,"VOU_FNETAMT")); alert (v_dramount); totdebitAmount += v_dramount; } ); $s('P320_TOTAL_CREDIT',totcreditAmount); $s('P320_TOTAL_DEBIT',totdebitAmount);
ranuContributor
I have populated my inteacrive grid on page load but the selected records are not on top of the grid. I want to put all the selected records on top and the non-selected after the selected records. Please see the screenshot attached
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
Hello Vinish I am fairly new to Apex Application Development. I have a need to open an interactive grid region from a button another interactive grid. Here is what I am doing: Open a page with Interactive Grid region populated by SQL query in the form of a Pipelined function. Create a Dynamic Action which does following: 2.1 Execute Java Script to select the checked records on the interactive grid. 2.2 Execute Server Side code to define an apex collection using the selected record. Define another interactive grid region to retrieve data from apex collection. Call the interactive grid region in step 3 from step two by adding another dynamic action open region. Unfortunately, this is not working. Please advice if there a way to do it. I want to avoid creating a new page for this. That's why trying to invoke a region from another region button. Please let me know if any clarification needed in the understanding of problem. Thanks Mirza Tanzeel
Hi , How can i make a row clickable in interactive grid. I found an article for this but somehow its not working for me. Please correct my mistake . I did the following to achieve this : I added the following code in my 'Execute when Page Loads' section $('a[href*="12"]').each(function(index) { lnk = $(this).attr('href'); $(this).parent() .parent('tr') .attr('data-href', lnk) .click(function(){ window.location=$(this).attr('data-href'); }) .mouseover(function(){ $(this).css('cursor', 'pointer'); }) .mouseleave(function(){ $(this).css('cursor', 'default'); }) }); The article i read to achieve this is : APEX: Make a report row clickable - AMIS, Data Driven Blog - Oracle & Microsoft Azure Please let me know whats wrong Regards, Ranu
ranuContributor
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
amritProfessional
Hi, I am trying to show a extra value with Text Field as Filed Number, How it can be achieved. for more detail see the below image. See yellow box with numbers. Thanks
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