I have a SQL Query inside button that will return multiple data. The Interactive Grid also got it own SQL Query. How do I populate/add these data into an Interactive Grid that already have data without replacing existing data in the Interactive Grid?.
Discy Latest Questions
Hi I need to update the forecast date for below rows. based on forecast date change in previous rows. for example : in second row forecast date is : 23 -March-2022 , if i change this date to 24-March-2022 , then below rows forecast date should change according to 1 day extra. Thanks.
I have employee master table and using submaster for department and positions. I want to create an Interactive grid on Employee Master Table , but need to get data from Department and Positions tables based on the department code and position code in employee master table. Actually, I do not want to update multiple tables in the grid. I want to update only 1 Table Employee Master but just want to display data from other tables too using Employee Number to retrieve data from other table. I believe, it must be very simple, but I do not know how to do it. My requirement is just simple as below: Employee Master Table Employee_No Employee_Name Employee_Hire_Date Employee_NO Employee_Name Employee_Hire_Date 1001 ABC 01-JAN-2022 1002 DEFGHHFJ 20-JAN-2022 1003 XYZJHJSJ 25-JAN-2022 Employee Status Table Employee_No Employee_Status Employee_Status_Date Employee_NO Employee_Status Employee_Status_Date 1001 A ...
kilineContributor
Hi, so i have a problem when i try to get value out of interactive grid i get [object Object] in text field. I found out the reason for that output is because i was trying to get value out of select list column. When i try with any other column type textfield or numberfield it works great and return value correctly. That's the javascript code I am using for retrieving value. if(this.data != null){ if(this.data.selectedRecords[0]!= null){ selectedRecord = this.data.selectedRecords[0][4]; apex.item( "P34_TEST" ).setValue(selectedRecord); } } Thank you for any help!
hi Vinish created a page, region is IG using EMP table, below code is working fine to calculate sum of SAL column. what if i have to aggregate multiple columns like SAL & COMM both. how i can do it? note: have copied below code from another app as i dont know JS (function($) { function update(model) { var total_amt = model.getFieldKey("SAL") , totalAmt = 0; model.forEach(function(record, index, id) { var totalamt = parseFloat(record[total_amt]), meta = model.getRecordMetadata(id); if (!isNaN(totalamt) && !meta.deleted && !meta.agg) { totalAmt += totalamt; } }); $s("P10_TOTAL", totalAmt); } $(function() { $("#emp").on("interactivegridviewmodelcreate", function(event, ui) { var sid, model = ui.model; if ( ui.viewId === "grid" ) { sid = model.subscribe( { onChange: function(type, change) { console.log(">> model changed ", type, change); if ( type === "set" ) { // dont bother to recalculate if other columns change if (change.field === "SAL" ) { update( model ); } } else if (type !== "move" && type !== "metaChange") { update( model ); } }, } ); update( model ); model.fetchAll(function() {}); } }); }); })(apex.jQuery); regards
Hello everyone, My question is, can I achieve Automatic Row Processing (DML) without the need to call the save action of an Interactive Grid? For example, every time a cell loses focus, the data collection get updated. I'm using apex collections as a data source for this IG. I tried to run some PL/SQL code on the lose focus event of some column, but when I checked the APEX$ROW_STATUS it was null (undefined). Appreciate your help so much.
Hi, I am trying to create a performance measurement capture form, so that various managers can capture their teams' monthly performance. To do so, I have created three tables (2 inputs (to populate pre-defined fields), and 1 that should store the form (output values). The inputs tables are something like: Table Name Department Column Department_Name (PK) Sales Procurement Logistics and KPI's Department_Name (FK) Team_Region Measurement Target Sales JHB New Sales 100000 Sales JHB Invoicing 100% Sales CT New Sales 90000 Sales DBN New Sales 80000 Procurement JHB Maintain stock levels 95% Procurement CT Maintain stock levels 85% Procurement DBN Maintain stock levels 70% Logistics JHB Order Delivery Within 2 days Logistics CT Order Delivery Within 2 days Logistics DBN Order Delivery Within 3 days With the output table being a combination of all the input (as well as additional values) Results Month Department_Name Team_Region Measurement Target Results Achieved Reason To store the output values, I have created a form based on the "Results" table, but I hid the fields that also exist in the "KPI's" table. I then created an Interactive Grid region to pre-populate the values from the KPI's table and created additional columns to capture the results per KPI and calculate if Achieved (in essence have all the values needed on the "Results" (my output) table, also in the interactive grid). Q1 - How to I set the values in the interactive grid to save to the Results (output) table. Q2 - As this is an interactive grid, if you select multiple Rows in the IG, it should create multiple Rows in the Results table for ...
before saving Pay To Account show correctly list which shows OOCL, after saving immediately Pay To Account show ID "95" instead of text. Noted "Pay To Account" IG Column load dynamically list depend on "PayToType" selection with the help of function Returning SQL Query. Please Guide me to resolve this issue.
hi Vinish, we have an assignment to manually populate editable IG with data from another table when user press a button to fill rows. how i can do it? IG is based on a table and a where clause is used but initially when appear the grid is empty, user will press a button and through a process / procedure / fuction / dynamic action this IG should be populated. please help for this how it can be achieved. regards
i am using Apex 21.2 in my IG i had a DA on a Column, want to save current row before going to further actions, so i need to update current row first through DA, how i can achieve it? please help. i searched " oracle apex save ig row using javascript " in google but various search results are not what i am looking for. regards