Дерево страниц

Сравнение версий

Ключ

  • Эта строка добавлена.
  • Эта строка удалена.
  • Изменено форматирование.

Постановка задачи

Подключить выбор дела на форму РКК


Подсказка

Инструмент: Палитра XML

Свойства страницы
Статус

Статус
colourGreen
titleГОТОВО

Комментарий

Реализация

Подключить поле Дело на форму

Создать схему объекта, которое будет отображаться в поле "Дело"

Блок кода
languagexml
titleСхема объекта
collapsetrue
<?xml version='1.0' encoding='UTF-8'?>
<schemas xmlns="http://www.intertrust.ru/schema/palette/tn-schema">
  <schema name="InventoryDoc">
    <meta>
      <category name="Отношение к делу" />
    </meta>
    <string name="id">
      <storage-field name="inventory_ID" />
    </string>
    <string name="description"  computed="true">
      <storage-field name="inventory_description" />
      <calc-values>
        <script lang="SPEL" event="open"><![CDATA[fc_name]]></script>
      </calc-values>
    </string>
    <string  name="subject">
      <storage-field name="inventory_subject" />
    </string>
    <hyperlink computed="true"  name="Link">
      <storage-field name="inventory_link" />
      <calc-values>
        <script lang="SPEL" event="open"><![CDATA[id == null ? null : T(ru.intertrust.cmj.af.misc.HyperLink).createHyperLink(invPrefix + invNumber + ' ' + subject +'~#'+T(ru.intertrust.cmj.ws.base.servlet.ServletUrlHolder).getServerUrlStr() + '/ids/' + id +'~#newTab~#local')]]></script>
      </calc-values>
    </hyperlink>
    <string  name="invPrefix">
      <storage-field name="inventory_prefix" />
    </string>
    <string  name="invNumber">
      <storage-field name="inventory_number" />
    </string>
    <string  name="fc_name">
      <storage-field name="inventory_name" />
    </string>
  </schema>
</schemas>

Создать структуру объекта Дела для отображения UI-интерфейсе

Блок кода
languagexml
titleФорма объекта
collapsetrue
<?xml version='1.0' encoding='UTF-8'?>
<ui xmlns="http://www.intertrust.ru/schema/palette/tn-ui">
  <form schema-ref="InventoryDoc" projection="default" id="InventoryDocForm">
    <properties>
      <hide condition-union="AND">
        <negative-condition-ref ref="digest"/>
      </hide>
    </properties>
	<!--Отображение в виде ссылки на дело-->
    <component>
      <field attribute-ref="Link" alias="description">
        <appearance importance="normal" />
      </field>
    </component>
  </form>
</ui>

Подключить объект Дела к схеме документа

Блок кода
languagexml
titleПодключение объекта в схему
<?xml    <schema-ref ref="InventoryDoc" name="case"/>version='1.0' encoding='UTF-8'?>
<schemas xmlns="http://www.intertrust.ru/schema/palette/tn-schema">
	<!-- schema -- >
		<schema-ref ref="InventoryDoc" name="case"/>
	<!-- schema -- >
</schemas>

Подключить поле "Дело" в UI-интерфейс

Блок кода
languagexml
titleПодключение объектного поля на форму
 <field attribute-ref="case" name="${ui.form.RkkResourceInputForm.section.Attributes.section.Additional.field.delo<?xml version='1.0' encoding='UTF-8'?>
<ui xmlns="http://www.intertrust.ru/schema/palette/tn-ui">
 	<!--form-->
 		<!--section-->
 			<field attribute-ref="case" name="${ui.form.RkkResourceInputForm.field.case.name:Дело:}">
				<!-- Визуализация -->
				<appearance importance="normal" multiline="true" open-form="newTab">
                	<label-style>
                    	<style id="tunBorderedField"/>
      <properties>
               </label-style>
                </appearance>
				
				<!--Подключение справочника-->
                <directories relation="inventory-all-case" limit-livesearch="sys-current">
					<directory-category-custom-coll  <read-only>attribute-ref="regPlaceID" ref="inventory-all-case"/>
				</directories>

                          </field>
	 	<!--section-->
	<!--form-->
</ui>

Подключить справочник Дел

Написать SQL запрос для вывода списка Дел

