Data table filter on long Number won't work?

Questions
1

So far, I’ve been using Airtable to store my transactional data. With Data Tables now available, I figured it was time to migrate some of my data across. I did that for a table with about 375 records and about 15 columns - a list of scraped Instagram reels.

I have added a field as the Instagram Reel ID. It’s a long number (e.g. 3639726853330357600). I’ve configured it as a number in the Data Table. Next, I want to filter on this field. Somehow, when I do a simple query (Data Table block with Get Row using the Instagram ID from the previous step, it returns nothing).

Fine… I’ll troubleshoot. What happened next I completely don’t understand. I go into the data tables section. I copy the Instagram ID from a record. Then, I filter the table (using the filters at the top of the screen), using “Instagram ID” Equals “ID”. I paste in the ID that I just copied, so I know the row is there. It returns No Rows.

The filtering works fine on other text or numeric fields (e.g. the shortcode, height, width, number of views, etc.). Could it be that the number is just too big to be stored in Data Tables, and I should convert this column to text?

This is on Cloud Version 1.118.2 (latest stable).

2

It sounds like the issue might be related to the size or format of the Instagram Reel ID. Long numbers can sometimes cause issues in filtering, especially if they exceed the maximum limit for numeric fields. As a practical solution, try converting the Instagram Reel ID field to a text format in your Data Table. This should resolve the filtering issue, as text fields handle long strings more reliably. For more advanced filtering needs, consider using a dedicated database system like MySQL or Postgres, as suggested in the [n8n Community](HTTP Request Authorization Issue after N8N Update).