ActionField1283

Beschrijving: Export EquipmentMeasurementPointValues (meter readings) of Equipment (Meter) from Ultimo to Excel. Custom: Nee

Propertiesbewerken

XMLbewerken

<Workflow Name="ActionField1283" Version="2025.07.28" WorkflowType="Standard" xmlns="urn:Ultimo.Framework.Workflow-mapping">
	<Security EditLevel="10" ViewLevel="20" UserContentLevel="30" />
	<Description>Export EquipmentMeasurementPointValues (meter readings) of Equipment (Meter) from Ultimo to Excel.</Description>
	<Properties>
		<Property	Name="Meter"			Type="Equipment"	Accessor="Root"		Direction="In" />

		<Property	Name="EndDate"			Type="Date"			Accessor="Internal" />
		<Property	Name="ExcelDocument"	Type="Document"		Accessor="Internal" />
		<Property	Name="StartDate"		Type="Date"			Accessor="Internal" />
	</Properties>
	<Execution>
		<UserContent Name="Pre" />

		<Dialog Name="DialogForExport" TitleCode="EXPORTMETERREADINGSTOEXCEL">
			<Container>
				<Date Name="StartDate" OutputProperty="${StartDate}" Required="True" LabelCode="FROMDATE" />

				<Date Name="EndDate" OutputProperty="${EndDate}" Required="True" LabelCode="UNTILDATE" />
			</Container>
		</Dialog>

		<Transaction>
			<CreateDocument Name="UltimoExport" DocumentType="Excel" FileName="Export_Meter_Readings.xls" ConvertHtmlToPlainText="True">
				<DocumentGridPage Name="Export meter readings" PageTitle="Meter readings" Type="EquipmentMeasurementPointValue" ViewfieldConfiguration="default" WriteTechnicalHeader="False">
					<Joins>
						<Join	Name="Id.EquipmentMeasurementPoint"	Alias="equipmentmsr"	Type="InnerJoin" />
						<Join	Name="equipmentmsr.Id.Equipment"	Alias="equipment"		Type="InnerJoin" />
					</Joins>
					<Filters>
						<CombinedFilter FilterOperator="And">
							<BetweenFilter PropertyName="Date" LowValue="=#startofday(${StartDate})" HighValue="=#setdatetime(#getyear(${EndDate}),#getmonth(${EndDate}),#getday(${EndDate}),23, 59)" Comment="Search full days" />
							<PropertyFilter	PropertyName="equipment.Id"	Operator="="		PropertyValue="${Meter.Id}" />
						</CombinedFilter>
					</Filters>
					<Properties>
						<Property Name="equipmentmsr.Id.Id" Alias="MeasurementPoint" Type="Property" />
						<Property Name="Date" Alias="Date" Type="Property" />
						<Property Name="Value" Alias="MeasuredValue" Type="Property" />
						<Property Name="Difference" Alias="Difference" Type="Property" />
					</Properties>
				</DocumentGridPage>
			</CreateDocument>
		</Transaction>

		<Download Name="DownloadDocument" FileName="Export_Meter_Readings.xls" />

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