Caché 2009.1 - NEWSCYCLE Solutions: DTI Lighting 7.7.x: Get run date of story method.

runDate()

<script language="cache" method="runDate" arguments='cmsStory:dt.cms.schema.CMSStory=-1' returntype="%String" procedureblock="1">
	
	set return = ""
	try {
		set cmsStoryId = cmsStory.%Id()
		&sql(
			SELECT runDate INTO :return
			FROM dbo.adDbPageInfo api, dbo.storyPageElements spe, dbo.story sty, dt_cms_schema.CMSStory cms
			WHERE api.logicalPageId = spe.logicalPagesId
			AND sty.storyId = spe.storyId
			AND story->storyid = sty.storyid
			AND cms.id = :cmsStoryId
		)
	} catch(e) {
		; What to log and where?
	}
	quit return
	
</script>

<csp:comment>
<csp:object name="gStory" classname="dt.cms.schema.CMSStory" objid="26035312">
#(..rundate(gStory))#
<br>
</csp:comment>