Alright saved search gurus... I'm trying to return a workflow "Date Entered State" from a workflow field when workflow state = x. I've successfully pulled this by setting criteria, however I want my saved search to show more than just records in that state, so I'm going the CASE statement route... This isn't returning values, so I'm imaginging I'm representing the current state incorrectly... anyone mind taking a look?
CASE WHEN {workflow.currentstate} = 'Workflow for Time Entry : Approved' THEN {workflow.dateenteredstate} ELSE NULL END
This criteria pictured and this result column (Workflow Fields... Date Entered State) returned the correct value.