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

 

1 REPLY 1

Derek Sewall
Tera Expert

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