Get input to pass into server script for a service portal widget

[Jake Sadler]

I'm trying to get the user input from my widget and pass it into my server script to get a result.

HTML 

<div class="panel panel-default">
<div class="panel-heading">
<h4 class="panel-title">Table Extensions</h4>
</div>
<div class="panel-body">
<sn-record-picker field="field" table="'sys_db_object'" display-field="'name'" value-field="'sys_id'" search-fields="'name'" page-size="100" ></sn-record-picker>
<form class="m-t form-horizontal" role="form">
<div class="form-group">
<label class="col-sm-2 control-label">Hierarchy</label>
<div class="col-sm-10">
<input type="text" placeholder="{{data.res}}" class="form-control" readonly>

</div>

Client Script

function ($scope) {

var c = this;
$scope.table = "sys_db_object";

c.server.update();
}

server script

(function() {

var tableName = input.setTable;
var table = new TableUtils(tableName);
var tableArrayList = table.getTables();
var tableArray = j2js(tableArrayList);

var result = tableArray.reverse();
if(result!=''){
data.res = result.join(" >>> ");
}
})();

 Widget Preview

Any help would be greatly appreciated

[vkachineni]

What is the value in "input.setTable"

Here is a code snippet that works.

(function() {
var table = new TableUtils("cmdb_ci");
var ciTableList = j2js(table.getTableExtensions());
for (var i = 0; i < ciTableList.length; i++) {
var tableGR = new GlideRecord('sys_db_object');
tableGR.get('name',ciTableList[i])
gs.print(tableGR.label + '\t' + ciTableList[i]);
}
})();

[Jake Sadler]

That's what I'm struggling with I want input.setTable to equal the table the user selects like the below screenshot input.setTable = cmdb_ci_server and so the output would be 

cmdb >>> cmdb_ci >>> cmdb_ci_hardware >>> cmdb_ci_computer >>> cmdb_ci_server

[vkachineni]

See https://serviceportal.io/sn-record-picker/ on how to set the variable in the client script and send it to the server.

[Ankur Bawiskar]

Hi,

you want user to enter record picker?

then based on that set the hierarchy?

Regards
Ankur