Need to set column value using client script

Hi ​@preethi.a05 ,

Have you tired setting the value using a client script sql in your client script?

Best Regards,

Morris

Hi ​@Morris ,

But I tried using setDBValue.

Hi ​@preethi.a05 ,

I believe that setDBValue is only for mobile. but what I am suggesting to try is use getDBValues and instead of finding a value to return, try to use an update table set xyz = ‘zyx’ where abc =’{0}’

Something like that. I know it been attempted but I don’t recall the end results. but it would be worth a try. I know you are not trying to return anything, but this might be enough to work. btw are you trying to do this in the smart client or web client. 

Or another option is to put the field on the UI but make it hidden, then you should be able to update using the setControlValue option. In fact that would likely be the less cumbersome route

Morris

What Morris said - i.e. Adding the field as a hidden field (button at the top of the UI designer)...you don’t need to place it into the design, just add it as a hidden field.  Then the setControlValue will work.

Hi ​@preethi.a05 

Depends on your use case. 

You can apply the suggested solution above or change the update functionality to a business rule.

Cheers!

Hi All,

Thanks for the above suggestions, currently I have used object literal to update the column value as mentioned below, and it was working.
columnVals = {};
columnVals.task_id = task_id;
columnVals.xyz = 'zyx';
updateRow('task', columnVals);!--scriptorendfragment-->!--scriptorstartfragment-->

Hi, 

In addition I need to update the same field value which is visible in mobile UI

and below I have made the changes in client script, but Still I don’t see any updates happened. After making changes in client script, did re-init and refresh scripts in mobile. but still the changes are not getting synced up in mobile. How to fix this?

Hi ​@preethi.a05 

Are you using saveDataTransaction after you addToDataTransaction?

Cheers!

Tried using saveDataTransaction, but still it is not working if the field value is updated to declined.
 

Hi ​@preethi.a05 

Not sure if you have a typo there, but should it be assit_status_parent OR assist_status_parent?

Also, try removing the ‘else’ from the else if. Use only if(unskilled == ‘N’)

If the above is not relevant, I must be missing something here.

Can you please rephrase your question and provide the full workflow?

Cheers!

Hi ​@Shneor Cheshin ,

The field name is assit_status_parent. I’m explaining the scenario below:

If I have a task created with task_id = 1276 and dispatched to tech, and in between If the tech require additional technician then he/she should submit a request from mobile “assist request”, and we can create it in 2 types which is “skilled” and “unskilled”, If he submit an assist request with skilled tech from mobile, it will create an alias task with task_id = 1277, and from that task we should click on accept in web client which will be updated in “acceptreject” field, based on that value it should update the assit_status_parent in original task(1276) in mobile(only if the task is accepted in webclient it should show as approved else it should show as pending), and if he submit a request for “unskilled”, it will again create an alias task with task_id = 1278, and from that task we should click on reject and this will parallely update “acceptreject” field, based on this it should update the assit_status_parent as declined in mobile. Currenly I’m facing issue with the below script, how to fix this to show the simultaneous updates

 

var rowId = getDBValue(stringFormat("select metrix_row_id from task where task_id = {0}", taskId));
    var taskTrans = generateDataTransaction("task", "UPDATE", stringFormat("metrix_row_id = {0}", rowId));
    taskTrans = addToDataTransaction(taskTrans, "metrix_row_id", rowId);
    var childTaskId = getControlValue("task", "task_id");
    if (unskilled == 'Y') {
        // alert("unskilledtask");
        var acceptReject = getDBValue(stringFormat("select ct.acceptreject from task t inner join c_task_ext ct on ct.task_id = t.task_id where t.task_id = {0}", childTaskId))
		if(acceptReject == 'ACCEPT')
		{
        	taskTrans = addToDataTransaction(taskTrans, "task_id", taskId);
        	taskTrans = addToDataTransaction(taskTrans, "skilled_unskilled_assist", "SKILLED");
        	taskTrans = addToDataTransaction(taskTrans, "unskilledassist", unskilled);
        	taskTrans = addToDataTransaction(taskTrans, "assit_status_parent", "Approved");    
        	taskTrans = addToDataTransaction(taskTrans, "assist_comments",commentsfield );
		}
		else if (acceptReject = 'REJECT')
		{
			taskTrans = addToDataTransaction(taskTrans, "task_id", taskId);
        	taskTrans = addToDataTransaction(taskTrans, "skilled_unskilled_assist", "SKILLED");
        	taskTrans = addToDataTransaction(taskTrans, "unskilledassist", unskilled);
        	taskTrans = addToDataTransaction(taskTrans, "assit_status_parent", "Declined");    
        	taskTrans = addToDataTransaction(taskTrans, "assist_comments",commentsfield );	
		}
		else
		{
			taskTrans = addToDataTransaction(taskTrans, "task_id", taskId);
			taskTrans = addToDataTransaction(taskTrans, "skilled_unskilled_assist", "SKILLED");
			taskTrans = addToDataTransaction(taskTrans, "unskilledassist", unskilled);
			taskTrans = addToDataTransaction(taskTrans, "assist_comments",commentsfield );
			taskTrans = addToDataTransaction(taskTrans, "assit_status_parent", "Pending");
		}

    }
    else {
        taskTrans = addToDataTransaction(taskTrans, "task_id", taskId);
        taskTrans = addToDataTransaction(taskTrans, "skilled_unskilled_assist", "UNSKILLED");
        taskTrans = addToDataTransaction(taskTrans, "unskilledassist", unskilled);
        taskTrans = addToDataTransaction(taskTrans, "assit_status_parent", "Pending");
        taskTrans = addToDataTransaction(taskTrans, "assist_comments",commentsfield );       
    }

