H5 Script - Unable to process the entry in subfile

Hi,

I've written a script to set data in an editable column(CAMU) in a subfile for the program MWS445 and it works well. But when I try to use the related option the screen refreshes and the value is populated again so M3 is unable to recognize the value set by the script.

If I just click on the editable column "CAMU" press enter and try the related option it works. So I added a keypress event after setting the value in CAMU, but it doesn't work. Please let me know if anyone has an idea on how to handle this.

code:
-----
var camuData = {};
camuData[columnCAMU] = this.CAMU;
camuData["id_" + columnCAMU] = "R" + (i + 1) + columnCAMU;

if (ScriptUtil.version >= 2.0) {
const dataset = list.getData();
const data = dataset[i];
data[columnCAMU] = this.CAMU;
list.setData(dataset);
} else {
$.extend(list.getData().getItem(i), camuData);
var columns = list.getColumns();
list.setColumns(columns);
}
this.controller.PressKey("ENTER");

Find more posts tagged with

Accepted answers

Legacy Contributor

Hi @sudhakaran-samadurai ,

try this:

var camuData = {};
camuData[columnCAMU] = this.CAMU;
var cellId = "R" + (i + 1) + columnCAMU;
var cellValue = "R" + (i + 1) + columnCAMU;;
camuData["id_" + columnCAMU] = cellValue;
this.controller.editedCells[cellId] = camuData["id_" + columnCAMU];

Legacy Contributor

Hi Henry,

Thank you this worked, there was a correction needed in the above code, I did the below change and it fixed the issue also I removed the keypress event.

Existing code
this.controller.editedCells[cellId] = camuData["id_" + columnCAMU];

Modified code
this.controller.editedCells[cellId] = camuData[columnCAMU];

All comments

Legacy Contributor

Hi @sudhakaran-samadurai ,

try this:

Legacy Contributor

Thank you,

This is not working, setting the editedCells creates issues it triggers the related option for all the lines in the subfile.

Legacy Contributor

Perhaps you should paste here the whole script so that I can analyze it or you can analyze it by yourself by considering how it works -

editedCells is a flag container that informs the server that those cell id's in it must be updated. Without that flag, the server will not know which cell should be updated.

Based from the code, it will issue ENTER event in every iteration of the loop. Perhaps you should remove this.controller.PressKey("ENTER")?

Regards,

-Henry

Legacy Contributor

Hi Henry,

Please find the typescript code below.

