Element Details: Sql+Time+Period+Column
 Back


Available in: Logi Info Source code name: SqlTimePeriodColumn

The ActiveSQL SqlTimePeriodColumn adds a new column in the DataLayer that represents a time period such as year, quarter, month, etc. The column can be used like any other column.

Set the ID attribute to the name of the new column.

Set the DataColumn attribute to the name of a column that has a date value.

Element Group:Add and Replace Columns



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
DataColumn
UserDefined
(Required) The name of a data field/column returned from the DataLayer.
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
TimePeriod
Year
Week
Second
Quarter
MonthName
MonthAbbreviation
Month
Minute
LastDayOfYear
LastDayOfWeek
LastDayOfQuarter
LastDayOfMonth
LastDayOfFiscalYear
LastDayOfFiscalQuarter
Hour
FiscalYear
FiscalQuarter
FirstSecondOfMinute
FirstMinuteOfHour
FirstHourOfDay
FirstDayOfYear
FirstDayOfWeek
FirstDayOfQuarter
FirstDayOfMonth
FirstDayOfFiscalYear
FirstDayOfFiscalQuarter
DayOfYear
DayOfWeekName
DayOfWeekAbbreviation
DayOfWeek
DayOfMonth
Date
(Required) The time period.



PARENT ELEMENTS

Click element to drill down for more information.

DataLayer.ActiveSQL Sql Query


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top