1st task

0

Please login or register to vote for this query.

(click on this box to dismiss)

CiviCRM Meta

Q&A about the site for administrators and users of the CiviCRM Constituent Relationship Management software

/*
select * from posts where Id = 356123;
select * from SuggestedEdits where PostId = 356123;
select * from ReviewTasks rt 
inner join ReviewTaskResults rtr 
on rt.Id = rtr.ReviewTaskId
where rt.PostId = 356123;

select * from PostHistory where PostId = 356123;*/

select top 10 PostId, Comment
from (select PostId, Comment,
             row_number() over (order by CreationDate desc) as rownum
             from PostHistory) ph
where rownum = 1;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results