>As long as lcLogic is valid expression, EVALUATE() shpuld work.
>
I think I would put evaluate in try/catch block and it it fails would use SQL solution. For now we decided to not apply this fix, we fixed all profiles. And BTW we found a much bigger problem. In one of the profiles we had
Trans.cClient_Code = some code OR Trans.cProduct_Line_Code = some other code.
Yesterday I was looking into whole bunch of resolved records assigned to this user and was scratching my head in disbelief, but it didn't dawn at me to check that user profile!
If it's not broken, fix it until it is.
My Blog