Hi ​@preethi.a05 

Again, this is not the full script. According to what I see

1. If c_task_ext is defined as an extension table, you don't need to join

   var acceptReject = getDBValue(stringFormat("select acceptreject from task t where t.task_id = '{0}'", childTaskId))

2. You are missing single quotes around the parameter. Should be ‘{0}’. Sometimes it will work, but it is better to add than miss.
3. I don't see saveDataTransaction, which is essential to update the record

Cheers!

Hi ​@Shneor Cheshin ,

Currently pasting the whole client script below, After accepting or rejecting from web client, the assit_parent_parent in original task is still showing as pending in mobile. 
 

var commentsfield = getControlValue('task', 'description');
var taskId = getCurrentKeys("task", "task_id");
var unskilled = getControlValue("task", "unskilledassist");
//var acceptReject = getControlValue("task","acceptReject");

if (isNullOrEmptyString(commentsfield)) {
    alert(getMessage('c_alerts_assist', 'MM_RESOURCE_STRING'));
}
else {
	//alert(getMessage('c_alerts_assist', 'MM_RESOURCE_STRING'));
	//log("assist request start");
    var rowId = getDBValue(stringFormat("select metrix_row_id from task where task_id = {0}", taskId));
    var taskTrans = generateDataTransaction("task", "UPDATE", stringFormat("metrix_row_id = {0}", rowId));
    taskTrans = addToDataTransaction(taskTrans, "metrix_row_id", rowId);
    var childTaskId = getControlValue("task", "task_id");
	//alert(getMessage('c_alerts_for_assist', 'MM_RESOURCE_STRING'));
    if (unskilled == 'Y') {
        // alert("unskilledtask");
        log("assist if block start");
		var acceptReject = getDBValue(stringFormat("select acceptReject from c_task_ext where task_id = '{0}'", childTaskId));
		log("check acceptReject");		
        if(acceptReject == 'ACCEPT')
		{
        	taskTrans = addToDataTransaction(taskTrans, "task_id", taskId);
        	taskTrans = addToDataTransaction(taskTrans, "skilled_unskilled_assist", "SKILLED");
        	taskTrans = addToDataTransaction(taskTrans, "unskilledassist", unskilled);
        	taskTrans = addToDataTransaction(taskTrans, "assit_status_parent", "Approved");    
        	taskTrans = addToDataTransaction(taskTrans, "assist_comments",commentsfield );
        	saveDataTransaction(taskTrans, "Assist Request");
		}
		else if (acceptReject == 'REJECT')
		{
			taskTrans = addToDataTransaction(taskTrans, "task_id", taskId);
        	taskTrans = addToDataTransaction(taskTrans, "skilled_unskilled_assist", "SKILLED");
        	taskTrans = addToDataTransaction(taskTrans, "unskilledassist", unskilled);
        	taskTrans = addToDataTransaction(taskTrans, "assit_status_parent", "Declined");    
        	taskTrans = addToDataTransaction(taskTrans, "assist_comments",commentsfield );
			saveDataTransaction(taskTrans, "Assist Request");        	
		}
		else
		{
			taskTrans = addToDataTransaction(taskTrans, "task_id", taskId);
			taskTrans = addToDataTransaction(taskTrans, "skilled_unskilled_assist", "SKILLED");
			taskTrans = addToDataTransaction(taskTrans, "unskilledassist", unskilled);
			taskTrans = addToDataTransaction(taskTrans, "assist_comments",commentsfield );
			taskTrans = addToDataTransaction(taskTrans, "assit_status_parent", "Pending");
			saveDataTransaction(taskTrans, "Assist Request");
		}
		log("assist if block end");
        /*taskTrans = addToDataTransaction(taskTrans, "task_id", taskId);
		taskTrans = addToDataTransaction(taskTrans, "skilled_unskilled_assist", "SKILLED");
		taskTrans = addToDataTransaction(taskTrans, "unskilledassist", unskilled);
		taskTrans = addToDataTransaction(taskTrans, "assist_comments",commentsfield );
		taskTrans = addToDataTransaction(taskTrans, "assit_status_parent", "Pending");*/       
    }
    else {
		log("assist else block start");
        taskTrans = addToDataTransaction(taskTrans, "task_id", taskId);
        taskTrans = addToDataTransaction(taskTrans, "skilled_unskilled_assist", "UNSKILLED");
        taskTrans = addToDataTransaction(taskTrans, "unskilledassist", unskilled);
        taskTrans = addToDataTransaction(taskTrans, "assit_status_parent", "Pending");
        taskTrans = addToDataTransaction(taskTrans, "assist_comments",commentsfield );
		saveDataTransaction(taskTrans, "Assist Request");
		log("assist else block end");		
    }


    //taskTrans = addToDataTransaction(taskTrans, "task_id", taskId);	
    if (saveDataTransaction(taskTrans, "Assist Request")) {
        goToScreen("DebriefOverview");
    }

}