Блок кода
languagexml
titleКастомная коллекция
collapsetrue
<collection name="Inventory_(vw_cmj_all_case)" idField="id" replace="runtime">
    <prototype>
        <![CDATA[
SELECT id,
       numberWOTags,
          <condition-ref ref="canNotEditDeloInput"/>created_date,
       Module,
       self_1,
       self_2,
       self_3,
       invPrefix_tag,
       subject_tag,
       invNumber_tag,
   </read-only>
    numberWOTags,
       subject,
       moduleName,
       fc_subject,
       fileCardNumber || invNumber || ' ' || subject as description,
       </properties>invNumber,
       fc_depId,
       fileCardNumber as invPrefix
FROM (
         SELECT
             CASE WHEN b.cmjunid IS NULL THEN substring(u.migrationid, 0, 33) <appearance importance="normal" multiline="true" open-form="newTab">ELSE substring(b.cmjunid, 0, 33) END AS fc_depId,
             fc.id AS id,
             fc.module as Module,
             complect,
         <label-style>
    ss_module.title as moduleName,
             fc.created_date,
             fc.title as subject,
             fc.Code as numberWOTags,
        <style id="tunBorderedField"/>
    fc.Number as invNumber,
             '<id>'                                 </label-style>
                AS self_1,
             ':'                  </appearance>
                                  AS self_2,
             '</>'   <directories relation="inventory-all-case" limit-livesearch="sys-current">
                                             AS self_3,
      <directory-category-custom-coll attribute-ref="regPlaceID" ref="inventory-all-case"/>
     '<invPrefix>'                                           </directories>AS invPrefix_tag,
             '<subject>'                                            <hint-pop-up>${ui.form.RkkResourceInputForm.section.Attributes.section.Additional.field.delo.hintPopUp:Дело}</hint-pop-up>AS subject_tag,
             '<invNumber>'                               </field>
Блок кода
languagexml
titleКастомная коллекция
collapsetrue
<collection name="Inventory_(vw_cmj_all_case)" idField="id" replace="runtime">
    <prototype>
        <![CDATA[
SELECT idAS invNumber_tag,
       numberWOTags,
       created_date,CASE
       Module,
       self_1,
   WHEN (parent.IsCodeNumIndex   self_2,= 1)
       self_3,
       invPrefix_tag,
       subject_tag,
       invNumber_tag,
       numberWOTags,
   THEN parent.Code || '-' || fc.Number || ' ' || fc.title
    subject,
       moduleName,
      ELSE fc_subject,
       fileCardNumber .Code || '-' || invNumberfc.Number || ' ' || subject as description,
fc.title
            invNumber,
     END AS fc_depIdsubject,
       fileCardNumber as invPrefix
FROM (
   CASE
      SELECT
           WHEN (parent.IsCodeNumIndex CASE= WHEN b.cmjunid IS NULL THEN substring(u.migrationid, 0, 33) ELSE substring(b.cmjunid, 0, 33) END AS fc_depId,
1)
                     THEN parent.Code || '-' ||  fc.idNumber
    AS id,
            ELSE fc.moduleCode as Module,|| '-'
             complect,
    END AS fileCardNumber
       ss_module.title as moduleName,FROM
             fc.created_date,
FD_FileCard fc
              fc.title as subject,
 LEFT JOIN SO_Parent parent ON parent.id = fc.soobject
     fc.Code as numberWOTags,
          JOIN ss_module ON ss_module.id=fc.Number as invNumber,module
             '<id>'    JOIN so_parent_su ON fc.soobject = so_parent_su.id
                 JOIN so_structureunit su on su.id = so_parent_su.owner
                 ASJOIN selfso_1,
unit u on u.id = su.id
        ':'         JOIN so_beard b on b.id = su.beard
         UNION
         SELECT
             substring(b.cmjunid, 0, 33) as   AS self_2fc_depId,
             '</>'  fc.id AS id,
             fc.module as Module,
             complect,
             ss_module.title as moduleName,
     AS self_3,
       fc.created_date,
      '<invPrefix>'       fc.title as subject,
             fc.Code as numberWOTags,
             fc.Number     AS invPrefix_tagas invNumber,
             '<subject><id>'                                                 AS subjectself_tag1,
             '<invNumber>:'                                          AS invNumber_tag,
         AS self_2,
   CASE
          '</>'       WHEN (parent.IsCodeNumIndex = 1)
                     THEN parent.Code || '-' || fc.Number || ' ' || fc.title
         AS self_3,
       ELSE fc.Code || '-' || fc.Number || ' <invPrefix>' || fc.title
                 END AS fc_subject,
             CASE
        AS invPrefix_tag,
        WHEN  (parent.IsCodeNumIndex = 1)
 '<subject>'                    THEN parent.Code || '-' || fc.Number
                 ELSE fc.Code || '-'
AS subject_tag,
             '<invNumber>'     END AS fileCardNumber
         FROM
             FD_FileCard fc
            AS invNumber_tag,
    LEFT JOIN SO_Parent parent ON parent.id = fc.soobject
  CASE
               JOIN ss_module ON ss_module.id=fc.moduleWHEN (parent.IsCodeNumIndex = 1)
                 JOIN so_parent_su ON fc.soobject =THEN so_parent_su.id
Code || '-' || fc.Number || ' ' || fc.title
        JOIN so_structureunit su on su.id = so_parent_su.owner
   ELSE fc.Code || '-' || fc.Number || ' ' || fc.title
    JOIN so_unit u on u.id = su.id
       END AS fc_subject,
        JOIN so_beard b on b.id = su.beard CASE
         UNION
         SELECT
WHEN (parent.IsCodeNumIndex = 1)
                     THEN substring(b.cmjunid, 0, 33) as fc_depId,
parent.Code || '-' || fc.Number
                 ELSE fc.idCode AS id,|| '-'
             fc.module as Module,
  END AS fileCardNumber
         complect,FROM
             ssFD_module.title as moduleName,FileCard fc
             fc.created_date,
    LEFT JOIN SO_Parent parent ON parent.id =   fc.titlesoobject
  as subject,
             fc.Code as numberWOTags,
 JOIN ss_module ON ss_module.id=fc.module
                 JOIN so_parent_ph ON fc.Numbersoobject as invNumber,= so_parent_ph.id
             '<id>'    JOIN so_posthead ph on ph.id = so_parent_ph.owner
                 JOIN so_appointmenthead apph on apph.post = ph.id AND apph.accessredirect is NULL
            AS self_1,
    JOIN so_appointment app on app.id = apph.id
   ':'              JOIN so_beard b on b.id = app.beard
     ) s
WHERE 1=1
    ::where-clause
        ]]>
    </prototype>
    <counting-prototype>
       AS self_2, <![CDATA[
             '</>'SELECT
            COUNT(1)
            FROM (
         SELECT
             CASE WHEN b.cmjunid IS NULL  AS self_3,
        THEN substring(u.migrationid, 0, 33) ELSE substring(b.cmjunid, 0, 33) END AS fc_depId,
     '<invPrefix>'          fc.id AS id,
             fc.module as Module,
             complect,
            AS invPrefix_tagss_module.title as moduleName,
             '<subject>'fc.created_date,
             fc.title as subject,
             fc.Code as numberWOTags,
             fc.Number ASas subject_taginvNumber,
             '<invNumber>'<id>'                                                 AS invNumberself_tag1,
             CASE
':'                  WHEN (parent.IsCodeNumIndex = 1)
                     THEN parent.Code || '-' || fc.Number  || ' ' || fc.title
AS self_2,
             '</>'         ELSE fc.Code || '-' || fc.Number || ' ' || fc.title
                 END AS fc_subject,
            AS CASEself_3,
             '<invPrefix>'       WHEN (parent.IsCodeNumIndex = 1)
                     THEN parent.Code || '-' || fc.Number
      AS invPrefix_tag,
          ELSE fc.Code || '-<subject>'
                 END AS fileCardNumber
              FROM
            AS FD_FileCard fcsubject_tag,
             '<invNumber>'    LEFT JOIN SO_Parent parent ON parent.id = fc.soobject
                 JOIN ss_module ON ss_module.id=fc.module
           AS invNumber_tag,
     JOIN so_parent_ph ON fc.soobject = so_parent_ph.id
   CASE
              JOIN so_posthead ph onWHEN ph(parent.idIsCodeNumIndex = so_parent_ph.owner1)
                 JOIN  so_appointmenthead apph onTHEN apphparent.post = ph.id AND apph.accessredirect is NULL
Code || '-' || fc.Number || ' ' || fc.title
                 ELSE JOIN so_appointment app on app.id = apph.id
fc.Code || '-' || fc.Number || ' ' || fc.title
                 END JOINAS so_beard b on b.id = app.beard
fc_subject,
           ) s
WHERE 1=1 CASE
    ::where-clause
        ]]>
    </prototype>
    <counting-prototype>
  WHEN (parent.IsCodeNumIndex = 1)
      <![CDATA[
            SELECT
   THEN parent.Code || '-' || fc.Number
    COUNT(1)
            FROM (
ELSE fc.Code || '-'
      SELECT
           END AS CASEfileCardNumber
 WHEN b.cmjunid IS NULL THEN substring(u.migrationid, 0, 33) ELSE substring(b.cmjunid, 0, 33) END AS fc_depId,
FROM
             FD_FileCard fc
     fc.id AS id,
          LEFT JOIN  fc.module as Module,SO_Parent parent ON parent.id = fc.soobject
             complect,
      JOIN       ss_module ON ss_module.title as moduleName,
.id=fc.module
               fc.created_date,
  JOIN so_parent_su ON fc.soobject = so_parent_su.id
      fc.title as subject,
         JOIN so_structureunit su on fcsu.Codeid as numberWOTags,= so_parent_su.owner
             fc.Number as invNumber,
  JOIN so_unit u on u.id = su.id
     '<id>'            JOIN so_beard b on b.id = su.beard
         UNION
         SELECT
             AS self_1,
   substring(b.cmjunid, 0, 33) as fc_depId,
          ':'   fc.id AS id,
             fc.module as Module,
             complect,
             ss_module.title      AS self_2as moduleName,
             '</>'fc.created_date,
             fc.title as subject,
             fc.Code as numberWOTags,
             fc.Number as invNumber,
      AS self_3,
      '<id>'       '<invPrefix>'                                          AS invPrefixself_tag1,
             '<subject>':'                                                    AS subjectself_tag2,
             '<invNumber>'</>'                                                  AS invNumberself_tag3,
             CASE
'<invPrefix>'                 WHEN (parent.IsCodeNumIndex = 1)
                     THEN parent.Code || '-' || fc.Number || ' ' || fc.title
AS invPrefix_tag,
             '<subject>'            ELSE fc.Code || '-' || fc.Number || ' ' || fc.title
                           END AS fcsubject_subjecttag,
             CASE
'<invNumber>'                 WHEN (parent.IsCodeNumIndex = 1)
                     THEN parent.Code || '-' || fc.Number
AS invNumber_tag,
             CASE
       ELSE fc.Code || '-'
       WHEN (parent.IsCodeNumIndex = 1)
       END AS fileCardNumber
         FROM
   THEN parent.Code || '-' || fc.Number || ' ' || FD_FileCard fc.title
                 LEFTELSE JOIN SO_Parent parent ON parent.id = fc.soobjectfc.Code || '-' || fc.Number || ' ' || fc.title
                 JOINEND ss_module ON ss_module.id=fc.moduleAS fc_subject,
             CASE
    JOIN so_parent_su ON fc.soobject = so_parent_su.id
        WHEN (parent.IsCodeNumIndex = 1)
      JOIN so_structureunit su on su.id = so_parent_su.owner
         THEN parent.Code || '-' || fc.Number
   JOIN so_unit u on u.id = su.id
        ELSE fc.Code   || '-'
     JOIN so_beard b on b.id = su.beard
       END AS UNIONfileCardNumber
         SELECTFROM
             substring(b.cmjunid, 0, 33) as fc_depId,FD_FileCard fc
             fc.id AS id,
  LEFT JOIN SO_Parent parent ON      parent.id = fc.module as Module,soobject
             complect,
             JOIN ss_module.title as moduleName,ON ss_module.id=fc.module
             fc.created_date,
    JOIN        so_parent_ph ON fc.titlesoobject as subject,= so_parent_ph.id
             fc.Code as numberWOTags,
  JOIN so_posthead ph on ph.id       fc.Number as invNumber,= so_parent_ph.owner
             '<id>'    JOIN so_appointmenthead apph on apph.post = ph.id AND apph.accessredirect is NULL
                 JOIN so_appointment app on app.id = apph.id
            AS self_1,
    JOIN so_beard b on b.id = app.beard
   ':'  ) s
WHERE 1=1
                ::where-clause
        ]]>
    </counting-prototype>
    <filter name="MODULE">
        <criteria placeholder="where-clause">
      AS self_2,
     <![CDATA[
        '</>'        Module = {0}
            ]]>
        </criteria>
    </filter>
    <filter name="self">
        <criteria placeholder="where-clause">
  AS self_3,
         <![CDATA[
    '<invPrefix>'            Module = {0} and id = {1}
            ]]>
        </criteria>
    AS invPrefix_tag,</filter>
    <filter name="description">
        '<subject>' <criteria placeholder="where-clause">
            <![CDATA[
                description = {0}
            ]]>
 AS subject_tag,
      </criteria>
    </filter>
   '<invNumber>' <filter name="description_partial">
        <criteria placeholder="where-clause">
            <![CDATA[
                description iLIKE ('%'||{0}||'%')
      AS invNumber_tag,
     ]]>
        CASE</criteria>
    </filter>
    <filter name="subject">
        WHEN (parent.IsCodeNumIndex = 1)<criteria placeholder="where-clause">
            <![CDATA[
         THEN parent.Code || '-' ||  fc.Number ||subject ' ' || fc.title
= {0}
            ]]>
       ELSE fc.Code || '-' || fc.Number || ' ' || fc.title
 </criteria>
    </filter>
    <filter name="subject_partial">
        <criteria placeholder="where-clause">
          END AS fc_subject, <![CDATA[
             CASE
   subject iLIKE ('%'||{0}||'%')
            WHEN (parent.IsCodeNumIndex = 1)
]]>
        </criteria>
    </filter>
    <filter name="fc_subject">
      THEN parent.Code || '-' || fc.Number
<criteria placeholder="where-clause">
            <![CDATA[
       ELSE fc.Code || '-'
          fc_subject ilike '%'||{0}||'%'
     END AS fileCardNumber
         FROM]]>
        </criteria>
     FD_FileCard fc</filter>
      <filter name="fc_subject_partial">
        <criteria placeholder="where-clause">
  LEFT JOIN SO_Parent parent ON parent.id = fc.soobject
   <![CDATA[
              JOIN ss_module ON ss_module.id=fc.module
   fc_subject ilike '%'||{0}||'%'
            JOIN so_parent_ph ON fc.soobject = so_parent_ph.id ]]>
        </criteria>
    </filter>
     JOIN so_posthead ph on ph.id = so_parent_ph.owner
    <filter name="fc_depId">
        <criteria placeholder="where-clause">
            <![CDATA[
 JOIN so_appointmenthead apph on apph.post = ph.id AND apph.accessredirect is NULL
         fc_depId ilike '%'||{0}||'%'
      JOIN so_appointment app on app.id = apph.id
    ]]>
        </criteria>
    </filter>
 JOIN so_beard b on b.id = app.beard
     ) s
WHERE 1=1
                ::where-clause
        ]]>
    </counting-prototype>
    <filter name="MODULE<filter name="fc_depId_partial">
        <criteria placeholder="where-clause">
            <![CDATA[
                  Module =   fc_depId ilike '%'||{0}||'%'
                ]]>
        </criteria>
    </filter>
    <filter name="selfmoduleName">
        <criteria placeholder="where-clause">
            <![CDATA[
                Module = {0} and idmoduleName =LIKE {10}
                ]]>
        </criteria>
    </filter>
    <filter name="descriptionCQSEARCH">
        <criteria placeholder="where-clause">
            <![CDATA[
                description = {0}
            (lower(fc_subject) like ('%' || lower({0}) || '%'))]]>
        </criteria>
    </filter>
