Comments by keyword and score

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

DECLARE @UserId int = ##UserId##
DECLARE @VoteFloor int = ##MinimumScore##
DECLARE @KeyWord nvarchar(64) = ##ContainedText:string##

select Score, Text as [Comment Text], PostId as [Post Link], CreationDate as Date
from Comments 
where UserId = @UserId and Text LIKE @KeyWord and Score >= @VoteFloor ORDER BY Score DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results