As a general rule, whenever an activity log is added to a ticket, if there was no user provided description, the action_desc field has the same content as the description field. However, in tickets with lots of transfers, field updates or workflow manipulation the activity log is filled with rarely important info.
I'd like to be able to filter out all the system generated stuff to only see the comments that were added by a human, regardless of what activity type it is. In simplest terms I want to add a filter that says action_desc != description but that fails to work. So does using <>. For that matter, so does using =.
If I compare either of those fields to a string, it works fine if I use like or not like. Using = I get a SQL error that ntext and varchar fields can't use =.
I'd be ok with action_description not like description except that doesn't work either. Just get syntax error.
Part 1) How would do it in addition search arguments
Part 2) More importantly, I'd rather have a check mark in the filter that says something like 'Comments Only' that would perform the same filter criteria on Search.