Kendo Grid

hi everyone,

we have requirement to filter the data at view level based on current time. we are using kendo grid.

so trying to use the filters concept.

we have to filter based on enrolldate and term date.

(enrolldate <= currentDate ) && (finaldate ===null or finaldate >= currentdate) ===> Active records

(enrolldate> current date or finaldate < current date) ==> inactive records

try to use the filters but the below scenaio not working:

if the enrolldate is future date and final date is null its throwing as Active records...used below code

if (isactive) {
return {
logic: "or",
filters: [
{
logic: "and",
filters: [
{
field: "enrolldate",
operator: "lte", // check current date also
value: vue360.dateAndTimeToISOString(new Date())
},
{
field: "finaldate",
operator: "gte", // check current date also
value: vue360.dateAndTimeToISOString(new Date())
},
]
},
{
field: "finaldate",
operator: "isnull",
value: null
},
],
};
} else {
return {
logic: "and",
filters: [
{
logic: "or",
filters: [
{
logic: "and",
filters:
[
{
field: "enrolldate",
operator: "gt",
value: vue360.dateAndTimeToISOString(new Date())
},
{
field: "finaldate",
operator: "gt",
value: vue360.dateAndTimeToISOString(new Date())
},
]
},
{
logic: "and",
filters: [
{
field: "enrolldate",
operator: "lt",
value: vue360.dateAndTimeToISOString(new Date())
},
{
field: "finaldate",
operator: "lt",
value: vue360.dateAndTimeToISOString(new Date())
},
]
}
]
},
{
field: "finaldate",
operator: "isnotnull",
value: null
},
],
}
}

I see that you’re trying to filter records in a Kendo Grid based on the enrolldate and finaldate fields. You want to classify records as “Active” if the enrolldate is in the past and the finaldate is either null or in the future. Conversely, you want to classify records as “Inactive” if the enrolldate is in the future or the finaldate is in the past.

The issue you’re facing is that records with a future enrolldate and a null finaldate are being classified as “Active”. This is happening because your “Active” filter logic is considering records with a null finaldate as “Active”, regardless of the enrolldate.

To fix this, you should adjust your “Active” filter logic to also consider the enrolldate. Here’s how you can modify your code:

if (isactive) {
    return  {
        logic: "and",
        filters: [
            {
                field: "enrolldate",
                operator: "lte",  // check current date also
                value: vue360.dateAndTimeToISOString(new Date())
            },
            {
                logic: "or",
                filters: [
                    {
                        field: "finaldate",
                        operator: "gte",   // check current date also
                        value: vue360.dateAndTimeToISOString(new Date())
                    },
                    {
                        field: "finaldate",
                        operator: "isnull",
                        value: null
                    },
                ]
            },
        ],
    };
} else {
    return {
        logic: "or",
        filters: [
            {
                field: "enrolldate",
                operator: "gt",
                value: vue360.dateAndTimeToISOString(new Date())
            },
            {
                logic: "and",
                filters: [
                    {
                        field: "finaldate",
                        operator: "lt",
                        value: vue360.dateAndTimeToISOString(new Date())
                    },
                    {
                        field: "finaldate",
                        operator: "isnotnull",
                        value: null
                    },
                ]
            },
        ],
    }
}

In the “Active” filter, I’ve moved the enrolldate filter to the top level of the and logic, so it applies to all records. The or logic now only applies to the finaldate field, checking if it’s either in the future or null.

In the “Inactive” filter, I’ve changed the top-level logic to or, so a record is considered “Inactive” if either the enrolldate is in the future, or the finaldate is in the past and not null.

Thanks