barrier error

[LenS]

i have created a barrier using the device tab (2 off terminals each side) and internally connected. when i view loop in detail connection window all shows as expected. when i then view token doc (Xai.dwg) only the left hand terminals of the barrier are pulled thro'. when i check the system query i see that the column headed RTN is empty, only the LTN field is populated. how do i correctly create and pull both tokens for a barrier

[LenS]

bentley I&W support have supplied me with a modified SQL_STRING which pulls thro' the right hand terminals as well. seems that the LTN, RTN fields are misleading and are not required (and has now been removed from SQL_STRING) as allowed for in programs hard code. terminal numbers now placed correctly on token doc. Query attached for those interested:-

SELECT DISTINCT [TERM].[TERM_ID],[INSTR].[TAG_NO],[SYSLOOP].[LOOPTYPE],[SYSLOOP].[TAG_NO] AS [LOOP_NO], [SYSLOOP].[SERVICE],[INSTR].[DESCRIPT] AS [DESCRIPTION], [PANEL].[TAG_NO] AS [PANEL], [INSTR].[MODEL],[INSTR].[MANUFACTR],[TSTRIP].[TAG_NO] AS [TSTRIP], [TERM].[L1],[TERM].[L2],[TERM].[TNUM] AS [TN], [TERM].[L3],[TERM].[L4],[TERM].[L5],[TERM].[L6],[CORE].[CORE] AS [TC], [CORE].[CORETAG1] AS [CTAG1], [CABLE].[TAG_NO] AS [CABLE], [CARD].[CNTRLR],[CARD].[NODE],[CARD].[NUM] AS [SLOT], [CARD].[RACK],[IO_LIST].[CHNL],[IO_LIST].[ADDRESS],[CARD].[CARDTYPE],[INSTR].[IO_TYPE],[INSTR].[IAREA],[INSTR].[ITYP],[INSTR].[INUM],[INSTR].[SYMBOL],[TERM].[ROW_POS],[TERM].[CON_POS],[CABLE].[CABTYPE],[SYSLOOP].[KEYTAG] AS [JOINKEYTAG], [SYSTERM].[TSTRIP_ID] & ':' & [SYSTERM].[ROW_POS] AS [JOINPARAM], [SYSINSTR].[ORD] AS [INSTR_NUM], [SYSTERM].[ROW_ID] & [SYSTERM].[ROW_POS] AS [ROWNUMBER], LTRIM(RTRIM([SYSINSTR].[ORD])) & LTRIM(RTRIM([TERM].[CON_POS])) & LTRIM(RTRIM([SYSTERM].[ROW_POS])) AS [TOKENSEEKFLD], [SYSTERM].[CON_POS] AS [SYSCON_POS], [TERM].[PRIMARY_ROW],[PORT].[PORT_NO],[PORT].[IP_ADDRESS] AS [PORT_IP], [CARD_1].[TAG_NO] AS [H1_CARDTAG], [CARD_1].[CARDTYPE] AS [H1_CARDTYPE], [CARD_1].[RACK] AS [H1_CRD_RACK], [CARD_1].[NUM] AS [H1_CRD_SLOT], [PORT].[NETWORK] AS [PORT_NETWORK], [PORT].[NODE] AS [PORT_NODE], [PANEL_1].[TAG_NO] AS [CARDPANEL], [PANEL_2].[TAG_NO] AS [H1_CARDPANEL], [CARD].[TAG_NO] AS [CARDTAG], [PANEL_DOC_LINK_1.DOC_NAME] AS [TERM_DWG] FROM ((((((((LOOP AS SYSLOOP LEFT JOIN INSTR AS SYSINSTR ON SYSLOOP.KEYTAG = SYSINSTR.LOOP_ID) LEFT JOIN SYSTERM ON SYSINSTR.TSTRIP_ID = SYSTERM.TSTRIP_ID) LEFT JOIN ((INSTR RIGHT JOIN (((CABLE RIGHT JOIN CORE ON CABLE.KEYTAG = CORE.CABLE_ID) RIGHT JOIN (TSTRIP RIGHT JOIN SYSTERM AS TERM ON TSTRIP.KEYTAG = TERM.TSTRIP_ID) ON CORE.FROMTERMID = TERM.TERM_ID) LEFT JOIN PANEL ON TSTRIP.PANEL_ID = PANEL.KEYTAG) ON INSTR.TSTRIP_ID = TERM.TSTRIP_ID) LEFT JOIN (CARD RIGHT JOIN IO_LIST ON CARD.KEYTAG = IO_LIST.CARD_ID) ON INSTR.KEYTAG = IO_LIST.INSTR_ID) ON SYSTERM.ROW_ID = TERM.ROW_ID) LEFT JOIN (PORT_IO_LIST LEFT JOIN PORT ON PORT_IO_LIST.PORT_ID = PORT.PORT_ID) ON INSTR.KEYTAG = PORT_IO_LIST.INSTR_ID) LEFT JOIN CARD AS CARD_1 ON PORT.CARD_ID = CARD_1.KEYTAG) LEFT JOIN PANEL AS PANEL_1 ON CARD.PANEL_ID = PANEL_1.KEYTAG) LEFT JOIN PANEL AS PANEL_2 ON CARD_1.PANEL_ID = PANEL_2.KEYTAG) LEFT JOIN PANEL_DOC_LINK ON PANEL_1.KEYTAG = PANEL_DOC_LINK.PANEL_KEYTAG) LEFT JOIN PANEL_DOC_LINK AS PANEL_DOC_LINK_1 ON PANEL.KEYTAG = PANEL_DOC_LINK_1.PANEL_KEYTAG ORDER BY SYSLOOP.KEYTAG, SYSINSTR.ORD, [SYSTERM].[ROW_ID] & [SYSTERM].[ROW_POS], LTRIM(RTRIM([SYSINSTR].[ORD])) & LTRIM(RTRIM([TERM].[CON_POS])) & LTRIM(RTRIM([SYSTERM].[ROW_POS]))