Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field
Hi there,
With New York, the labels functionality on Visual Task Boards has changed drastically. Instead of the maximum of 7 labels on a Visual Task Board, one can add unlimited labels to a Visual Task Board! I've described how this technically works and which tables are involved in a previous article (Visual Task Board unlimited labels [New York]). This article goes a step further: What if you would like to script adding labels to Visual Task Board Cards?
Recently Jon Ulrich did a nice job on "An automatic task board labeling system". Vladimir also described "Adding Visual Task Boards Labels through a script". Both are unfortunately based on pre-New York.
Data structure
On a Visual Task Board, Cards are being displayed. The Card representing a Task. On the Card, one or more Labels can be tagged. So how does this work? Below an example with a Private Task [vtb_task].
Key is the Visual Task Board Card [vtb_card]. This record contains references to:
- Task [task];
- Visual Task Board [vtb_board];
- Visual Task Board Lane [vtb_lane].
The labels are now stored in the Tag table [label]. This table is referenced through the Visual Task Board Label table [vtb_board_label] and the Label Entry table [label_entry].
The Visual Task Boad Labels record contains references to:
- Visual Task Board [vtb_board];
- Tag [label].
The Label Entry record contains references to:
- Tag [label];
- Table and Table key.
Scripting labels on Cards
Time to translate the above structure into scripting. For example, we could set up a Business Rule which runs on insert of a Visual Task Board Card on a certain Visual Task Board. This could well be achieved through the conditions.
For testing, let's say the label we automatically want to add is the "High Priority" label.
var labelStr = 'High Priority';
var grLabel = new GlideRecord('label');
grLabel.addQuery('name', labelStr);
grLabel.addQuery('viewable_by', 'everyone');
grLabel._query();
if(grLabel._next()) {
var grLabelEntry = new GlideRecord('label_entry');
grLabelEntry.initialize();
grLabelEntry.setValue('label', grLabel.getUniqueValue());
grLabelEntry.setValue('table', current.task.sys_class_name);
grLabelEntry.setValue('table_key', current.task);
grLabelEntry.insert();
}
Hmmm, labelStr looks like a string, is that oke? Actually, it is. The Tag records [label] which are "Viewable by" "Everyone", have a unique name.
The script itself isn't that huge and difficult. Obviously, if you also want to script adding a Task on a Visual Task Board with Labels, you would need to go through the whole structure like described in the previous paragraph.
---
And that's it actually. Hope you like it. If any questions or remarks, let me know!
| C |
If this content helped you, I would appreciate it if you hit bookmark or mark it as helpful.
Interested in more Articles, Blogs, Videos, Podcasts, Share projects I shared/participated in? |
Kind regards,
Mark Roethof
ServiceNow Technical Consultant @ Paphos Group
---
After creating a label in VTB, the label shows in tag,
Is there any way to stop showing in the assign tag?
example: created 2 labels with names 5, 6
