New folder personalized - Expert Designer

I need to generate a new file (My Desings) containing only my projects (not merged). I am trying to create a new "FolderCustomQuery" but I don't know how to set my user for the system to filter them ... is there a variable to do this?

current statements (designed by our staff)

example statements...

SELECT WORKREQUEST.Id, WORKREQUEST.Name, WORKREQUEST.Description AS WorkRequestDescription,
WORKREQUEST.CustomerName AS Customer, WORKREQUEST.WorkRequestStateId AS "State", WORKREQUEST.EstimatedStartDate,
WORKREQUEST.EstimatedCompleteDate, WORKREQUEST.RequiredCompleteDate, WORKREQUEST.OwnerId AS "UserLogin_Owner: ",
WORKREQUEST.AttachedDesignId, WORKREQUEST.WorkFlowId,
(SELECT DESIGN.Cost FROM DESIGN WHERE DESIGN.Id = WORKREQUEST.AttachedDesignId) AS Currency_DesignCost,
(SELECT COUNT(DESIGN.id) FROM DESIGN WHERE DESIGN.AssociatedWorkRequstId = WORKREQUEST.Id) AS AssociatedWorkRequestCount,
(SELECT DESIGN.FORMATTYPE FROM DESIGN WHERE DESIGN.ID = WORKREQUEST.ATTACHEDDESIGNID) AS AttachedDesignFormat
FROM WORKREQUEST WHERE WORKREQUEST.WorkRequestStateId IN
(SELECT WORKREQUESTSTATE.ID FROM WORKREQUESTSTATE WHERE NAME != 'Merged-Project Complete')

--WORKREQUEST.my user or any user?---

Thanks!

Parents Reply Children
No Data