Bonjour Community,
Recently I had received a requirement to display a read only table of the assets that are currently assigned to the current logged in user. Something like this:
This can be achieved using HTML type of variable in Catalogs. In the below video, I have explained in detail how can we implement it and can bring data from any table.
Please mark this article HELPFUL if it helped you.
Cheers,
Hardit Singh
Please connect with me on:
My script include:
var workspaceId;
function onLoad() {
workspaceId = getParameterValue("workspace_id");
if (workspaceId !== null) {
getUserAssets(workspaceId);
// prevent changing the selected AB2.0
g_form.setDisabled('workspace_name', true);
}
// hide fields in vNet MRVS
g_form.setDisplay('virtual_networks.cmdb_ci_vnet_sys_id', false);
// register custom onChange handler to workspace_name
g_form.onUserChangeValue(handler);
}
var handler = function(fieldname, originalValue, newValue) {
if (fieldname === 'workspace_name') {
getUserAssets(newValue);
}
};
var getAssetDetails = Class.create();
getAssetDetails.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getUserAssets: function (workspaceId) { // Accept workspaceId as parameter
// Initialize a variable to store HTML table string
var ci_tb = '<table style="width:75%" border="1px" cellspacing="1"><tr><th style="width:22%">Name</th><th style="width:22%">Region</th><th style="width:22%">Stage</th><th style="width:22%">FlowLogs Enabled</th><th style="width:22%">CI (intern)</th></tr>';
// Query cmdb_ci_ip_network table with the selected workspace name
var gr = new GlideRecord('cmdb_ci_ip_network');
gr.addQuery('u_parent_ab', workspaceId); // Use workspaceId parameter
//gr.addQuery('install_status', 1);
gr.orderBy('name'); // Order the results by 'name'
gr.query();
// Loop through the query results and append data to the HTML table string
while (gr.next()) {
ci_tb += '<tr><td>' + gr.getValue('name') + '</td>';
ci_tb += '<td>' + gr.getValue('u_azure_region') + '</td>';
ci_tb += '<td>' + gr.getValue('u_azure_stage') + '</td>';
ci_tb += '<td>' + gr.getValue('u_azure_flow_logs_enabled') + '</td>';
ci_tb += '<td>' + gr.getUniqueValue() + '</td></tr>';
}
// Close the HTML table tag
ci_tb += '</table>';
// Return the HTML table string
return ci_tb;
},
type: 'getAssetDetails'
});
function getParameterValue(name) {
var url = top.location.href;
var value = new URLSearchParams(url).get(name);
if (value) {
return value;
}
if (typeof GlideURL !== 'undefined' && !value) { // run only if GlideURL is available
var gUrl = new GlideURL();
gUrl.setFromCurrent();
value = gUrl.getParam("sysparm_id");
return value;
}
return null;
}
The Catalog Item Section in Question:
