The CreatorCon Call for Content is officially open! Get started here.

An Extensible Many-to-Many table

Makosko
Tera Expert

Guys,

just wondering whether it is possible to create a many-to-many table which extends an existing m2m table ?

Cheers

maros

10 REPLIES 10

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();