</collection>
Блок кода
languagexml
titleБин кастомной коллекции
collapsetrue
<?xml    <filter name="description_partial">
        <criteria placeholder="where-clause">
            <![CDATA[version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:p="http://www.springframework.org/schema/p" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/beans
           http://www.springframework.org/schema/beans/spring-beans-3.2.xsd" default-lazy-init="true">
     description iLIKE ('%'||{0}||'%')
  <bean id="Inventory_(vw_cmj_all_case)Metadata" class="ru.intertrust.cm_sochi.srv.connector.sochi.collections.CollectionMetadataNew" p:caseSensitiveFieldNames="true">
          ]]><constructor-arg>
        </criteria>
    </filter>
    <filter name="subject">
<list value-type="ru.intertrust.cm_sochi.srv.connector.sochi.collections.Field">
              <criteria placeholder="where-clause   <bean class="ru.intertrust.cm_sochi.srv.connector.sochi.collections.Field" p:name="self">
             <![CDATA[
       <property name="virtualField">
           subject = {0}
            ]]<bean class="ru.intertrust.cm_sochi.srv.connector.sochi.collections.BuildVirtualField">
        </criteria>
     </filter>
               <filter<property name="subject_partialrealFields">
        <criteria placeholder="where-clause">
            <![CDATA[
           <list>
     subject iLIKE ('%'||{0}||'%')
            ]]>
        </criteria>
    </filter>
    <filter name="fc_subject"><value>self_1</value>
        <criteria placeholder="where-clause">
               <![CDATA[
             <value>Module</value>
       fc_subject ilike '%'||{0}||'%'
                ]]>
        </criteria>
    </filter>
    <filter name="fc_subject_partial">
        <criteria placeholder="where-clause">
            <![CDATA[
                    fc_subject ilike '%'||{0}||'%'
                ]]>
        </criteria>
    </filter>
    <filter name="fc_depId">
        <criteria placeholder="where-clause">
            <![CDATA[
                    fc_depId ilike '%'||{0}||'%'
                ]]>
        </criteria>
    </filter>
    <filter name="fc_depId_partial">
        <criteria placeholder="where-clause">
            <![CDATA[
                    fc_depId ilike '%'||{0}||'%'
                ]]>
        </criteria>
    </filter>
    <filter name="moduleName">
        <criteria placeholder="where-clause">
            <![CDATA[
                    moduleName LIKE {0}
                ]]>
        </criteria>
    </filter>
    <filter name="CQSEARCH">
        <criteria placeholder="where-clause">
            <![CDATA[(lower(fc_subject) like ('%' || lower({0}) || '%'))]]>
        </criteria>
    </filter>
