%BI.KnowledgeCategory
persistent class %BI.KnowledgeCategory extends %Library.Persistent, %BI.Adaptor
SQL Table Name: %BI.KnowledgeCategory
Property Inventory
- ACL
- CategoryConsultant
- CategoryDescription
- CategoryTitle
- HelpDesk
- KnowledgeThread
- LastPostedDt
- ParentCategory
- PostOrdering
- PreModule
- ShowPostTitle
- SubModule
- ThreadOrder
- ThreadOrderBy
- ThreadOrdering
Properties
property ACL as %String (MAXLEN = 10000);
Property methods: ACLDisplayToLogical(), ACLGet(), ACLGetStored(), ACLIsValid(), ACLLogicalToDisplay(), ACLLogicalToOdbc(), ACLNormalize(), ACLSet()
property CategoryConsultant as %String (TRUNCATE = 1);
Property methods: CategoryConsultantDisplayToLogical(), CategoryConsultantGet(), CategoryConsultantGetStored(), CategoryConsultantIsValid(), CategoryConsultantLogicalToDisplay(), CategoryConsultantLogicalToOdbc(), CategoryConsultantNormalize(), CategoryConsultantSet()
property CategoryDescription as %String (MAXLEN = 200, TRUNCATE = 1);
Property methods: CategoryDescriptionDisplayToLogical(), CategoryDescriptionGet(), CategoryDescriptionGetStored(), CategoryDescriptionIsValid(), CategoryDescriptionLogicalToDisplay(), CategoryDescriptionLogicalToOdbc(), CategoryDescriptionNormalize(), CategoryDescriptionSet()
property CategoryTitle as %String (TRUNCATE = 1);
Property methods: CategoryTitleDisplayToLogical(), CategoryTitleGet(), CategoryTitleGetStored(), CategoryTitleIsValid(), CategoryTitleLogicalToDisplay(), CategoryTitleLogicalToOdbc(), CategoryTitleNormalize(), CategoryTitleSet()
property HelpDesk as %Boolean;
Property methods: HelpDeskDisplayToLogical(), HelpDeskGet(), HelpDeskGetStored(), HelpDeskIsValid(), HelpDeskLogicalToDisplay(), HelpDeskNormalize(), HelpDeskSet()
relationship KnowledgeThread as array of %BI.KnowledgeThread [ InitialExpression = $listbuild("%BI.KnowledgeThread","KnowledgeCategory",+$this,"children",1,1) , Transient , Inverse = KnowledgeCategory , Cardinality = children ];
Property methods: KnowledgeThreadGet(), KnowledgeThreadGetObject(), KnowledgeThreadGetObjectId(), KnowledgeThreadGetSwizzled(), KnowledgeThreadIsEmpty(), KnowledgeThreadIsValid(), KnowledgeThreadNewObject(), KnowledgeThreadRClose(), KnowledgeThreadRExec(), KnowledgeThreadRFetch(), KnowledgeThreadRelate(), KnowledgeThreadSQLCompute(), KnowledgeThreadSet(), KnowledgeThreadUnRelate()
property LastPostedDt as %String (TRUNCATE = 1);
Property methods: LastPostedDtDisplayToLogical(), LastPostedDtGet(), LastPostedDtGetStored(), LastPostedDtIsValid(), LastPostedDtLogicalToDisplay(), LastPostedDtLogicalToOdbc(), LastPostedDtNormalize(), LastPostedDtSet()
property ParentCategory as %String (TRUNCATE = 1);
Property methods: ParentCategoryDisplayToLogical(), ParentCategoryGet(), ParentCategoryGetStored(), ParentCategoryIsValid(), ParentCategoryLogicalToDisplay(), ParentCategoryLogicalToOdbc(), ParentCategoryNormalize(), ParentCategorySet()
property PostOrdering as %String (TRUNCATE = 1);
Property methods: PostOrderingDisplayToLogical(), PostOrderingGet(), PostOrderingGetStored(), PostOrderingIsValid(), PostOrderingLogicalToDisplay(), PostOrderingLogicalToOdbc(), PostOrderingNormalize(), PostOrderingSet()
property PreModule as %String (MAXLEN = 10000);
Property methods: PreModuleDisplayToLogical(), PreModuleGet(), PreModuleGetStored(), PreModuleIsValid(), PreModuleLogicalToDisplay(), PreModuleLogicalToOdbc(), PreModuleNormalize(), PreModuleSet()
property ShowPostTitle as %Boolean;
Property methods: ShowPostTitleDisplayToLogical(), ShowPostTitleGet(), ShowPostTitleGetStored(), ShowPostTitleIsValid(), ShowPostTitleLogicalToDisplay(), ShowPostTitleNormalize(), ShowPostTitleSet()
property SubModule as %String (MAXLEN = 10000);
Property methods: SubModuleDisplayToLogical(), SubModuleGet(), SubModuleGetStored(), SubModuleIsValid(), SubModuleLogicalToDisplay(), SubModuleLogicalToOdbc(), SubModuleNormalize(), SubModuleSet()
property ThreadOrder as array of %String (TRUNCATE = 1);
Property methods: ThreadOrderBuildValueArray(), ThreadOrderCollectionToDisplay(), ThreadOrderCollectionToOdbc(), ThreadOrderDisplayToCollection(), ThreadOrderDisplayToLogical(), ThreadOrderGet(), ThreadOrderGetObject(), ThreadOrderGetObjectId(), ThreadOrderGetStored(), ThreadOrderGetSwizzled(), ThreadOrderIsValid(), ThreadOrderLogicalToDisplay(), ThreadOrderLogicalToOdbc(), ThreadOrderNormalize(), ThreadOrderOdbcToCollection(), ThreadOrderSet(), ThreadOrderSetObject(), ThreadOrderSetObjectId()
property ThreadOrderBy as %String (TRUNCATE = 1);
Property methods: ThreadOrderByDisplayToLogical(), ThreadOrderByGet(), ThreadOrderByGetStored(), ThreadOrderByIsValid(), ThreadOrderByLogicalToDisplay(), ThreadOrderByLogicalToOdbc(), ThreadOrderByNormalize(), ThreadOrderBySet()
property ThreadOrdering as %String (TRUNCATE = 1);
Property methods: ThreadOrderingDisplayToLogical(), ThreadOrderingGet(), ThreadOrderingGetStored(), ThreadOrderingIsValid(), ThreadOrderingLogicalToDisplay(), ThreadOrderingLogicalToOdbc(), ThreadOrderingNormalize(), ThreadOrderingSet()
Queries
query CountNullCat(ID As %String)
SQL Query:
SELECT Count(%ID) AS nullcatcnt FROM KnowledgeCategory WHERE (ParentCategory is NULL)
SELECT Count(%ID) AS nullcatcnt FROM KnowledgeCategory WHERE (ParentCategory is NULL)
query CountSubCat(ID As %String)
SQL Query:
SELECT Count(%ID) AS subcatcnt FROM KnowledgeCategory WHERE (ParentCategory = :ID)
SELECT Count(%ID) AS subcatcnt FROM KnowledgeCategory WHERE (ParentCategory = :ID)
query GetCatConsultant(number As %Integer)
SQL Query:
SELECT CategoryConsultant FROM KnowledgeCategory WHERE %ID = :number
SELECT CategoryConsultant FROM KnowledgeCategory WHERE %ID = :number
query GetCatIdByName(name As %String)
SQL Query:
SELECT %Id FROM %BI.KnowledgeCategory WHERE CategoryTitle = :name
SELECT %Id FROM %BI.KnowledgeCategory WHERE CategoryTitle = :name
query GetSubCat(ID As %String)
SQL Query:
SELECT %ID as ID FROM KnowledgeCategory WHERE (ParentCategory = :ID) ORDER BY CategoryTitle
SELECT %ID as ID FROM KnowledgeCategory WHERE (ParentCategory = :ID) ORDER BY CategoryTitle
SQL Query:
SELECT %ID,CategoryTitle,CategoryDescription,CategoryConsultant,HelpDesk FROM %BI.KnowledgeCategory WHERE ParentCategory = :number ORDER BY CategoryTitle
SELECT %ID,CategoryTitle,CategoryDescription,CategoryConsultant,HelpDesk FROM %BI.KnowledgeCategory WHERE ParentCategory = :number ORDER BY CategoryTitle
SQL Query:
SELECT %ID,CategoryTitle,CategoryDescription,CategoryConsultant,HelpDesk FROM %BI.KnowledgeCategory WHERE ParentCategory is NULL ORDER BY CategoryTitle
SELECT %ID,CategoryTitle,CategoryDescription,CategoryConsultant,HelpDesk FROM %BI.KnowledgeCategory WHERE ParentCategory is NULL ORDER BY CategoryTitle
Indexes
index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()
Inherited Members
Inherited Methods
- %AddToSaveSet()
- %AddToSyncSet()
- %BMEBuilt()
- %CheckConstraints()
- %CheckConstraintsForExtent()
- %ClassIsLatestVersion()
- %ClassName()
- %ComposeOid()
- %ConstructClone()
- %Delete()
- %DeleteExtent()
- %DeleteId()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Exists()
- %ExistsId()
- %Extends()
- %GUID()
- %GUIDSet()
- %GetLock()
- %GetParameter()
- %GetSwizzleObject()
- %Id()
- %InsertBatch()
- %IsA()
- %IsModified()
- %IsNull()
- %KillExtent()
- %KillExtentData()
- %LoadFromMemory()
- %LockExtent()
- %LockId()
- %New()
- %NormalizeObject()
- %ObjectIsNull()
- %ObjectModified()
- %Oid()
- %OnAfterSave()
- %OnBeforeAddToSync()
- %OnDelete()
- %OnDetermineClass()
- %Open()
- %OpenId()
- %OriginalNamespace()
- %PackageName()
- %PhysicalAddress()
- %PurgeIndices()
- %Reload()
- %RemoveFromSaveSet()
- %ResolveConcurrencyConflict()
- %RollBack()
- %Save()
- %SaveDirect()
- %SaveIndices()
- %SerializeObject()
- %SetModified()
- %SortBegin()
- %SortEnd()
- %SyncObjectIn()
- %SyncTransport()
- %UnlockExtent()
- %UnlockId()
- %ValidateIndices()
- %ValidateObject()
- DrillDownData()
- DrillDownList()
- HiDebug()
- HiRebuild()
- ListData()
- ListHeader()
- SaveAIData()
- SelectBuild()
- SimQueryData()
- SpeedOnAfterSave()
- SpeedOnDelete()
- zzBuild()
- zzBuildDebug()
- zzBuildOne()
- zzBuildProcess()
- zzCompress()
- zzDeleteAllIdx()
- zzDeleteCondition()
- zzFastRebuild()
- zzInitProc()
- zzQBuildOne()
- zzSBuild()
- zzSBuildProcess()
- zzTime()
- zzTimeRanges()
Storage
Storage Model: CacheStorage (%BI.KnowledgeCategory)
^BI.KnowledgeCategoryD(ID) | = | %%CLASSNAME
CategoryTitle
ParentCategory
CategoryConsultant
CategoryDescription
LastPostedDt
PostOrdering
ThreadOrderBy
ThreadOrdering
HelpDesk
ShowPostTitle
ACL
SubModule
PreModule
|
^BI.KnowledgeCategoryD(ID,"ThreadOrder",n) | = | ThreadOrder(n) |