clm_m2m_contract_asset many to many table not in sys_collection or sys_m2m

[AndyLock]

After pressing the Edit... button to add Assets to a Contract we're presented with an Assets sluchbucket, as expected. But, the filter relates to the Contract table instead of the Assets table as it does OOB.

I found some articles on checking the Many to Many definitions (sys_m2m.LIST & sys_collection.LIST) but our clm_m2m_contract_asset table is not visible in either of these.

The m2m table is working fine, and there's a lot of data in it - it's just that we need to move the collector filter to work across the asset table.

Please help.

thx.

[Pooja Mallikarj]

Hi,

Search from System definition->Tables  and search for Name column.

It is visible.

Mark correct/helpful if it helps for you.

Regards,

Pooja

[AndyLock]

Hi Pooja,

Yes, the table exists in System Definition -> Tables

The table is working as expected when using the Edit... butoon, but the collection filter is looking at the wrong table.

[debasish_hm]

@AndyLock I am running into the same issue. did you happen to find a solution to this problem?

Thanks!

[AndyLock]

Hi @debasish_hm 

The solution was to import a missing M2M relationship called clm_m2m_contract_asset in the sys_m2m table: 

From table: ast_contract
To table: alm_asset
Application: Global
From field: contract
From label: Assets Covered
To field: asset
To label: Contracts

Here's a link to how to create M2M relationships in ServiceNow: https://docs.servicenow.com/bundle/newyork-platform-administration/page/administer/table-administrat...

To help make this easier I've attached this record as an importable xml file.

Once imported/created record should appear in this link: https://<instance>.service-now.com/nav_to.do?uri=%2Fsys_m2m.do%3Fsys_id%3D25b06b5c0b033200923e15545cbd0f15 

Hopefully this resolves your issue in sub-production, before you implement it as a planned update in Prod.

Andy