I have a case search and I need to exclude cases where the priority has changed. So, I am trying to use a case statement but what I have is not weeding out those cases.
Formula(text) case when {systemnotes.field} = 'Priority' then 1 else 0 end
description is 0
It turns out that Priority isn't listed in the system notes unless it has been changed so I should be able to get this to work.
Any ideas?