This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Custom User Interface Form

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.