Previous Topic
Select Time Interval Dialog
The Select Time Interval dialog helps you to specify how a group element will be created based on the specified DBField whose data type is Timestamp/DateTime. It appears when you drag a DBField of the Timestamp/DateTime data type from the Resource Objects panel to the Business View panel in the Business View Editor.
The following are details about options in the dialog:
For Each Year
Specifies to create a group element that uses the expression Year(@MappingName) to retrieve years of the current field as its values. The data type of the group element is Integer.
For Each Quarter
Specifies to create a group element that uses the expression Quarter(@MappingName,Integer) to retrieve quarters of the current field as its values. The data type of the group element is Integer.
For Each Month
Specifies to create a group element that uses the expression Month(@MappingName)to retrieve months of the current field as its values. The data type of the group element is Integer.
For Each Week
Specifies to create a group element that uses the expression WeekOfYear(@MappingName)to retrieve weeks of the current field as its values. The data type of the group element is Integer.
For Each Day
Specifies to create a group element that uses the expression Day(@MappingName)to retrieve days of the current field as its values. The data type of the group element is Integer.
Keep Original
Specifies to create a group element based on the field itself.
OK
Creates the group elements and closes the dialog.
Cancel
Cancels adding group elements and exists the dialog.
Help
Displays the help document about this feature.