Tag: ExplodeTimes

The ExplodeTimes function expands (or explodes) times in the grid.


<ExplodeTimes ColumnID="receivedDateTime"/>
XML

Tag Attributes

Attributes Attributes ValuesValue DescriptionComment
TargetN/AIdentifies the grid by name.
Do not use, or use "grid" for main grid.
No target necessary in sapio365.
N/A
ColumnIDN/AColumn UID shows the columns that aren't visible - selects the column like <SelectColumn ColumnID="..."/>N/A

A column must be selected.

Example Script


<ytriaAutomation Application="sapio365">
	<ShowMyDataMail>
		<Select Lines="ByValue">
			<SetParam ColumnID="senderName" Value="Alex Wilber"/>
		</Select>
		<SelectColumn ColumnID="toRecipientsAddresses"/>
		<ExplodeDates ColumnID="receivedDateTime"/>
		<ExplodeTimes ColumnID="receivedDateTime"/>
		<Export>
			<SetParam Field="FileOutput" Value="ASCII"/>
			<SetParam Field="Mode" Value="Create"/>
			<SetParam Field="ExportType" Value="HTML"/>
			<SetParam Field="ChildrenOnly" Value="False"/>
			<SetParam Field="ExpandAllGroups" Value="False"/>
			<SetParam Field="OpenFileOnceGenerated" Value="True"/>
			<SetParam Field="SelectedRowsOnly" Value="True"/>
			<SetParam Field="ExcelSheetName" Value=""/>
			<SetParam Field="ExcelTemplate" Value=""/>
			<SetParam Field="FilePath" Value="AlexWilberMails-Exploded"/>
		</Export>
		<ImplodeAllDateTimes/>
		<ImplodeAllMultivalues/>
	</ShowMyDataMail>
</ytriaAutomation>
XML