I've added custom_field_value16 to one of my ticket queues. It is hidden from ticket submitters and ticket owners. Based on an action in the ticket I drop a timestamp in the field. The intent is to check this field for the presence of the timestamp (because it's not always suppose to be present) and if it is present, use it in place of a system placed timestamp in another field.

In trying to query for the timestamp value I'm running into a problem where there is no timestamp present in custom_field_value16 but the field doesn't "= IS NOT NULL" because it is an empty string value as in = '' (two single quotes). I was trying to use ifnull(expr1,expr2) in my query but it doesn't return all of the rows where custom_field_value16 doesn't have a timestamp.

Question: Is there a suitable replacement to ifnull? I have tried using CASE WHEN () THEN () but it becomes very convoluted and doesn't provide accurate results.
1 Comment   [ - ] Hide Comment


  • have you tried
    filter line 1: does not begin with '' or does not contain ''
    filter line 2: is not null
    • Thank you for this. I didn't use DOES NOT but you started me thinking along a different line and it helped. Still ended up using CASE WHEN but since it is a text field I was able to add LIKE and NOT LIKE to look for the timestamp pattern. It's not very pretty but it works without negatively impacting the kbox when it runs ;)

      Thanks again
Please log in to comment

There are no answers at this time
Answer this question or Comment on this question for clarity