2.7 Custom Columns
2.7.1 Description
FOCUS supports the inclusion of custom columns to facilitate reporting capability that is not covered by the columns included in the specification.
2.7.2 Directly Dependent Columns
x_CustomColumn
2.7.3 Example SQL Query
Example SQL Query
SELECT
BillingPeriodStart,
x_CustomColumn,
SUM(BilledCost) AS TotalBilledCost,
FROM focus_data_table
WHERE ServiceName = ?
AND BillingPeriodStart >= ? AND BillingPeriodStart < ?
GROUP BY
BillingPeriodStart,
x_CustomColumn
ORDER BY MonthlyCost DESC