Finding content-type / template combinations

Rhythmyx Technical Discussion
1

Hi,

I’m using the following SQL


select * from psx_objectrelationship
join CONTENTSTATUS
on (psx_objectrelationship.OWNER_ID = CONTENTSTATUS.CONTENTTYPEID)
where contenttypeid = XXXX
and variant_id = YYYY

to try and find out where this content-type/template combination is being used. It’s returning zero results. However, when I try to remove this template from the Allowed Templates list, the system is telling me that associations exist.

What am I missing?

2

I think you want psx_objectrelationship.DEPENDENT_ID.

3

Yep … that’ll be it. Couldn’t see the mistake for looking!
Thanks.