class MWS445B_SetDefaultContainer {

private controller: IInstanceController;

private log: IScriptLog;

private args: string;

private contentElement: IContentElement;

private mode: string;

private CAMU: string;

private WHLO: string;

private WWQTTP: string;

private colITNO: number;

private colCAMU: number;

private map;

private unsubscribeReqCompleted;

constructor(scriptArgs: IScriptArgs) {

this.controller = scriptArgs.controller;

this.log = scriptArgs.log;

this.args = scriptArgs.args;

}

public static Init(args: IScriptArgs): void {

new MWS445B_SetDefaultContainer(args).run();

}

private run(): void {

this.contentElement = this.controller.GetContentElement();

this.mode = this.controller.GetMode();

const userContext = ScriptUtil.GetUserContext();

if(this.args.length > 0) {

this.CAMU = this.args;

console.log(this.args);

}

this.WHLO = ScriptUtil.GetFieldValue('OQWHLO');

this.colITNO = ListControl.GetColumnIndexByName("ITNO") + 1;

this.colCAMU = ListControl.GetColumnIndexByName("CAMU") + 1;

this.WWQTTP = ScriptUtil.GetFieldValue('WWQTTP');

var list = this.controller.GetGrid();

this.map = new Map();

this.populateContainer(list);

this.attachEvents(this.controller, list);

}

async populateContainer(list: IActiveGrid): Promise<void> {

var columnCAMU = 'C' + this.colCAMU;

var listLength = 0;

if (ScriptUtil.version >= 2.0) {

listLength = list.getData().length;

columnCAMU = "WSCAMU";

} else {

listLength = list.getData().getLength();

}

for (let i = 0; i < listLength; i++) {

var ITNO;

var CAMUValue;

if (ScriptUtil.version >= 2.0) {

if (this.WWQTTP.trim() === '1') {

ITNO = list.getData()[i].S1ITNO;

} else if (this.WWQTTP.trim() === '2') {

ITNO = list.getData()[i].S2ITNO;

}

CAMUValue = list.getData()[i].WSCAMU;

} else {

ITNO = list.getData().getItem(i)['C' + this.colITNO];

CAMUValue = list.getData().getItem(i)['C' + this.colCAMU];

}

if(!this.map.has(ITNO)) {

await this.executeGetItmWhsBasic(ITNO, columnCAMU, list, i);

} else {

// the item is already processed for mi set the container value

if(this.map.get(ITNO) === "1") {

// var camuData = {};

// camuData[columnCAMU] = this.CAMU;

// camuData["id_" + columnCAMU] = "R" + (i + 1) + columnCAMU;

// if (ScriptUtil.version >= 2.0) {

// const dataset = list.getData();

// const data = dataset[i];

// data[columnCAMU] = this.CAMU;

// list.setData(dataset);

// } else {

// $.extend(list.getData().getItem(i), camuData);

// var columns = list.getColumns();

// list.setColumns(columns);

// }

// this.controller.PressKey("ENTER");

var camuData = {};

camuData[columnCAMU] = this.CAMU;

var cellId = "R" + (i + 1) + columnCAMU;

var cellValue = "R" + (i + 1) + columnCAMU;;

camuData["id_" + columnCAMU] = cellValue;

this.controller.editedCells[cellId] = camuData["id_" + columnCAMU];

if (ScriptUtil.version >= 2.0) {

const dataset = list.getData();

const data = dataset[i];

data[columnCAMU] = this.CAMU;

list.setData(dataset);

} else {

$.extend(list.getData().getItem(i), camuData);

var columns = list.getColumns();

list.setColumns(columns);

}

this.controller.PressKey("ENTER");

}

private executeGetItmWhsBasic(ITNO: string, columnCAMU: string, list:any, i:number) {

return new Promise((resolve, reject) => {

var requestGetItmWhs = new MIRequest();

requestGetItmWhs.program = "MMS200MI";

requestGetItmWhs.transaction = "GetItmWhsBasic";

requestGetItmWhs.record = { WHLO: this.WHLO, ITNO: ITNO };

requestGetItmWhs.maxReturnedRecords = 0;

MIService.Current.executeRequest(requestGetItmWhs).then((response: IMIResponse) => {

this.map.set(ITNO, response.item.COMG);

if(response.item.COMG == "1") {

var camuData = {};

camuData[columnCAMU] = this.CAMU;

camuData["id_" + columnCAMU] = "R" + (i + 1) + columnCAMU;

if (ScriptUtil.version >= 2.0) {

const dataset = list.getData();

const data = dataset[i];

data[columnCAMU] = this.CAMU;

list.setData(dataset);

} else {

$.extend(list.getData().getItem(i), camuData);

var columns = list.getColumns();

list.setColumns(columns);

}

this.controller.PressKey("ENTER");

}

resolve(response);

}).catch((response:IMIResponse) => {

this.log.Error(response.errorMessage);

resolve(response);

});

}

private attachEvents(controller: IInstanceController, list: IActiveGrid) {

this.unsubscribeReqCompleted = controller.RequestCompleted.On((e) => {

//Populate additional data on scroll

if (e.commandType === "PAGE" && e.commandValue === "DOWN") {

this.populateContainer(list);

} else {

this.detachEvents();

}

});

}

private detachEvents() {

this.unsubscribeReqCompleted();

}

Legacy Contributor

Hi Henry,

Thank you this worked, there was a correction needed in the above code, I did the below change and it fixed the issue also I removed the keypress event.

Existing code
this.controller.editedCells[cellId] = camuData["id_" + columnCAMU];

Modified code
this.controller.editedCells[cellId] = camuData[columnCAMU];

Copyright © 2025 Infor. All rights reserved.