AI OnAI Off
Sounds like something that should be supported at CMS core level first. Well you can always have some SP to query data if you want to :) - or if you want to use APIs - the ICatalogSystem has something that might interest you.
Something is up https://world.episerver.com/blogs/Quan-Mai/Dates/2018/6/a-new-open-source-project-catalogcontenttyperesolver-/
It would be helpful with a function to see which ContentType a ContentReference points to without actually having to load the entire data object.
We have two different ContentTypes: CategoryNode and BrandNode that both are linked to entries with NodeRelations. Our customer updates the relations through an integration and at that time we need to load the existing relations and determine which one(s) points to a BrandNode. Today we have no better solution than to load all nodes from the database and check the ContentType afterwards. The most annoying part is that we get over thousands of database calls to get assets through
ecf_CatalogNode_Asset
, which isn't needed at all to update relations.