Skip to main content

%BI.KnowledgeCategory

persistent class %BI.KnowledgeCategory extends %Library.Persistent, %BI.Adaptor

SQL Table Name: %BI.KnowledgeCategory

Property Inventory

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)
query CountSubCat(ID As %String)
SQL Query:
SELECT Count(%ID) AS subcatcnt FROM KnowledgeCategory WHERE (ParentCategory = :ID)
query GetCatConsultant(number As %Integer)
SQL Query:
SELECT CategoryConsultant FROM KnowledgeCategory WHERE %ID = :number
query GetCatIdByName(name As %String)
SQL Query:
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
SQL Query:
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

Indexes

index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods

Storage

Storage Model: CacheStorage (%BI.KnowledgeCategory)

^BI.KnowledgeCategoryD(ID)
=
%%CLASSNAME
CategoryTitle
ParentCategory
CategoryConsultant
CategoryDescription
LastPostedDt
PostOrdering
ThreadOrderBy
ThreadOrdering
HelpDesk
ShowPostTitle
ACL
SubModule
PreModule

Storage Model: CacheStorage (%BI.KnowledgeCategory)

^BI.KnowledgeCategoryD(ID,"ThreadOrder",n)
=
ThreadOrder(n)
FeedbackOpens in a new tab