Can I assume that the first entry in the "userhistoryitem" for the sprint's "rapid_view" represents the creator?
/* Find Sprint creator */ DECLARE @SPRINT BIGINT -- SELECT @SPRINT = 5416 -- SELECT TOP 1 UH.ID, SP.NAME sprintname, USERNAME creator FROM [My_Jira].[dbo].[userhistoryitem] UH INNER JOIN [My_Jira].[dbo].[AO_60DB71_SPRINT] SP WITH(NOLOCK) ON UH.ENTITYID = CAST(SP.RAPID_VIEW_ID AS NVARCHAR) WHERE SP.ID = @SPRINT;
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG