Handling NULL values

[RGTech]

Hi,

I've got a snipplet of C# razor syntax below which builds up columns for a 12 month period.

The Month1-12 fields can be null.
I would like to be able to sort on Month<number>.EHR.

For example I want to sort on month 'Month12.EHR'.
Because Month12 is null, the grid continuously looks like it's loading.

How am I able to sort the grid on columns that have null?

@for (int i = 12; i > 0; i--)
{
    <text>
    {
        field: 'Month@(i).EHR',
        title: 'Month@(i)',
        template: '#if (Month@(i) != null) {#$#:Month@(i).EHR#.00 (#:Month@(i).TotalTime#)#} else {# #:"--"# #} #',
        width: 20
    },
    </text>
}

Thanks, Mike.

[Daniel]

Hello Mike,

As I replied in the support ticket on the same topic, the schema does not support complex fields. You should use server sorting in order to avoid the problem.

Regards,
Daniel
the Telerik team