ActionField1108

Beschrijving: Insert a StandardArticleWarehouseSkillCategory for this ArticleWarehouse. Custom: Nee

Propertiesbewerken

XMLbewerken

<Workflow Name="ActionField1108" Version="2025.07.28" WorkflowType="Standard" xmlns="urn:Ultimo.Framework.Workflow-mapping">
	<Security EditLevel="10" ViewLevel="20" UserContentLevel="30" />
	<Description>Insert a StandardArticleWarehouseSkillCategory for this ArticleWarehouse.</Description>
	<Properties>
		<Property	Name="ArticleWarehouse"								Type="ArticleWarehouse"							Accessor="Root"		Direction="In" />

		<Property	Name="SelectedSkillCategory"						Type="SkillCategory"							Accessor="Internal" />
		<Property	Name="StandardArticleWarehouseSkillCategory"		Type="StandardArticleWarehouseSkillCategory"	Accessor="Internal" />
		<Property	Name="StandardArticleWarehouseSkillCategoryCount"	Type="Int64"									Accessor="Internal" />
		<Property	Name="WhereClause"									Type="UltimoString"								Accessor="Internal"						Default="not exists (select StAwhsSkcSkcId from dba.StdArticleWareHouseSkillCat where StAwhsSkcArtId = '${ArticleWarehouse.Id.Article.Id}' and SkcId = StdArticleWarehouseSkillCat.StAwhsSkcSkcId)" />
	</Properties>
	<Execution>
		<UserContent Name="Pre" />

		<Dialog Name="ArticleWarehouse_GetSkillCategory" TitleCode="SKILLCATEGORY_ASSIGN">
			<Container Border="True">
				<SelectionList Name="SelectedSkillCategory" OutputProperty="${SelectedSkillCategory}" ColumnName="SkcId" Required="True" LabelCode="SKILLCATEGORY" SqlWhereClause="${WhereClause}" />
			</Container>
		</Dialog>

		<Transaction>
			<GetCount Name="Check if StandardArticleWarehouseSkillCategory already exists" Type="StandardArticleWarehouseSkillCategory" OutputProperty="${StandardArticleWarehouseSkillCategoryCount}">
				<Filters>
					<PropertyFilter	PropertyName="Id.ArticleWarehouse"	Operator="="		PropertyValue="${ArticleWarehouse}" />
					<PropertyFilter	PropertyName="Id.SkillCategory"		Operator="="		PropertyValue="${SelectedSkillCategory}" />
				</Filters>
			</GetCount>

			<Validation Name="Validate if StandardArticleWarehouseSkillCategory already exists" Condition="${StandardArticleWarehouseSkillCategoryCount} == 0" MessageCode="2316">
				<Parameter	Name="ArticleWarehouse"	Direction="In"		Value="${ArticleWarehouse}" />
				<Parameter	Name="SkillCategory"	Direction="In"		Value="${SelectedSkillCategory}" />
			</Validation>

			<Insert Name="Add StandardArticleWarehouseSkillCategory" ObjectType="StandardArticleWarehouseSkillCategory" OutputProperty="${StandardArticleWarehouseSkillCategory}">
				<Parameter	Name="Id.ArticleWarehouse"	Direction="In"		Value="${ArticleWarehouse}" />
				<Parameter	Name="Id.SkillCategory"		Direction="In"		Value="${SelectedSkillCategory}" />
			</Insert>
		</Transaction>

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