persistent class %BI.Docs
extends %Persistent
• property ClassName
as %String(MAXLEN=5000,TRUNCATE=1);
• property Content
as %String(MAXLEN=32000,TRUNCATE=1);
• property DisplayType
as %String(DISPLAYLIST=",HTML,Text",TRUNCATE=1,VALUELIST=",H,T");
• property DocId
as %String(TRUNCATE=1);
• property DocLanguage
as %String(MAXLEN=5000,TRUNCATE=1);
• property DocName
as %String(MAXLEN=5000,TRUNCATE=1);
• property DocType
as %String(DISPLAYLIST=",Dimension,Computation,Measure,Subject,Pivot Table,Report",TRUNCATE=1,VALUELIST=",D,C,M,S,P,R");
• property Ico
as %String(TRUNCATE=1);
• property URL
as %String(MAXLEN=5000,TRUNCATE=1);
• query BySALangType(Cls As %String, Doc As %String, Lang As %String, Type As %String)
SQL Query
:
SELECT DocId
FROM %BI.Docs
WHERE ClassName=:Cls AND DocName=:Doc AND DocType=:Type
• query ListAll()
SQL Query
:
SELECT ID,DocType,DocName,ClassName,DocLanguage
FROM %BI.Docs
• query ListAllByLanguage(DocLanguage As %String)
SQL Query
:
SELECT ID,DocType,DocName,ClassName
FROM %BI.Docs
WHERE DocLanguage=:DocLanguage
• index (MainIdx on ClassName,DocType,DocName,DocLanguage,Ico);
