persistent class %BI.BlogPost
extends %Persistent, %BI.Adaptor, %XML.Adaptor
relationship Blog
as %BI.Blog [ Inverse = Post,Cardinality = parent ];
property Category
as %String(TRUNCATE=1);
relationship Comment
as %BI.BlogComment [ Inverse = Post,Cardinality = children ];
property DateTime
as %String(MAXLEN=100,TRUNCATE=1);
property PostMessage
as %String(MAXLEN=25000,TRUNCATE=1);
property PostUser
as %String(MAXLEN=250,TRUNCATE=1);
property SubCategory
as %String(TRUNCATE=1);
property Title
as %String(MAXLEN=250,TRUNCATE=1);
query ByBlogId(BlogID)
SQL Query
:
SELECT ID,PostUser,DateTime,Title,PostMessage,Category FROM BlogPost WHERE Blog->ID=:BlogID
query ListAll()
SQL Query
:
SELECT Category FROM BlogPost