I’m using Grist. I have a table with 2 columns (domain, last_updated). I would like to return all the rows where last_updated is null (or last_updated > 2 days from now).
I don’t see how I can express either or both. e.g. the filter is a string, so ‘last_updated == foo’, but not a > or < or != null, or not empty type.
Am I missing something? I have looked at
tl;dr: I want to get rows where last_updated is null, and/or last_updated is more than 48 hours ago.
What is the error message (if any)?
No errors
Please share your workflow
(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
Ensure to copy your n8n workflow and paste it in the code block, that is in between the pairs of triple backticks, which also could be achieved by clicking </> (preformatted text) in the editor and pasting in your workflow.
```
<your workflow>
```
That implies to any JSON output you would like to share with us.
Make sure that you have removed any sensitive information from your workflow and include dummy or pinned data with it!
It looks like you cannot filter by ether range or NULL. You can raise a feature request to have this functionality added. Make sure to vote when you do.
Meanwhile a solution is to pull all the records and do the filtering with n8n workflow utilizing the node Filter, for example.
Pulling all records is not ACID so it can corrupt. Also it’s not scalable, my grist table does not fit in node memory. It’s also super slow.
So I guess the only solution is to not use grist. I experiment with adding a formula column based on the null and filter where {{true}} but ultimately it’s slow and no pagination means it can still crash