Home > Forum > General > Report with previous user's tasks

Report with previous user's tasks
0

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