Tag: ExplodeTimes
The ExplodeTimes function expands (or explodes) times in the grid.
<ExplodeTimes ColumnID="receivedDateTime"/>
XML
Tag Attributes
Attributes | Attributes Values | Value Description | Comment |
---|
Target | N/A | Identifies the grid by name. Do not use, or use "grid" for main grid. No target necessary in sapio365. | N/A |
ColumnID | N/A | Column 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