Hi Priyanka,
i have used the Data table widget using macro variable. i am seeing result like below.
i am getting any table view, Please let me know if missed anything.
Or can you help me to create some custom widget to display table records and use it in catalog variable
I think this is related to your "hide submit" button post (please close the thread if you have found a solution)?
https://community.servicenow.com/community?id=community_question&sys_id=aeaf6d5d1b374990c17111751a4bcbc3
I guess in this case you want to go with the custom widget solution. The Widget is down below, here is an example of how this will look like:
Name: My Incidents
Body HTML Template:
<div>
<sp-widget widget="data.widget" />
</div>Server script:
(function() {
data.widget = $sp.getWidget('widget-data-table', {
table: 'incident',
filter: 'assigned_toDYNAMIC90d1921e5f510100a9ad2572f2b477fe' // <Assigned to> <is dynamic> <Me>
});
})();If you want a different filter, simply go to incident.list use the filter and then right click on the breadcrumbs: "Copy query" and paste this query in the server script.
Please let us know if this solved your problem 🙂
Here you go:
HTML remains unchanged
Server script:
(function() {
data.widget = $sp.getWidget('widget-data-table', {
table: 'incident',
filter: 'assigned_toDYNAMIC90d1921e5f510100a9ad2572f2b477fe',
fields: 'number,short_description,description'
});
})();Client ctonroller:
api.controller=function($scope) {
var c = this;
var baseFilter = 'assigned_toDYNAMIC90d1921e5f510100a9ad2572f2b477fe';
var g_form = $scope.page.g_form;
$scope.$watch(function () {
return g_form.getValue('short_description');
}, function (newValue) {
setFilter(newValue, g_form.getValue('description'));
});
$scope.$watch(function () {
return g_form.getValue('description');
}, function (newValue) {
setFilter(g_form.getValue('short_description'), newValue);
});
function setFilter(shortDescription, description) {
var filter = baseFilter;
if (shortDescription) {
filter += '^short_descriptionLIKE' + shortDescription;
}
if (description) {
filter += '^descriptionLIKE' + description;
}
$scope.$broadcast('data_table.setFilter', filter);
}
};Result:
