An Extensible Many-to-Many table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-22-2014 04:14 AM
Guys,
just wondering whether it is possible to create a many-to-many table which extends an existing m2m table ?
Cheers
maros
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-23-2014 05:17 AM
I wrote the following to extract a label ( in case you are interested... )
var gr = new GlideRecord('sys_ui_list_control');
gr.addQuery('name', 'u_cab_meeting');
gr.addQuery('related_list', this.related_list);
gr.query();
if (gr.next() && !gr.label.nil()) {
return gr.getValue('label');
}
// Try m2m label for u_cab_meeting field
gr = new GlideRecord('sys_m2m');
gr.addQuery('m2m_table', this.getTableName());
gr.addQuery('m2m_from_field', 'u_cab_meeting');
gr.query();
if (gr.next()) {
return gr.getValue('m2m_from_label');
}
// Last option - table label
gr = new GlideRecord(this.getTableName());
return gr.getLabel();