</collection>
Блок кода
languagexml
titleБин кастомной коллекции
collapsetrue
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:p="http://www.springframework.org/schema/p" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans-3.2.xsd" default-lazy-init="true">
    <bean id="Inventory_(vw_cmj_all_case)Metadata" class="ru.intertrust.cm_sochi.srv.connector.sochi.collections.CollectionMetadataNew" p:caseSensitiveFieldNames="true">
<value>self_2</value>
                  <constructor-arg>
            <list value-type="ru.intertrust.cm_sochi.srv.connector.sochi.collections.Field">
     <value>ID</value>
           <bean class="ru.intertrust.cm_sochi.srv.connector.sochi.collections.Field" p:name="self">
                       <property name="virtualField">
 <value>created_date</value>
                            <bean class="ru.intertrust.cm_sochi.srv.connector.sochi.collections.BuildVirtualField">
        <value>self_3</value>
                       <property name="realFields">
        </list>
                        <list>
    </property>
                            <property    <value>self_1</value>name="pattern" value="<id>([0-9]{16}):([0-9A-F]{32})</>" />
                            <property        <value>Module</value>name="separator" value="" />
                            <property        <value>self_2</value>name="emptySeparator" value="true" />
                        </bean>
            <value>ID</value>
        </property>
                </bean>
            <value>created_date</value>
    <bean class="ru.intertrust.cm_sochi.srv.connector.sochi.collections.Field"        p:name="fc_subject" p:filter="fc_subject" p:sortOrder="ASCENDING">
                       <value>self_3</value><property name="virtualField">
                        <bean class="ru.intertrust.cm_sochi.srv.connector.sochi.collections.BuildVirtualField" p:name="fc_subject">
      </list>
                        <property name="realFields">
    </property>
                            <property name="pattern" value="<id>([0-9]{16}):([0-9A-F]{32})</>" />
