Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

M2M table in Change Request

ftulabingTCS
Tera Contributor

Hi, I have seen that the related list in Story [rm_story] which is the Prerequisite Stories and Dependent Stories are from a M2M table. I cannot find the M2M record for m2m_story_dependencies from the Many to Many Definitions. I'm trying to do the same in Change Request wherein there would be a Prerequisite and dependent Change related list but It seems we cannot create a M2M table for the same table. Can anyone explain how thus this work for Stories?

1 REPLY 1

Chaitanya ILCR
Mega Patron

Hi @ftulabingTCS 

 that's defined under sys_collection table

ChaitanyaILCR_0-1745920804593.png

you can refer this below video for complete info on this

 

and for your requirement you can go with sys_m2m table you don't have to create sys_collection 

I think it's not recommended to create sys_collection record

https://www.youtube.com/watch?v=p6qcJO76eC4

 

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

 

Join me to discover how to relate multiple records together using a many-to-many table. This builds on our concept of reference fields, and also adds some functionality to make it easy to manage the records. Episode topics include: * Reference field overview * Creating a many-to-many definition *