Hello,
I'm trying to make my own user assignment form for a department, following the example of the task “Task -> Assign employees”.
My actions:
- In Schema Extension, I chose «New relation table»
- In «User interface forms» I created a new form (in example was using QER_Department_Assigned_Person)

- Form definition:

<DialogFormDefinition FormatVersion="1.0">
<ComponentDefinitions>
<ComponentDefinition Name="MemberRelation1" >
<Properties>
<Property Name="MNBaseColumnName" Value="UID_Department" />
<Property Name="MNTableName" Value="CCC_Test" />
<Property Name="WhereClause" Value=
"-- only persons which not are exluded
(
UID_Person not in
(
select pibt.UID_Person
from PersonInBaseTree pibt
join BaseTreeExcludesBaseTree beb on pibt.UID_Org = beb.UID_Org
where beb.UID_OrgExcluded = $UID_Department$
)
)
or
-- and additional already assigned persons in order to remove them
UID_Person in
(
select UID_Person
from PersonInBaseTree
where UID_Org = $UID_Department$
)" />
<!--
<Property Name="DisplayFlatPattern" Value="" />
<Property Name="DisplayPattern" Value="" />
<Property Name="RootFilterTableName" Value="" />
<Property Name="RootFilterWhereClause" />
<Property Name="RootFilterMemberWhereClause" />
<Property Name="ShowExtendedProperties" Value="True" />
-->
</Properties>
</ComponentDefinition>
</ComponentDefinitions>
</DialogFormDefinition>
In the Manager, when I select my menu item Task -> Assign Specialist, I get an error.

What am I doing wrong?
Thanks.