<list>
                                 <property name="separator" value="" />
 <value>fc_subject</value>
                                </list>
                       <property name="emptySeparator" value="true" />     </property>
                        </bean>
                    </property>
                </bean>
                <bean class="ru.intertrust.cm_sochi.srv.connector.sochi.collections.Field" p:name="fc_subject" p:filter="fc_subject" p:sortOrder="ASCENDING">

                      p:name="MODULE"    <property name="virtualField">
        p:sortOrder="ASCENDING" p:filter="MODULE"/>
                <bean class="ru.intertrust.cm_sochi.srv.connector.sochi.collections.BuildVirtualFieldField" p:name="fcinventory_subjectobj">
                            <property name="realFieldsvirtualField">
                                <list>
                                    <value>fc_subject</value>
  <bean class="ru.intertrust.cm_sochi.srv.connector.sochi.collections.BuildVirtualField">
                              </list>
   <property name="realFields">
                         </property>
        <list>
                </bean>
                    <<value>self_1</property>value>
                </bean>
                <bean class="ru.intertrust.cm_sochi.srv.connector.sochi.collections.Field"
   <value>Module</value>
                   p:name="MODULE" p:sortOrder="ASCENDING" p:filter="MODULE"/>
                <bean class="ru.intertrust.cm_sochi.srv.connector.sochi.collections.Field" p:name="inventory_obj">    <value>self_2</value>
                    <property name="virtualField">
               <value>ID</value>
         <bean class="ru.intertrust.cm_sochi.srv.connector.sochi.collections.BuildVirtualField">
                          <value>created_date</value>
  <property name="realFields">
                                  <list><value>self_3</value>
                                    <value>self<value>invPrefix_1<tag</value>
                                    <value>Module<<value>invPrefix</value>
                                    <value>self_2<3</value>
                                    <value>ID<<value>subject_tag</value>
                                    <value>created_date<<value>subject</value>
                                    <value>self_3</value>
                                    <value>invPrefix<value>invNumber_tag</value>
                                    <value>invPrefix<<value>invNumber</value>
                                    <value>self_3</value>
                                </list>
    <value>subject_tag</value>
                        </property>
             <value>subject</value>
               <property name="separator" value="" />
                   <value>self_3</value>
         <property name="emptySeparator" value="true" />
                        <value>invNumber_tag<</value>bean>
                    </property>
                <value>invNumber<</value>bean>
                <bean class="ru.intertrust.cm_sochi.srv.connector.sochi.collections.Field" p:name="fc_depId" p:filter="fc_depId" p:sortOrder="ASCENDING" p:categorized="true" p:sortPriority="0" />
             <value>self_3</value></list>
        </constructor-arg>
    </bean>
