Name
global.VTBGetBoardsByUser
Description
Return a list of vtb board sys_id s that a given user is the owner or a member of.
Script
function VTBGetBoardsByUser() {
var arrayUtil = new ArrayUtil();
var user = gs.getUser();
var boardHash = {},
boardIds = [];
// Boards that user is a member of
var grBoardMembers = new GlideRecord('vtb_board_member');
grBoardMembers.addQuery('user', user.getID());
grBoardMembers.query();
while (grBoardMembers.next()) {
boardHash[grBoardMembers.board.toString()] = 1;
}
// Boards that user is the owner
var grBoard = new GlideRecord('vtb_board');
grBoard.addQuery('owner', user.getID());
grBoard.query();
while (grBoard.next()) {
boardHash[grBoard.sys_id.toString()] = 1;
}
for (var key in boardHash) {
boardIds.push(key);
}
return boardIds;
}
Sys ID
8573dc53c312020038e7fe0712d3ae81