Hi ​@preethi.a05 

Currently pasting the whole client script below, After accepting or rejecting from web client, the assit_parent_parent in original task is still showing as pending in mobile. 

What are the issues you have? Is your client script not working? Sync issues? Other?

I am a bit confused.

If your client scripts work, and there is a data discrepancy between the web and mobile clients, it is a different issue. Check the sync rule.

How do you update the record in the webclient?

Cheers!

Client script worked for below if case

if (isNullOrEmptyString(commentsfield)) {
    alert(getMessage('c_alerts_assist', 'MM_RESOURCE_STRING'));
}

but it is not working inside the else condition

if (unskilled == 'Y') {
        // alert("unskilledtask");
        log("assist if block start");
		var acceptReject = getDBValue(stringFormat("select acceptReject from c_task_ext where task_id = '{0}'", childTaskId));
		log("check acceptReject");		
        if(acceptReject == 'ACCEPT')
		{
        	taskTrans = addToDataTransaction(taskTrans, "task_id", taskId);
        	taskTrans = addToDataTransaction(taskTrans, "skilled_unskilled_assist", "SKILLED");
        	taskTrans = addToDataTransaction(taskTrans, "unskilledassist", unskilled);
        	taskTrans = addToDataTransaction(taskTrans, "assit_status_parent", "Approved");    
        	taskTrans = addToDataTransaction(taskTrans, "assist_comments",commentsfield );
        	saveDataTransaction(taskTrans, "Assist Request");
		}
		else if (acceptReject == 'REJECT')
		{
			taskTrans = addToDataTransaction(taskTrans, "task_id", taskId);
        	taskTrans = addToDataTransaction(taskTrans, "skilled_unskilled_assist", "SKILLED");
        	taskTrans = addToDataTransaction(taskTrans, "unskilledassist", unskilled);
        	taskTrans = addToDataTransaction(taskTrans, "assit_status_parent", "Declined");    
        	taskTrans = addToDataTransaction(taskTrans, "assist_comments",commentsfield );
			saveDataTransaction(taskTrans, "Assist Request");        	
		}
		else
		{
			taskTrans = addToDataTransaction(taskTrans, "task_id", taskId);
			taskTrans = addToDataTransaction(taskTrans, "skilled_unskilled_assist", "SKILLED");
			taskTrans = addToDataTransaction(taskTrans, "unskilledassist", unskilled);
			taskTrans = addToDataTransaction(taskTrans, "assist_comments",commentsfield );
			taskTrans = addToDataTransaction(taskTrans, "assit_status_parent", "Pending");
			saveDataTransaction(taskTrans, "Assist Request");
		}
		log("assist if block end");
        /*taskTrans = addToDataTransaction(taskTrans, "task_id", taskId);
		taskTrans = addToDataTransaction(taskTrans, "skilled_unskilled_assist", "SKILLED");
		taskTrans = addToDataTransaction(taskTrans, "unskilledassist", unskilled);
		taskTrans = addToDataTransaction(taskTrans, "assist_comments",commentsfield );
		taskTrans = addToDataTransaction(taskTrans, "assit_status_parent", "Pending");*/
    }

To update the record in webclient , we have another client script for “accept” and “reject” condition, that is performing the update in acceptreject field , using the alias task update it should update assit_status_parent in orginal task, but it is failing even after adding saveDataTransaction().