[Trac] Re: custom fields in reports

[Joe]

Jim Cheetham wrote:

> I have a remaining minor niggle : the unpopulated custom fields render
> as the word "None" in the output, and I'd like them to be blank. I tried
> a CASE clause, but that didn't seem to trigger for 'None' or NULL ...
> 
> 
>> (CASE c.value WHEN '' THEN ' ' ELSE c.value END) AS chargeable,
> 
> 
> Any clues on this last point (plus better suggestions for my verbose
> LEFT OUTER JOINs) would be welcome!

You can use an ifnull(X, Y) expression, e.g., ifnull(c.value, 'None').

Joe