I have request from business to create report that will be showing all instances , which current logged user had task to do in the past. Some user can have more than one task in workflow. Is it possible to prepare such report and in SQL filter make a join statement similiar to this:
SELECT * FROM
(SELECT *,
ROW_NUMBER() OVER(PARTITION BY [WFD_ID] ORDER BY WFD_ID DESC) rn
FROM [BPS_ConfigProd_Content].[dbo].[WFElements]
LEFT JOIN WFElementTasks ON WFElementTasks.WFT_WFDID=WFD_ID WHERE WFT_USER='user login'
) AS tbl
WHERE rn=1