question Re: On Cell edit query in Developer forum

On Cell edit query

Community Alums — Sun, 23 Jul 2023 18:40:21 GMT

Hi All,

From incident list, if the category changes to software and subcategory changes to email then record should not submit.

I have written the On cell edit client script:

Script include:

How to pass newValue of subcategory to script include?

Any help is appreciate!!

Thanks in advance!!

Re: On Cell edit query

Tony Chatfield1 — Mon, 24 Jul 2023 04:33:01 GMT

Hi, what are the results of your debugging\testing? what exactly is\is not working?
Evaluating screenshots is not ideal, perhaps you could share your code as plain text.

Re: On Cell edit query

Community Alums — Mon, 24 Jul 2023 08:03:39 GMT

Thanks Tony!!

what are the results of your debugging\testing? -- In the alert we are getting old value of category

what exactly is\is not working? - if we change category to software in the list and sub category changes to email then record should not submit to server. Script should check is it category is software or not, if yes, then the record should abort.

On cell edit Client script:

Field name: Sub category

Script:

function onCellEdit(sysIDs, table, oldValues, newValue, callback) {
var saveAndClose = true;
//Type appropriate comment here, and begin script below
var ga = new GlideAjax('incidenttTable');
ga.addParam('sysparm_name', 'tablequery');
ga.addParam('sysparm_syssid', sysIDs);
ga.addParam('sysparm_newvalues', newValue);
ga.getXML(myid);

function myid(response) {

var answer = response.responseXML.documentElement.getAttribute("answer");
alert('ramya' + answer);
if (answer == 't1')
if (newValue == 'email')
alert('anns' + answer);
saveAndClose = false;

}
callback(saveAndClose);
}

Script Include:

var incidenttTable = Class.create();

incidenttTable.prototype = Object.extendsObject(AbstractAjaxProcessor, {

tablequery: function() {

var sysid = this.getParameter('sysparm_syssid');

//var managername = '';

var empname = new GlideRecord('incident');

empname.get(sysid);

empname.query();

if (empname.next()) {

gs.addInfoMessage('category' + empname.category);

var state = empname.category;

}

var catgory;

if (state == 'software')

gs.addInfoMessage('category inside' + empname.category);

catgory = 't1';

return catgory;

}

});

Thanks in advance!!

Re: On Cell edit query

Community Alums — Mon, 24 Jul 2023 12:09:31 GMT

Hi @Community Alums ,

You can acheive this without coding.

1. Create Before Insert/Update BR.(It'll work for list editing too)

2. Filter conditions : category is software

Subcategory is Email

3. Under actions Tab: select Add message & Abort action.

Note: Script includes + OncellEdit scripts are not efficeint together , You can user before BR.

Re: On Cell edit query

Riya Verma — Mon, 24 Jul 2023 12:29:43 GMT

Hi @Community Alums ,

Hope you are doing great.

Its not a good practice to use on cell edit client script , for your requirement , you can go ahead with before BR:

the "When to run" section, select "Before" to ensure the rule runs before the record is submitted.
For the "Advanced" condition, use the following script:

(function executeRule(current, previous /*, g*/) { if (current.category.changes() || current.subcategory.changes()) { if (current.category == 'software' && current.subcategory == 'email') { current.setAbortAction(true); gs.addErrorMessage("Record submission is not allowed when the category is 'software' and the subcategory is 'email'."); } } })(current, previous);

Also when you are using getXML call while calling script include via GlideAjax, its a asynchronous call so it will be going into queue. it will not going to wait to get the response from server and decide the abort action. So this is reason why its failing in script. Try using before BR for your requirement to abort submit.

Re: On Cell edit query

Community Alums — Mon, 24 Jul 2023 13:31:32 GMT

Hi Riya,

Thanks!!

My lead want me to do with On cell Edit.

Mistakenly accepted the solution.

Any idea?

Re: On Cell edit query

Community Alums — Mon, 24 Jul 2023 13:32:25 GMT

Hi Khasim,

Thanks!!

My lead want me to do with On cell Edit.

Any idea?

Re: On Cell edit query

Community Alums — Tue, 25 Jul 2023 05:53:56 GMT

Hi @Community Alums ,

Here are the modified Scripts.

-----Script Include-----

----------Client Script----------

Re: On Cell edit query

Community Alums — Tue, 25 Jul 2023 05:57:14 GMT

@Community Alums ,

I've tested and it's working as expected.

Kindly mark it as a solution.

Khasim.

Re: On Cell edit query

Bert_c1 — Tue, 25 Jul 2023 14:16:41 GMT

Hi @Community Alums ,

You have a solution now using onCellEdit from Khasim Pathan. I also tried, my version follows

Script include:

I changed some name values, as starting with your versions didn't work. Also see examples of how to debug the client script and script include (Debug lines have been commented out). And from what I can tell, this only works in List view of incident. As I can still select that combination on the incident form. A business rule solution would prevent both. But you can satisfy your lead with the above or what Khasim posted.

Re: On Cell edit query

Community Alums — Wed, 02 Aug 2023 15:13:47 GMT

Thanks for the script, however we choosed BR over OnCEllEdit client script.