DeepSee.Model.KPIs.DemoSQL
class DeepSee.Model.KPIs.DemoSQL extends %DeepSee.KPI
This KPI class uses an SQL query and defines one filter.To see the full KPI definition, open this class in Studio.
Method Inventory
Parameters
parameter DOMAIN = PATIENTSAMPLE;
Inherited description: Localization domain.
DataModel classes that wish to support localization must provide a value for this
within subclasses.
Methods
This callback defines the basic SQL query and also checks for the current values
in the filter. The callback adds an SQL WHERE clause with one of the following forms,
depending on the user's selections:
- WHERE HomeCity->PostalCode = zip_code_selected_by_user
- WHERE HomeCity->PostalCode IN (zip_code_1,zip_code_2,...)
- WHERE HomeCity->PostalCode <> zip_code_selected_by_user
- WHERE HomeCity->PostalCode NOT IN (zip_code_1,zip_code_2,...)
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()
- %OnGetListingSQL()
- %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()