An Extensible Many-to-Many table

[Makosko]

Guys,

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

Cheers

maros

[Anurag Tripathi]

Hi Maros,

I haven't tried this but what you can do is.

1)Create a simple M2M table.

2)Go to "tables and columns" and find your table and check the extensible check box.

Now your M2M table becomes extensible but problem is when you create another m2m table you don't have the option to choose parent. If you are creating a normal table then than might take the original table you created in step 1 as its parent.

So , i dont think one m2m can extend another m2m, however one normal table might extend m2m.

[Makosko]

Hello,

I did that... tried all sorts of options but none of them worked in the way I wanted them to.. Basically, the most important feature I want preserved/inherited from m2m is EDITING on related lists.. when you click that, it shows you a list of records from the table a reference field points to. That goes out of window as soon as I extend an original m2m tbl... The edit button is gone...

any idea on how work around that ?

Cheers

Maros

[Anurag Tripathi]

I just tried that on a demo instance, i did manage to get the Edit button on the base table but it just took me to a blank slush bucket. So what you can do is create your own Edit button and make it work as per your requirements. I think that your only resort.

But the original M2M table worked fine (edit button too).

Can you share the business scenario where you need to use this? As i have never come across such a place where i need to achieve what you are trying to.

[Makosko]

yes, the original Edit button works fine but it is gone on an extended table...or if I enable it using the Enable UI Action ( list Control ), it malfunctions...

As for my requirements...

I need to display a list of related fields on my form as follows:

1. High Impact Changes

2. Emergency Changes

3. P1/P2 Incidents

... a list can continue up to 20 lists as per business requirements ( as you can imagine )

To accomplish the above, I first created a base m2m table with two fields ( incident reference and task reference -> allowing me to select any task type ticket ), after that I created a couple of custom relationships ( related lists ) but those could not be configured with a custom default filter ( like change_type is normal, emergency or something   like that ).

so oh dear, I had no choice, but to create a new m2m table for each related list ( very painful ). As i was doing it, I realized that I might extend the base m2m table and then define a default related list filter on those extensions( ServiceNow supports that at least... ) but then the Edit button went bananas.....

what do you reckon ?