Did a user cast a regular dupe, a dupe hammer or diamond mod dupe vote

0

Please login or register to vote for this query.

(click on this box to dismiss)

Sitecore Meta

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

select 
text
from posthistory
cross join string_split(N'0,1,2,3,4,5,6,7',',')
where posthistorytypeid = 10
and comment in (1,101) -- duplicate close reasons
and JSON_value(text, concat(N'$.Voters[', value, N'].Id')) = '##userid:int?337631##'

Enter Parameters

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