</beans>

Создать описатель коллекции для UI-интерфейса

Блок кода
languagexml
titleДескриптор
collapsetrue
<?xml version='1.0' encoding='UTF-8'?>
<catalog xmlns="http://www.intertrust.ru/schema/palette/cat-ui">
	<custom-descriptor                 </list>
          ident="Inventory" view="(vw_cmj_all_case)" id="inventory-all-case" name="Список дел для диалога" style="default">
  		<help id="99778660" />
  		<builder name="ru.intertrust.cmj.af.collections.impl.BuilderDominoViewCQSearch" />
  		<table>
    		<columns>
      			<column-ref ref="fc_subject" filter="true"/>
          </property>			<column-ref ref="inventory_obj" />
      			<column-ref ref="self" />
     			<column-ref ref="fc_depId" category="true" />
    		</columns>
  		</table>
	</custom-descriptor>
</catalog>
Блок кода
languagexml
titleЭлементы коллекции
<?xml version='1.0'     <propertyencoding='UTF-8'?>
<catalog xmlns="http://www.intertrust.ru/schema/palette/cat-ui"> 
	<column name="separatorinvPrefix" valuesubject="" />
                            <property name="emptySeparator" value="true" /${catalog.column.invPrefix.subject:Префикс}" extends="string">
    	<meta>
      		<documentation>Префикс дела</documentation>
             	</bean>meta>
                    	</property>column>
  	<column name="invNumber" subject="${catalog.column.invPrefix.subject:Номер}" extends="string">
    	<meta>
      		<documentation>Номер <дела</bean>documentation>
    	</meta>
  	</column>
  	<complex-column        <bean class="ru.intertrust.cm_sochi.srv.connector.sochi.collections.Field" p:name="fc_depId" p:filter="fc_depId" p:sortOrder="ASCENDING" p:categorized="true" p:sortPriority="0" />
 extends="object" subject="${catalog.complex-column.inventory_obj.subject:Объект дела}" name="inventory_obj" schema-ref="InventoryDoc">
    	<meta>
      		<documentation>Объект документа</documentation>
    	</list>meta>
    	<column-ref ref="invPrefix" />
    	<column-ref ref="subject" </constructor-arg>/>
    	<column-ref ref="id" />
    	<column-ref ref="invNumber"/>
  	</bean>complex-column>
