1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for developers and end users of the Sitecore CMS and multichannel marketing software

SELECT TOP ##Limit:int?50000##
  c.Text AS [Text],
  'site://posts/comments/' + CONVERT(nvarchar(20),c.Id) AS [Comment Permalink]
FROM Comments c
WHERE
  LEN(Text) >= ##MinCommentLength:int?0## AND
  LEN(Text) <= ##MaxCommentLength:int?500## + LEN('@##UsernameWithoutSpaces## ') AND
  (
    LOWER(Text) LIKE LOWER('@##UsernameWithoutSpaces## %')
  ) AND
  c.CreationDate < DATEADD(dd, -##MinCommentAgeDays:int?0##, GETDATE())
ORDER BY c.CreationDate ASC

fork query

edited nov 30 19

created nov 30 19 Samuel Liew