ActionField1689

Beschrijving: Add Department to Yearplan (YearPlanDepartment). Custom: Nee

Propertiesbewerken

XMLbewerken

<Workflow Name="ActionField1689" Version="2025.07.28" WorkflowType="Standard" xmlns="urn:Ultimo.Framework.Workflow-mapping">
	<Security EditLevel="10" ViewLevel="20" UserContentLevel="30" />
	<Description>Add Department to Yearplan (YearPlanDepartment).</Description>
	<Properties>
		<Property	Name="YearPlan"					Type="YearPlan"				Accessor="Root"		Direction="In" />

		<Property	Name="Department"				Type="Department"			Accessor="Internal" />
		<Property	Name="YearPlanDepartment"		Type="YearPlanDepartment"	Accessor="Internal" />
		<Property	Name="YearPlanScenarioCount"	Type="Int64"				Accessor="Internal" />
	</Properties>
	<Execution>
		<UserContent Name="Pre" />

		<Transaction>
			<GetCount Name="YearPlanScenario" Type="YearPlanScenario" OutputProperty="${YearPlanScenarioCount}">
				<Filters>
					<PropertyFilter	PropertyName="Id.YearPlan"	Operator="="		PropertyValue="${YearPlan}" />
				</Filters>
			</GetCount>
		</Transaction>

		<Validation Name="No YearPlanScenario" Condition="${YearPlanScenarioCount} == 0" MessageCode="3289">
			<Parameter	Name="YearPlan"	Direction="In"		Value="${YearPlan}" />
		</Validation>

		<Dialog Name="Dialog_AddYearPlanDepartment" TitleCode="SELECT_DEPARTMENT">
			<Container>
				<SelectionList Name="Department" OutputProperty="${Department}" ColumnName="DepId" ViewfieldConfiguration="Default" SqlWhereClause="DepId not in (select YrpDepDepId from dba.YearPlanDepartment where YrpDepYrpId = '${YearPlan.Id}')" />
			</Container>
		</Dialog>

		<Transaction>
			<Insert Name="Add YearPlanDepartment" ObjectType="YearPlanDepartment" OutputProperty="${YearPlanDepartment}">
				<Parameter	Name="Id.Department"	Direction="In"		Value="${Department}" />
				<Parameter	Name="Id.YearPlan"		Direction="In"		Value="${YearPlan}" />
			</Insert>
		</Transaction>

		<UserContent Name="Post" />
	</Execution>
</Workflow>