Skip to main content

Oracle Apex Interactive grid - Issue setting column value with JavaSript

I got an Interactive grid with a Switch column ('Yes'/'No'). I have a requirement that only one record in the grid should have a Switch column value equals to ‘Yes’ ('Y').

If user enters a new row, and there is already a row in the grid with Switch column equals to “Y”, then the new row's value of the Switch column should be set to ‘No’ ('N').

I am looping through the Interactive grid to get values of the Switch column, to determine if any value equals to ‘Y". I've got the following function, which suppose to return true if 'Y' is found:

function mainInd (gridId, colName) {
//Get the Interactive grid widget instance
  var ig$   = apex.region(gridId).widget();
  var model = ig$.interactiveGrid("getCurrentView").model;
  var colValue;
 //Loop through the records in the interactive grid
   ig$.interactiveGrid("getViews", "grid").model.forEach(function(record) {
     console.log('***************mainInd() - record: ' + record );
   colValue = model.getValue(record,colName).v;
     console.log('***************mainInd() - colValue: ' + colValue );
   return Boolean(colValue === 'Y');
   //return colValue === 'Y'; //did not work either
 });
}

However the function does not return the boolean.

I am using this function in a Row Initialization DA of the Interactive grid:

var model = this.data.model,
    rec   = this.data.record,
    meta  = model.getRecordMetadata(this.data.recordId);
 if ( meta.inserted )
 {
  if ( mainInd("BP","MAIN_BUYER_IND") ){
      console.log('**************Row Init DA - expected true: ' + mainInd("BP","MAIN_BUYER_IND") );
     model.setValue(rec,"MAIN_BUYER_IND", {d:"No", v:"N"});
    } else {
      console.log('**************Row Init DA - expected false: ' + mainInd("BP","MAIN_BUYER_IND") );
     model.setValue(rec,"MAIN_BUYER_IND", {d:"Yes", v:"Y"});
   }
}

I am not getting proper true or false boolean. All I'm getting in the console is ‘undefined’. And therefore the logic does not work as expected. I also tried:

 function mainInd (gridId, colName) {
 //Get the interactive grid widget instance
   var ig$   = apex.region(gridId).widget();
   var model = ig$.interactiveGrid("getCurrentView").model;
   var colValue;
  //Loop through the records in the interactive grid
    ig$.interactiveGrid("getViews", "grid").model.forEach(function(record) {
      console.log('***************mainInd() - record: ' + record );
    colValue = model.getValue(record,colName).v;
    if (colValue === 'Y') {
      console.log('***************mainInd() - colValue: ' + colValue );
      return true;
    }
   return false;
  });
}

It did not work either.

Can you please check the code and let me know what is the issue with it?

Here is the demo if you want to see the console: https://apex.oracle.com/pls/apex/f?p=108817:23:112338007040585::::P23_CUSTOMER_ID:1

User: guest Passw: demo2023

Thank you.

Via Active questions tagged javascript - Stack Overflow https://ift.tt/qh68n5x

Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

ValueError: X has 10 features, but LinearRegression is expecting 1 features as input

So, I am trying to predict the model but its throwing error like it has 10 features but it expacts only 1. So I am confused can anyone help me with it? more importantly its not working for me when my friend runs it. It works perfectly fine dose anyone know the reason about it? cv = KFold(n_splits = 10) all_loss = [] for i in range(9): # 1st for loop over polynomial orders poly_order = i X_train = make_polynomial(x, poly_order) loss_at_order = [] # initiate a set to collect loss for CV for train_index, test_index in cv.split(X_train): print('TRAIN:', train_index, 'TEST:', test_index) X_train_cv, X_test_cv = X_train[train_index], X_test[test_index] t_train_cv, t_test_cv = t[train_index], t[test_index] reg.fit(X_train_cv, t_train_cv) loss_at_order.append(np.mean((t_test_cv - reg.predict(X_test_cv))**2)) # collect loss at fold all_loss.append(np.mean(loss_at_order)) # collect loss at order plt.plot(np.log(al...
Post a Comment
Read more

Sorting large arrays of big numeric stings

I was solving bigSorting() problem from hackerrank: Consider an array of numeric strings where each string is a positive number with anywhere from to digits. Sort the array's elements in non-decreasing, or ascending order of their integer values and return the sorted array. I know it works as follows: def bigSorting(unsorted): return sorted(unsorted, key=int) But I didnt guess this approach earlier. Initially I tried below: def bigSorting(unsorted): int_unsorted = [int(i) for i in unsorted] int_sorted = sorted(int_unsorted) return [str(i) for i in int_sorted] However, for some of the test cases, it was showing time limit exceeded. Why is it so? PS: I dont know exactly what those test cases were as hacker rank does not reveal all test cases. source https://stackoverflow.com/questions/73007397/sorting-large-arrays-of-big-numeric-stings
Post a Comment
Read more

How to load Javascript with imported modules?

I am trying to import modules from tensorflowjs, and below is my code. test.html <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Document</title </head> <body> <script src="https://cdn.jsdelivr.net/npm/@tensorflow/tfjs@2.0.0/dist/tf.min.js"></script> <script type="module" src="./test.js"></script> </body> </html> test.js import * as tf from "./node_modules/@tensorflow/tfjs"; import {loadGraphModel} from "./node_modules/@tensorflow/tfjs-converter"; const MODEL_URL = './model.json'; const model = await loadGraphModel(MODEL_URL); const cat = document.getElementById('cat'); model.execute(tf.browser.fromPixels(cat)); Besides, I run the server using python -m http.server in my command prompt(Windows 10), and this is the error prompt in the console log of my browser: Failed to loa...
Post a Comment
Read more