home

Pub

a03bfdcc-f1b1-a2d6-9d62-c043f733697e ... url.id passed in
1 ..... request.publicationService.isGUID(url.id)
request.publicationService.getPublicationsByID( url.id ):

query
RESULTSET
query
  ACCESSGROUP ACCESSGROUPSCODES ATTRIBUTESCOMPLETE CREATEDBY CREATIONDATE CRM_ID CUSTOMDATA DATACOMPLETE DESCRIPTION EXPIRATIONDATE EXTENSION FEATUREDENDDATE FIRSTINDEXINGCOMPLETE ID INDEXINGACTION ISFEATURED ISPUBLISHED ISSEARCHABLE ISSECURED ISWEBADDRESS LASTUPDATEBY LASTUPDATEDATE MASTERID NAME PUBFILENAME PUBLISHDATE RELEASEDATE THUMBFILENAME THUMBSOURCE TOOLKITSCOUNT WEBURL
CACHED false
EXECUTIONTIME 8
SQL select pubs.* , (select count(pubkits.id) from Toolkit2_Publication pubkits where PublicationId = pubs.id) as toolkitsCount , SUBSTRING( ( SELECT ( ',' + ag.AccessCode) FROM Publication_AccessGroup pag left join AccessGroups ag on ag.ID = pag.AccessGroupID where PublicationID = pubs.ID FOR XML PATH('') ), 2, 1000 ) as AccessGroupsCodes from publications pubs where id in (?)
SQLPARAMETERS
array
1 a03bfdcc-f1b1-a2d6-9d62-c043f733697e
request.publicationService.getPublicationsByID( url.id )
here:
query
RESULTSET
query
  ACCESSGROUP ACCESSGROUPSCODES ATTRIBUTESCOMPLETE CREATEDBY CREATIONDATE CRM_ID CUSTOMDATA DATACOMPLETE DESCRIPTION EXPIRATIONDATE EXTENSION FEATUREDENDDATE FIRSTINDEXINGCOMPLETE ID INDEXINGACTION ISFEATURED ISPUBLISHED ISSEARCHABLE ISSECURED ISWEBADDRESS LASTUPDATEBY LASTUPDATEDATE MASTERID NAME PUBFILENAME PUBLISHDATE RELEASEDATE THUMBFILENAME THUMBSOURCE TOOLKITSCOUNT WEBURL
CACHED false
EXECUTIONTIME 1
SQL select pubs.* , (select count(pubkits.id) from Toolkit2_Publication pubkits where PublicationId = pubs.id) as toolkitsCount , SUBSTRING( ( SELECT ( ',' + ag.AccessCode) FROM Publication_AccessGroup pag left join AccessGroups ag on ag.ID = pag.AccessGroupID where PublicationID = pubs.ID FOR XML PATH('') ), 2, 1000 ) as AccessGroupsCodes from publications pubs where id in (?)
SQLPARAMETERS
array
1 a03bfdcc-f1b1-a2d6-9d62-c043f733697e
No such Publication.