</beans>catalog>
Блок кода
languagexml
titleДескрипторПрограммная коллекция
collapsetrue
<?xml version='1.0' encoding='UTF-8'?>
<catalog xmlns="http://www.intertrust.ru/schema/palette/cat-ui">
<custom-descriptor ident="Inventory" view="(vw_cmj_all_case)	<view parent-ref="ProgrammedNavigator" id="inventory-all-case" name="Список дел для диалога" style="default">
  <help id="99778660" />
  <builder name="ru.intertrust.cmj.af.collections.impl.BuilderDominoViewCQSearch" />
  <table>
    <columns>
      <column-ref ref="fc_subject" filter="true"/${catalog.view.inventory_all_case.name:Список номенклатурных дел}" position="10011">
      <column	<descriptor-ref ref="inventory_obj" -all-case"/>
      <column-ref ref="self" />	<source>
      <column-ref ref="fc_depId" category="true" 		<module ident="Inventory"/>
    	</columns>source>
  	</table>view>
</custom-descriptor>
</catalog>catalog>

Подключить коллекцию дел к справочнику

Блок кода
languagexml
titleПрограммная коллекцияcollapsetrueПодключение справочника
<?xml version='1.0' encoding='UTF-8'?>
<catalog<ui xmlns="http://www.intertrust.ru/schema/palette/cat-ui">
  <view parent-ref="ProgrammedNavigator" id="inventory-all-case"tn-ui">
  <directories>
		<custom-collection name="${catalog.view.inventory_all_caseui.directories.custom-collection.inventory-dictionary.name:Список номенклатурныхНоменклатура дел}" positionid="10011inventory-all-case">
    <descriptor		<view-ref ref="inventory-all-case"/>
		</custom-collection>
  </directories>
