Many to Many on same table?

[Nate23]

Hello All,

I've been put to the task of trying to create a Many-to-many relationship on the Change Request table. We sort of have it working but not to our liking. We created another table to associate the changes with each other. but if you go on one change request and show the related list for the Change Request table it will show the related change requests like it should. However, you click on one of the related change requests to view it and it shows the relation on the other table we created not the Change Request table.

We want it to be consistent on one table not two. The attached link shows the related lists on two different Change Requests. Notice that the table names are different.

Any help would be appreciated.

Thanks,

Nathan G.

[Nate23]

I forgot I added this onChange client script to remove the change from other if it was removed from the list field:

function onChange(control, oldValue, newValue, isLoading, isTemplate) {

       if (isLoading) {

               return;

       }



       var old = oldValue;

       var val = newValue;

       var seperate = old.split(',');

       var filterString = '';



       for(var i = 0; i < seperate.length; i++){



               if(val.indexOf(seperate[i]) == -1){

                       if(filterString == '')

                               filterString = filterString + seperate[i];

                       else

                               filterString = filterString + ',' + seperate[i];

                       //alert('this was removed: ' + seperate[i]);

               }



       }

   //alert(filterString);



       if(filterString != ''){

               var ga = new GlideAjax('RemoveChangeM2M');

               ga.addParam('sysparm_name','removeChangeM2M');

               ga.addParam('sysparm_filter',filterString);

   ga.addParam('sysparm_number',g_form.getValue('number'));

               ga.getXML(HelloWorldParse);





       }

         alert('Be sure to always save or update after changing this field');





}





 function HelloWorldParse(response) {

                       var answer = response.responseXML.documentElement.getAttribute("answer");

                     // alert(answer);

               }

and it references this script include:

var RemoveChangeM2M = Class.create();

RemoveChangeM2M.prototype = Object.extendsObject(AbstractAjaxProcessor, {

       removeChangeM2M: function() {

               var filterString = this.getParameter('sysparm_filter');

               var number = this.getParameter('sysparm_number');

               var test = '';

               var test2 = '';

               var hold = '';

               try{

                       var record = new GlideRecord('change_request');

                       record.addQuery('number', number);

                       record.query();

                       if(record.next())

                               test = record.sys_id;





                       var gr = new GlideRecord('change_request');

                       gr.addQuery('sys_idIN' + filterString);

                       gr.query();

                       while(gr.next()){

                               hold = gr.u_related_changes;







                               if(hold.indexOf(','+test) != -1){

                                       gr.u_related_changes = hold.replace(','+test, "");

   hold = hold.replace(','+test, "");

                                       test2 = 'with comma';



                               }else   if(hold.indexOf(test) != -1){

                                       gr.u_related_changes = hold.replace(test, "");

                                       test2 = 'no comma';

                               }

















                               gr.update();

                       }

               }catch(e){}



               return test2;

       },



       _privateFunction: function() { // this function is not client callable



}





});

[sergej11221]

Hi Nathan,

did you manage to add   the Edit Button in a customized relationship?

Thanks

[Nate23]

This was a while back for an old client. I dont think we had the "edit" button on the related list, because the related list was populated by the list collector variable.

[Nate23]

I honestly would not use this method anymore they are better ways lol.

[smr_itsm]

I'm trying to do something similar with Knowledge articles, what do you think is a better way?