Old Forums
Search:
Portal Engine Questions on portal engine and web parts.
Version 7.x > Portal Engine > Check for Orphaned Attachments View modes: 
User avatar
Member
Member
TheCriticalPath - 1/21/2013 7:23:20 AM
   
Check for Orphaned Attachments
Is there a simple way to check for objects in CMS_Attachments that have no document relationship?

User avatar
Kentico Support
Kentico Support
kentico_zdenekc - 1/22/2013 7:51:13 AM
   
RE:Check for Orphaned Attachments
Hi,

The relation is defined by foreign key AttachmentDocumentID, so selecting the attachments that have this column empty or not matching any existing document's DocumentID could give you the requested set.

Regards,
Zdenek
User avatar
Member
Member
TheCriticalPath - 1/23/2013 7:38:35 AM
   
RE:Check for Orphaned Attachments
Thank you.

Top