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.