Add editable watchlist to portal tickets

Chuck S2 · ‎03-02-2021

I would like to make the watch list on the tickets on the service portal editable (after submission). I reviewed a thread that was started 4 years ago and tried to follow that thread and populate the various Client and Server script fields accordingly, but nothing is showing on the portal. I am pretty much a newbie at service portal. Any help would be appreciated. Thanks!

User667175 · ‎03-02-2021

Hi Chuck,

The following are the widget modifications that we made, you can place this into the relevant fields on the widget form.

Body HTML Termplate:

<div class="panel panel-primary" ng-if="data.canRead">
  <div class="panel-heading">
    <h4 class="panel-title pull-left">
      ${Watch list}
    </h4>
    <div class="clearfix"></div>
  </div>
  <div class="panel-body">
    <form ng-submit="save()">
      <div class="text-center text-italic text-muted">
        <div>
          <sn-record-picker field="watch_list" sn-disabled="!data.canWrite" table="'sys_user'" display-field="'email'" display-fields="'name'" search-fields="'email'" value-field="'sys_id'" default-query="'active=true^web_service_access_only=false^user_nameISNOTEMPTY^emailISNOTEMPTY'" page-size="10" multiple="true"></sn-record-picker>   </div>
        <div style="margin-top:15px; float: right;">
          <button type="submit" class="btn btn-primary post-btn ng-scope">Save</button>
        </div>
      </div>
    </form>
  </div>
</div>

Server Script:

(function() {
	var gr;
	if(input){
		gr = new GlideRecord(input.table);
		if(gr.get(input.sys_id)){
			if(gr.watch_list.canWrite()){
				gr.watch_list = input.watchList;
				gr.update();
				gs.addInfoMessage('Updated');
			}
			else{
				gs.addErrorMessage("Update failed, you don't have the required access");
			}
		}
	}
	else{
		var sys_id = (input && input.sys_id) || options.sys_id || $sp.getParameter("sys_id");
		var table = (input && input.table) || options.table || $sp.getParameter("table");
		gr = new GlideRecord(table);
		if(gr.get(sys_id)){
			data.table = table;
			data.sys_id = sys_id;
			data.canRead = gr.watch_list.canRead();
			data.canWrite = gr.watch_list.canWrite();
			if(data.canRead){
				var dV = gr.getDisplayValue('watch_list');
				var sV = gr.getValue('watch_list');
				data.displayValue = dV == '' ? [] : dV;
				data.value = sV == null ? [] : sV;
				data.displayValue = dV;
				data.value = sV;
			}
		}
	}
})();

Client Controller:

function($scope, spUtil, $http) {   
	var c = this;

	$scope.watch_list = {
		displayValue: c.data.displayValue,
		value: c.data.value,
		name: 'watch_list'
	};
	$scope.save = function(){
		c.data.watchList = $scope.watch_list.value;
		c.server.update().then(function() {

			spUtil.recordWatch($scope, c.data.table, "sys_id=" + c.data.sys_id, function(name, data) {
				if(name.name == 'record.updated' && data.operation == 'update'){
					$scope.watch_list.value = data.record.watch_list.value;
					$scope.watch_list.displayValue = data.record.watch_list.display_value;
					$scope.$apply();
				}
			});
		});
	};
	$scope.$on("field.change", function(evt, parms) {
		if (parms.field.name == 'watch_list') {}

	});
};

This result in a widget that has only valid users in there. If you wish to change which users are filtered, check out the default-query in the HTML Body

default-query="'active=true^web_service_access_only=false^user_nameISNOTEMPTY^emailISNOTEMPTY'"

This if done correctly, you'll get a widget like the following:

Hopefully the above is helpful!

Thanks,

Mike

View solution in original post

Chuck S2 · ‎03-03-2021

Hi Mike,

That worked even better. Now they want to limit it to users that have a client that is the same as the client of who is editing the watchlist.

We use this on Server side to populate watchlist when request is being submitted so they can only select users that are same client as user opening the request, but not sure where it would fit in on the portal fields after request is submitted....

var ga = new GlideAjax('getClient');
ga.addParam('sysparm_name', 'getClientFromUserID');
ga.addParam('sysparm_userID', g_user.userID);
ga.getXMLAnswer(callback);
}

function callback(answer) {
var watchListCollector = g_list.get("watch_list");
watchListCollector.reset();
watchListCollector.setQuery("active=true");
watchListCollector.setQuery(answer);
//alert(answer);
}

User667175 · ‎03-03-2021

Hi Chuck,

Under the default query I believe you should be able to call a script include that will return a comma separated list of users:

default-query="'javascript: scriptInclude().function()'"

So you could call to a script include, figure out the criteria by doing a glide, and then return a comma separated list.

Hope this helps,

Cheers,

Mike

Chuck S2 · ‎03-12-2021

Hi Mike,

Just getting back to this. I tried to call a script include, but it doesn't seem to work. Not sure if you have any other suggestions.

Chuck