</ui>

Подключить справочник Дел к полю

Блок кода
languagexml
titleПодключение справочника
<?xml  <source>
      <module ident="Inventory"/>
    </source>
  </view>
</catalog>
Блок кода
  <custom-collectionversion='1.0' encoding='UTF-8'?>
<ui xmlns="http://www.intertrust.ru/schema/palette/tn-ui">
 	<!--form-->
 		<!--section-->
 			<field attribute-ref="case" name="${ui.form.directoriesRkkResourceInputForm.custom-collection.inventory-dictionaryfield.case.name: Номенклатура дел}" id="inventory-all-caseДело:}">
				<!-- Визуализация -->
				<appearance importance="normal" multiline="true" open-form="newTab">
      <view-ref ref="inventory-all-case"/>
    </custom-collection>
Блок кода
languagexml
titleЭлементы коллекции
  <column name="invPrefix" subject="${catalog.column.invPrefix.subject:Префикс}" extends="string"> 	<label-style>
    <meta>
      <documentation>Префикс дела</documentation>
    </meta>
  </column>
  <column name="invNumber" subject="${catalog.column.invPrefix.subject:Номер}" extends="string">
  	<style id="tunBorderedField"/>
         <meta>
      <documentation>Номер дела</documentation>
    </meta>
label-style>
      </column>
  <complex-column extends="object" subject="${catalog.complex-column.inventory_obj.subject:Объект дела}" name="inventory_obj" schema-ref="InventoryDoc">
    <meta></appearance>
				
				<!--Подключение справочника-->
      <documentation>Объект  документа</documentation>
    </meta>
     <column-ref ref="invPrefix" />
    <column-ref ref="subject" />
    <column-ref ref="id" />
    <column-ref ref="invNumber"/>
  </complex-column><directories relation="inventory-all-case" limit-livesearch="sys-current">
					<directory-category-custom-coll attribute-ref="regPlaceID" ref="inventory-all-case"/>
				</directories>

             </field>
	 	<!--section-->
	<!--form-->
</ui>
панель
title<Название видео>