sort by 'Initiated By'

[Former Community Member]

How can I sort a worklist or search results by 'Initiated By'? It is not available in the list of fields to sort by. For a new Timesheet application our HR Dept must sort all items in their worklist by Initiated By to see if there is more than 2 timesheets before the timesheets are finalized. If I cannot sort by 'Initiated By' how else can I do this? Can I use custom Title 1 and put the Initiator into that field? How would I do that.



Thanks in advance.



Mary Methven

[Former Community Member]

I am new to the forum and I just saw your question. Yes, you can so it exactly like you stated. To put the initiator name in the Custom Title 1 field, you have to execute the code below. You can set the script to run on a schedule.



UPDATE ITWORKITEMS

SET ITWORKITEMS.WICUST1 = ITUSERS.DISPNAME

FROM ITUSERS

WHERE (ITWORKITEMS.WIORIGPTUID = ITUSERS.USERUID)



Actually, you can just put WIORIGPTUID in the WICUST1 column and sort on WICUST1. The data in WICUST1 column will look like garbage but it is the same as USERUID value on the ITUSERS table. When you sort on this, you will in effect be sorting the Initiator column.