Find if a content item is published from within SQL database

Lori Dingman

Hello,

Is there a way using either a sql trigger or proc to definitively know that content item is published in the delivery stage?  Is there a sql table(s) to query that would indicate if a content item is actively published?  This would all need to be done in the SQL database not the display views.

Thanks for any assistance.

Trilochan_Singh

SELECT DISTINCT cmsobj.id AS objid,

  (

  CASE

    WHEN snap.modCount IS NULL

    THEN 'unpublished'

    WHEN snap.modCount <> cmsobj.modCount

    THEN 'stale'

    ELSE 'published'

  END) AS state

FROM vgnCMSObject cmsobj

JOIN vgnStageManifest sm

ON sm.objId = cmsobj.id

JOIN vgnCMSObject2 snap

ON snap.id     = sm.snapId

WHERE cmsobj.id='40CharecterVCMID'

 

Thanks & Regards,

Trilochan Singh

 

From: eLink Entry: Discussion Group - Web Experience Management [mailto:v7webcontentmanagement@elinkkc.opentext.com]
Sent: Wednesday, September 16, 2015 6:34 AM
To: eLink Recipient
Subject: Find if a content item is published from within SQL database

 

This is an EXTERNAL EMAIL. Stop and think before clicking a link or opening attachments.

---

 

Find if a content item is published from within SQL database

Posted by lori.g.dingman@wellsfargo.com (Dingman, Lori) On 09/15/2015 08:57 PM

 

Hello, Is there a way using either a sql trigger or proc to definitively know that content item is published in the delivery stage?  Is there a sql table(s) to query that would indicate if a content item is actively published?  This would all need to be done in the SQL database not the display views. Thanks for any assistance.

---

[To post a comment, use the normal reply function]
Forum:	Discussion Group - Web Experience Management
Content Server:	Knowledge Center