|
|
| getComponentData exception: com.sitechasia.fw.exception.EboRuntimeException: Execution failed for query: SELECT CMDOCUMENTS.DOCID, CMDOCUMENTS.DOCNAME, CMDOCUMENTS.DOCTYPEID, CMDOCUMENTS.FOLDERID, CMDOCUMENTS.AUTHOR, CMDOCUMENTS.CREATED, CMDOCUMENTS.TITLE, CMDOCUMENTS.SUBTITLE, CMDOCUMENTS.DOCABSTRACT, CMDOCUMENTS.PUBLISHDATE, CMDOCUMENTS.EXPIRATIONDATE, CMDOCUMENTS.LOCKEDBY, CMDOCUMENTS.STATUS, CMDOCUMENTS.PARENTDOCID, CMDOCUMENTS.REPID, CMDOCUMENTS.MODIFIED, CMDOCUMENTS.MODIFIER, CMDOCUMENTS.PUBLISHSTATUS, CMDOCUMENTS.ORIGINATOR, CMDOCUMENTS.CORPID, CMDOCUMENTS.SORT, CMDOCTYPES.DOCTYPENAME, CMDOCCONTENTS.CONTENTSIZE, CMDOCCONTENTS.MIMETYPE FROM CMDOCUMENTS INNER JOIN CMDOCTYPES ON CMDOCUMENTS.DOCTYPEID = CMDOCTYPES.DOCTYPEID LEFT OUTER JOIN CMDOCCONTENTS ON CMDOCUMENTS.DOCID = CMDOCCONTENTS.DOCID WHERE CMDOCUMENTS.FOLDERID = N'c373e91b07bd0ca28ffa0420f843711e' AND CMDOCUMENTS.STATUS LIKE N'1___%' ESCAPE '!' ORDER BY CMDOCUMENTS.CREATED DESC |
|
|
|
