persistent class %BI.BlogComment
extends %Persistent, %BI.Adaptor
property DateTime
as %String(TRUNCATE=1);
relationship Post
as %BI.BlogPost [ Inverse = Comment,Cardinality = parent ];
property PostMessage
as %String(MAXLEN=25000,TRUNCATE=1);
property UserName
as %String(TRUNCATE=1);
query ByBlogPostId(blogPostId As %String)
SQL Query
:
SELECT ID,DateTime,PostMessage,UserName,COUNT(*) AS TotalRow FROM BlogComment
WHERE Post->ID = :blogPostId
query CommentQuery()
SQL Query
:
SELECT ID,DateTime,PostMessage,UserName FROM BlogComment