select * from (

select bm.TENANT_ID,bm.PORTAL_ID,bm.TABLE_ID,bm.BOARD_ID,bm.BOARD_TYPE,

bm.USE_CATEGORY,bm.CATEGORY_ID,bm.USE_DEPT_BOARD,bm.USE_POST_DELIBERATION,bm.USE_POST_REPLY,

bm.USE_POST_YES_NO,bm.USE_POST_REPORT,bm.USE_ANONYMOUS,bm.USE_POST_SECURITY,bm.USE_WIKI, bm.SEARCH_TERM, bm.USE_TAG, bm.FORM_ID, bm.PTL_CTX_NAME,

bm.USE_NO_CERT,bm.USE_POST_LIFECYCLE,bm.POST_LIFECYCLE_TERM,bm.USE_NEW_POST,bm.NEW_POST_TERM,

bm.USE_COMMENT,bm.USE_FBD_WORD,bm.USE_PRE_NEXT,bm.USE_CHARGER,bm.USE_HEADINGS,bm.HEADER_CODE,

bm.USE_BOOMUP,bm.CREATOR_UID,bm.CREATOR_NAME,bm.CREATE_DATE,bm.USE_SOURCE_COPY,

bm.create_mlg, bm.delete_mlg, bm.view_mlg, bm.view_restrict_option, bm.aview_mlg, bm.reply_mlg, bm.comment_mlg,

(select r.resource_name from tbbs_table_master tm, {{vo.comDbUser}}.tcom_resource r

where tm.tenant_id = r.tenant_id

and tm.portal_id = r.portal_id

and tm.tenant_id = :vo.id.tenantId

and tm.portal_id = :vo.id.portalId

and tm.table_id = bm.table_id

and tm.table_name = r.resource_id

and r.lang_type = :vo.langType) table_name, r.resource_name board_name

from tbbs_board_master bm, {{vo.comDbUser}}.tcom_resource r

where bm.tenant_id = r.tenant_id

and bm.portal_id = r.portal_id

and bm.tenant_id = :vo.id.tenantId

and bm.portal_id = :vo.id.portalId

and bm.board_name = r.resource_id

and r.lang_type = :vo.langType

and bm.board_type = :vo.boardType

and bm.board_id != :vo.id.boardId

and bm.board_id in ({{vo.boardIds}})

#if ($vo.id.tableId && !$vo.id.tableId.equals(""))

and bm.table_id = :vo.id.tableId

#end

#if($vo.useCategory && !$vo.useCategory.equals(""))

and bm.use_category = :vo.useCategory

#end

#if ($vo.usePostDeliberation && !$vo.usePostDeliberation.equals(""))

and bm.use_post_deliberation = :vo.usePostDeliberation

#end

#if ($vo.useAnonymous && !$vo.useAnonymous.equals(""))

and bm.use_anonymous = :vo.useAnonymous

#end

#if ($vo.useHeadings && !$vo.useHeadings.equals(""))

and bm.use_headings = :vo.useHeadings

#end

) a

where 1 = 1

#if ($vo.boardName && !$vo.boardName.equals(""))

and board_name like '%' + :vo.boardName + '%' ESCAPE '_'

#end

#if ($vo.tableName && !$vo.tableName.equals(""))

and table_name like '%' + :vo.tableName + '%' ESCAPE '_'

#end

order by

#if ($vo.sortBy && !$vo.sortBy.equals(""))

{{vo.sortBy}} {{vo.sortType}},

#else

board_name,

#end

create_date desc

]]>

select * from TBBS_BOARD_COL_INFO

where tenant_id = :vo.id.tenantId

and portal_id = :vo.id.portalId

#if ($vo.tableId && !$vo.tableId.equals(""))

and table_id = :vo.tableId

#end

and board_id = :vo.sourceBoardId

and column_expand = '1'

]]>

ERROR

org.anyframe.query.QueryServiceException: Query Service : Fail to select [query id = 'selectTspBbsMasterByTypes']. Query = [ select * from ( select bm.TENANT_ID,bm.PORTAL_ID,bm.TABLE_ID,bm.BOARD_ID,bm.BOARD_TYPE, bm.USE_CATEGORY,bm.CATEGORY_ID,bm.USE_DEPT_BOARD,bm.USE_POST_DELIBERATION,bm.USE_POST_REPLY, bm.USE_POST_YES_NO,bm.USE_POST_REPORT,bm.USE_ANONYMOUS,bm.USE_POST_SECURITY,bm.USE_WIKI, bm.SEARCH_TERM, bm.USE_TAG, bm.FORM_ID, bm.USE_NO_CERT,bm.USE_POST_LIFECYCLE,bm.POST_LIFECYCLE_TERM,bm.USE_NEW_POST,bm.NEW_POST_TERM, bm.USE_COMMENT,bm.USE_FBD_WORD,bm.USE_PRE_NEXT,bm.USE_CHARGER,bm.USE_HEADINGS,bm.HEADER_CODE, bm.USE_BOOMUP,bm.CREATOR_UID,bm.CREATOR_NAME,bm.CREATE_DATE,bm.USE_SOURCE_COPY, bm.create_mlg, bm.delete_mlg, bm.view_mlg, bm.view_restrict_option, bm.aview_mlg, bm.reply_mlg, bm.comment_mlg, r.resource_name board_name from TTSP_BBS_MASTER bm, COM_USER.tcom_resource r where bm.tenant_id = r.tenant_id and bm.portal_id = r.portal_id and bm.space_id = :vo.id.spaceId and bm.tenant_id = :vo.id.tenantId and bm.portal_id = :vo.id.portalId and bm.board_name = r.resource_id and r.lang_type = :vo.langType and bm.board_type = :vo.boardType and bm.board_id != :vo.id.boardId and bm.board_id in ('201411051605347151011') and bm.use_category = :vo.useCategory and bm.use_post_deliberation = :vo.usePostDeliberation and bm.use_anonymous = :vo.useAnonymous ) where 1 = 1 order by board_name, create_date desc ] Reason = [sql; nested exception is java.sql.SQLException: ORA-00904: "BM"."TABLE_ID": 부적합한 식별자 ]. 이렇게 뜨는데 왜그런거죠?