Filtering by timestamp not working in supabase node

Questions
1

Hey there!

I’m trying to filter out results from a supabase table using the greater than and less than conditions and applying those to the timestamp row.

Unfortunately the results output seem to ignore those filters.

For example, when I search for results where the timestamp is less than March 24th, it still returns results where the timestamp is March 25th.

image
image2038×1084 217 KB

Here’s a sample workflow:

N8N Version: 1.50.1

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Update: I’ve managed to get it working using the Filter as type “String”, and entering the following string:

select=embedding,timestamp&timestamp=gte.{'{{ $json.data.startTime }}'}&timestamp=lte.{'{{ $json.data.endTime }}'}

Please note @oleg this may be a bug with the filter (Build Manually) interface as it’s supposed to match all criteria but doesn’t. It only seems to match the last one entered.

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.