HoleFoods.KPISQL
class HoleFoods.KPISQL extends %DeepSee.KPI
Example KPI definition using SQL statements against the HoleFoods transaction data.Method Inventory
Methods
classmethod %OnGetListingSQL(ByRef pFilters As %String, ByRef pSelection As %String, pListingName As %String = "") as %String
This callback, if implemented, returns the text of an SQL query used to provide
a "detail listing" for this KPI.
pFilters is an array of current filter values: pFilters(name)=value.
pSelection is an array containing information about the current selected items in the pivot. It contains 2 values:
pSelection("selectedRange") contains the current selected cells in the pivot as a string in the form "startRow,startCol,endRow,endCol" (1-based). "" if no cells are selected.
pSelection("rowValues") contains a csv-list of "row" values for the selected rows in the pivot (similar to the $$$VALUELIST value used for OpenWindow URLs. This may contain "\," for "," within the data values.
pListingName is the name of the listing to display. This is reserved for future use.
This method is simply a convenient alternative to the %OnGetListingResultSet() method. It takes precedence over the %OnGetListingResultSet() method.
pFilters is an array of current filter values: pFilters(name)=value.
pSelection is an array containing information about the current selected items in the pivot. It contains 2 values:
pSelection("selectedRange") contains the current selected cells in the pivot as a string in the form "startRow,startCol,endRow,endCol" (1-based). "" if no cells are selected.
pSelection("rowValues") contains a csv-list of "row" values for the selected rows in the pivot (similar to the $$$VALUELIST value used for OpenWindow URLs. This may contain "\," for "," within the data values.
pListingName is the name of the listing to display. This is reserved for future use.
This method is simply a convenient alternative to the %OnGetListingResultSet() method. It takes precedence over the %OnGetListingResultSet() method.
This callback, if implements, lets a subclass provide an SQL statement to fetch data for this KPI.
Inherited Members
Inherited Properties
- %filterValues
- %fromCache
- %id
- %message
- %rangeLower
- %rangeUpper
- %seriesCount
- %seriesNames
- %source
- %thresholdLower
- %thresholdUpper
Inherited Methods
- %AddToSaveSet()
- %CheckResource()
- %ClassIsLatestVersion()
- %ClassName()
- %ClearKPICache()
- %ComputeKPICacheKey()
- %ComputeKPITimestamp()
- %ConstructClone()
- %CreateKPIController()
- %CreateModelInstance()
- %DeleteModel()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %Extends()
- %GetFilterDisplayValue()
- %GetFilterKey()
- %GetFilterLogicalValue()
- %GetJSValidationCode()
- %GetKPICaption()
- %GetKPICaptionName()
- %GetKPIClassTimeStamp()
- %GetKPIName()
- %GetKPIPropertyCaption()
- %GetKPIValue()
- %GetKPIValueArray()
- %GetMDXContextFilter()
- %GetMDXForFilter()
- %GetMDXText()
- %GetMembersForFilter()
- %GetParameter()
- %GetPropertyInfo()
- %GetSQLForFilter()
- %GetSQLText()
- %GetSourceType()
- %InvokeAction()
- %IsA()
- %IsAsync()
- %IsCacheable()
- %IsModified()
- %IsPublic()
- %IsReadOnly()
- %LoadKPIFromCache()
- %New()
- %NormalizeObject()
- %ObjectModified()
- %OnComputeKPITimestamp()
- %OnCopyDataFromModel()
- %OnCopyDataToModel()
- %OnDashboardAction()
- %OnDeleteModel()
- %OnDeleteSource()
- %OnExecute()
- %OnGetActionList()
- %OnGetFilterList()
- %OnGetFilterMembers()
- %OnGetKPICaption()
- %OnGetKPIPropertyInfo()
- %OnGetListingResultSet()
- %OnGetMDX()
- %OnGetPropertyInfo()
- %OnInvokeAction()
- %OnLoadKPI()
- %OnLoadKPIFromCache()
- %OnLoadModel()
- %OnNewSource()
- %OnOpenSource()
- %OnSaveKPIToCache()
- %OnSaveSource()
- %OnStoreModel()
- %OnSubmit()
- %OpenModel()
- %OriginalNamespace()
- %PackageName()
- %PrintValue()
- %RemoveFromSaveSet()
- %SaveKPIToCache()
- %SaveModel()
- %SerializeObject()
- %SetModified()
- %SetPercentComplete()
- %SubmitHandler()
- %TestKPICache()
- %ValidateKPICache()
- %ValidateObject()
- ConvertParameter()
- Decrypt()
- Encrypt()
- EscapeHTML()
- EscapeURL()
- HyperEventCall()
- HyperEventHead()
- Include()
- InsertHiddenField()
- InsertHiddenFields()
- IsPrivate()
- Link()
- OnHTTPHeader()
- OnPage()
- OnPageError()
- OnPostHTTP()
- OnPostHyperEvent()
- OnPreHTTP()
- OnPreHyperEvent()
- Page()
- QuoteJS()
- RewriteURL()
- ShowError()
- StartTimer()
- StopTimer()
- ThrowError()
- UnescapeHTML()
- UnescapeURL()