How do I create initial filters in datagrid?

Ask us anything How do I?
1

Hi,
I have a datagrid looking like this:

image
image916×452 24.3 KB

I tried this initial filters but it doesn’t work:

return {
  "Status": {
    "type": "contains",
    "filter": "not"
  }
}

And this is how the column looks like in the datagrid:

image
image638×602 25.7 KB

It’s either:
“Done”
or “Not done”

What am I doing wrong?

2

there should be a setting for that within the datagrid settings!

image
image424×1462 51.2 KB

1 Like
3

Indeed. I tried with the code mentioned in my previous message but it’s not working.

4

It should be something like

{
  "ColumnName": {
    "type": "contains", // Filter operation (e.g., contains, equals, etc.)
    "filter": "value"   // Value to filter by
  }
}

Maybe paste that in the formula instead of Js? And also can you try with Not instead of not