×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Trần Hải Quân
Added: May 14, 2013 4:30 AM
Modified: May 14, 2013 6:34 AM
Views: 87
Tags: sql episerver bsk
get information of xform in db BSK
  1. USE dbBTFGrid30_Daily_Core
  2. SELECT  DISTINCT
  3.         cpv.CorePageName,x.FormName,x.MailSubject,cp.CoreCreated,cpv.CoreFirstPublish
  4. FROM    dbo.ArticleVersion av
  5.         INNER JOIN dbo.CoreArticleVersion cav ON av.VersionID = cav.CoreVersionID
  6.         INNER JOIN dbo.CorePageVersion cpv ON cav.CoreVersionID = cpv.CoreVersionID
  7.         INNER JOIN dbo.CorePage cp ON cpv.CorePageID = cp.CoreID
  8.         INNER JOIN dbBTFGrid30_Daily_EPiServer.dbo.VW_XForms x ON av.XForm=x.ExternalId
  9. WHERE   cp.CoreRemoteSite = 'AmeliaCore' AND av.XForm IS NOT NULL
  10. AND cpv.CoreStatus=4