deletion on m2m tables

Detlef Biederma
Tera Expert

Hello 

 

concerning: https://www.youtube.com/watch?v=yJttdDa-9xU   there are 2 ways to create m2m table.

1. sys_m2m -  New    (I  name it a "real m2m")

2.  create a table with 2 references  (I name it a "not real m2m")

 

Both ways can be used to add a related  table to a form. 

Concerning: 

https://docs.servicenow.com/pt-BR/bundle/sandiego-platform-administration/page/administer/field-admi...

 

I can not use  "Reference cascade rule"   on "real m2m" tables.  

I have done some tests.  

 

u_m2m_users_incidents    - a "real m2m" table"

u_m2m_users_incidents2  - a "not real m2m table"

both references user and incidents table. 

 

If I delete a  referenced user or referenced incident:

u_m2m_users_incidents   - whole record is deleted

u_m2m_users_incidents2  -  value is empty

 

DetlefBiederma_0-1671799164628.png

 

Can I assume,  that "real m2m" table will always delete the record or is this behavior adjustable?

 

Sincerely Detlef Biedermann

 

When building ServiceNow Apps, sometimes tables will relate to each other "many to many". This is how to build m2m tables in ServiceNow. You'll learn two very different ways. 🔎 Looking for #ServiceNow talent or opportunity? http://theduke.digital/contact/ 👑 Duke Digital Media sponsorships & ...
1 REPLY 1

Derek Sewall
Tera Expert

Running into the same issue - @Detlef Biederma did you ever figure this out?