[Solved] Combining grid filters

[Tim]

Hi,

I am trying to write a filter that produces the following :-

SELECT *
FROM [MyTable]
WHERE
(
    ([StartDate] >= @StartDate AND [EndDate] <= @EndDate )
    OR
    ([EndDate] >= @StartDate AND [EndDate] <= @EndDate )
    OR
    ([StartDate] <= @StartDate AND [EndDate] >= @EndDate )
)
AND ([Status] = @Status)

All attempts so far have failed, could anyone please help?

 

[Rosen]

Hello Tim,

We have already answered your question in the support ticket you have open on this. I'm pasting the response for completeness.

This should look similar to the following:

dataSource.filter({
  logic: "and",
  filters: [
    {
      logic: "or",
      filters: [
        {
          logic: "and",
          filters: [
            { field: "StartDate", operator: "gte", value: new Date(/*..*/) },
            { field: "EndDate", operator: "lte", value: new Date(/*..*/) }
          ]
        },
        {
          logic: "and",
          filters: [
            { field: "StartDate", operator: "gte", value: new Date(/*..*/) },
            { field: "EndDate", operator: "lte", value: new Date(/*..*/) }
          ]
        },
        {
          logic: "and",
          filters: [
            { field: "StartDate", operator: "gte", value: new Date(/*..*/) },
            { field: "EndDate", operator: "lte", value: new Date(/*..*/) }
          ]
        }
      ]
    },
    {
      logic: "or",
      filters: [
          { field: "Status", operator: "eq", value: "SOMEVALUE" },
          { field: "Status", operator: "eq", value: "All" }
      ]
    }
  ]
});

Basically, every brackets expression is a composite expression with a logic operator and the value expressions are the leaves.

 

Regards,
Rosen
Telerik