Title: [BUG] Filtering on built-in columns (createdAt, updatedAt) silently returns zero rows · Issue #5920 · simstudioai/sim · GitHub
Open Graph Title: [BUG] Filtering on built-in columns (createdAt, updatedAt) silently returns zero rows · Issue #5920 · simstudioai/sim
X Title: [BUG] Filtering on built-in columns (createdAt, updatedAt) silently returns zero rows · Issue #5920 · simstudioai/sim
Description: Describe the bug The docs state that createdAt, updatedAt, and id are built-in columns that "you can still filter and sort on". Sorting on these works. Filtering on them does not. Any filter referencing a built-in column silently matches...
Open Graph Description: Describe the bug The docs state that createdAt, updatedAt, and id are built-in columns that "you can still filter and sort on". Sorting on these works. Filtering on them does not. Any filter refere...
X Description: Describe the bug The docs state that createdAt, updatedAt, and id are built-in columns that "you can still filter and sort on". Sorting on these works. Filtering on them does not. Any fil...
Opengraph URL: https://github.com/simstudioai/sim/issues/5920
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[BUG] Filtering on built-in columns (createdAt, updatedAt) silently returns zero rows","articleBody":"**Describe the bug**\n\nThe [docs](https://docs.sim.ai/tables/using-in-workflows) state that createdAt, updatedAt, and id are built-in columns that \"you can still filter and sort on\". Sorting on these works. Filtering on them does not. Any filter referencing a built-in column silently matches nothing and returns an empty result set.\n\n**To Reproduce**\n\nVia the v1 API:\n\n```\nGET /api/v1/tables/{tableId}/rows?workspaceId={wsId}&filter={\"createdAt\":{\"$gte\":\"2026-07-24T03:00:00.000Z\",\"$lte\":\"2026-07-25T02:59:59.999Z\"}}\n```\n\n_With a string value, returns 400 Bad Request:_\n\n```\n{\n \"error\": \"Range operator on column \\\"createdAt\\\" (number) requires a number, got string\"\n}\n````\n\n_With a numeric value (Unix timestamp)_\n\n```\n{ \"rows\": [], \"rowCount\": 0, \"totalCount\": 0 }\n```\n\nPasses validation, but returns empty results. No error, no warning, just zero rows regardless of how many rows match the range.\n\n**Expected behavior**\n\nFilters on createdAt / updatedAt / id compare against the top-level row columns (user_table_rows.createdAt, etc.) and return matching rows, mirroring the behavior the sort builder already provides.\n\n**Additional context**\n\nI think I can open a PR to solve this, if this intend to work the way I've described it.\n","author":{"url":"https://github.com/reidark","@type":"Person","name":"reidark"},"datePublished":"2026-07-24T06:08:14Z","url":"https://github.com/simstudioai/sim/issues/5920"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react-reconciler,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@d5750093facf |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:4fe19a83-f814-435a-fdbb-1a215a55e373 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | 8E78:63A32:F9FE6:163B6A:6AFB4BDD |
| html-safe-nonce | 10986ddc93b3755a79c9e78ab848dfb0163cc43e8330af15a15736a9cb06ebfe |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI4RTc4OjYzQTMyOkY5RkU2OjE2M0I2QTo2QUZCNEJERCIsInZpc2l0b3JfaWQiOiI0NzYyMjQ2ODk3NjQ3NDM4ODEzIiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0= |
| visitor-hmac | 78f8adc3b6a1ba6f3e7bd6c8c2fb793e020bb48d92faac70de848d5595c619d2 |
| hovercard-subject-tag | issue:4965700419 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/simstudioai/sim/5920/issue_layout |
| twitter:image | https://opengraph.githubassets.com/5f2036a931d555355399abd9e1d602ea522297c122d97794784f9ae301154f79/simstudioai/sim/issues/5920 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/5f2036a931d555355399abd9e1d602ea522297c122d97794784f9ae301154f79/simstudioai/sim/issues/5920 |
| og:image:alt | Describe the bug The docs state that createdAt, updatedAt, and id are built-in columns that "you can still filter and sort on". Sorting on these works. Filtering on them does not. Any filter refere... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | reidark |
| hostname | github.com |
| expected-hostname | github.com |
| None | acf7616d06cc051644705b379878c9bb13dc5e70ecf4ffd9b34140f8ac01d7e1 |
| turbo-cache-control | no-preview |
| go-import | github.com/simstudioai/sim git https://github.com/simstudioai/sim.git |
| octolytics-dimension-user_id | 199344406 |
| octolytics-dimension-user_login | simstudioai |
| octolytics-dimension-repository_id | 912559512 |
| octolytics-dimension-repository_nwo | simstudioai/sim |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 912559512 |
| octolytics-dimension-repository_network_root_nwo | simstudioai/sim |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 26504db649b58525278f77a52b80ba5f10d5f4de |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width