René's URL Explorer Experiment


Title: fix(files): order file folders in SQL like every other folder list by waleedlatif1 · Pull Request #6599 · simstudioai/sim · GitHub

Open Graph Title: fix(files): order file folders in SQL like every other folder list by waleedlatif1 · Pull Request #6599 · simstudioai/sim

X Title: fix(files): order file folders in SQL like every other folder list by waleedlatif1 · Pull Request #6599 · simstudioai/sim

Description: Summary executeListWorkspaceFileFolders defaulted to sortBy ?? 'name' — defaults written for the new v2 contract — and sorted in JS. The internal contract (workspace-file-folders.ts) exposes only scope, so the repository's sortOrder ASC, createdAt ASC ordering became unreachable. That ordering is meaningful: a new folder takes sortOrder = minSortOrder - 1, so it is deliberately newest-first, and it is user-modifiable. Pushed the sort into the query like the workflow, knowledge, and table folder lists already do, reusing the shared FOLDER_SORTS map. Omitting sortBy keeps position; v2 always sends one from its contract defaults. Impact this fixes Surfaces that render the payload in arrival order and had flipped newest-first → alphabetical: @-mention Folders group — no sort, MAX_PER_GROUP = 8, so a workspace with >8 folders showed the 8 alphabetically-first instead of the 8 most recent, making a just-created folder unreachable without typing. Add-resource dropdown search results — filters, never sorts. Copilot list_file_folders. Also removes a real SSR mismatch: files/prefetch.ts hydrates workspaceFileFolderKeys.list(workspaceId, 'active') by calling the data layer directly (repository order) while the client hook fetches the same key through the route (name-sorted). Its TSDoc asserts a "correctly-ordered first frame" and that a "hydrated entry matches a client fetch" — true again now. Unaffected either way (they re-sort client-side): the Files browser (files.tsx sorts by sortOrder then localeCompare), Recently Deleted, and the add-resource submenu tree. Secondary correctness win A sortBy=name request previously compared with raw on UTF-16 code units, so "Zebra" sorted before "apple" — a third ordering matching neither the old one nor the localeCompare every client surface uses, with no tiebreak for equal names. It now uses the database collation and the shared createdAt tiebreak, consistent with the other folder lists. Type of Change Bug fix Testing New tests assert the sort is delegated (not applied in memory) and that omitting sortBy leaves it unset. Verified all three fail against the pre-fix code. bunx vitest run lib/ app/api/ — 15,141 passing. Repo-wide lint:check and type-check (23/23 each), plus check:api-validation and monorepo-boundary gates. Audited every caller of the use case (internal route, v2 route, Copilot tool, Copilot VFS ×2, function-execute mounts); the VFS and function-execute paths consume results by path lookup, so ordering is immaterial there. Confirmed no sibling sweep is needed: listActiveFolderRows' ?? 'name' is a dead default — its only callers are v2 use cases that always receive a defaulted sortBy. Not exercised against a live workspace. Checklist Code follows project style guidelines Self-reviewed my changes Tests added/updated and passing No new warnings introduced I confirm that I have read and agree to the terms outlined in the Contributor License Agreement (CLA)

Open Graph Description: Summary executeListWorkspaceFileFolders defaulted to sortBy ?? 'name' — defaults written for the new v2 contract — and sorted in JS. The internal contract (workspace-file-folders.ts) expos...

X Description: Summary executeListWorkspaceFileFolders defaulted to sortBy ?? 'name' — defaults written for the new v2 contract — and sorted in JS. The internal contract (workspace-file-folders.t...

Opengraph URL: https://github.com/simstudioai/sim/pull/6599

X: @github

direct link

Domain: github.com

react-profiling0
react-import-mapreact,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/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:880a9475-9f3d-7426-1307-8febe0e120a5
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idD34C:EA1A8:982A69:D1591C:6AFB4D8C
html-safe-nonce63802ff90ed17d2edd607838357b7ee25d461069a11019a197a3e3828d9c9a42
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJEMzRDOkVBMUE4Ojk4MkE2OTpEMTU5MUM6NkFGQjREOEMiLCJ2aXNpdG9yX2lkIjoiNjQwMjkxODA2NDMyMTUyOTcyIiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac017d0ad25dfb02fccd745d8f72ae1253d96f1deb2830c54f0997b5de61f26a45
hovercard-subject-tagpull_request:4259171717
github-keyboard-shortcutsrepository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///pull_requests/show/files
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/simstudioai/sim/pull/6599/files
twitter:imagehttps://avatars.githubusercontent.com/u/40672544?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/40672544?s=400&v=4
og:image:altSummary executeListWorkspaceFileFolders defaulted to sortBy ?? 'name' — defaults written for the new v2 contract — and sorted in JS. The internal contract (workspace-file-folders.ts) expos...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
Noneacf7616d06cc051644705b379878c9bb13dc5e70ecf4ffd9b34140f8ac01d7e1
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/simstudioai/sim git https://github.com/simstudioai/sim.git
octolytics-dimension-user_id199344406
octolytics-dimension-user_loginsimstudioai
octolytics-dimension-repository_id912559512
octolytics-dimension-repository_nwosimstudioai/sim
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id912559512
octolytics-dimension-repository_network_root_nwosimstudioai/sim
turbo-body-classeslogged-out env-production page-responsive full-width
disable-turbotrue
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release26504db649b58525278f77a52b80ba5f10d5f4de
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/simstudioai/sim/pull/6599/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F6599%2Ffiles
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimstudioai%2Fsim%2Fpull%2F6599%2Ffiles
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fpull_requests%2Fshow%2Ffiles&source=header-repo&source_repo=simstudioai%2Fsim
Reloadhttps://github.com/simstudioai/sim/pull/6599/files
Reloadhttps://github.com/simstudioai/sim/pull/6599/files
Reloadhttps://github.com/simstudioai/sim/pull/6599/files
simstudioaihttps://github.com/simstudioai
simhttps://github.com/simstudioai/sim
Codehttps://github.com/simstudioai/sim
Issues129 (129)https://github.com/simstudioai/sim/issues
Pull requests197 (197)https://github.com/simstudioai/sim/pulls
Actionshttps://github.com/simstudioai/sim/actions
Projectshttps://github.com/simstudioai/sim/projects
Security and qualityhttps://github.com/simstudioai/sim/security
Insightshttps://github.com/simstudioai/sim/pulse
Sign up for GitHub https://github.com/signup?return_to=%2Fsimstudioai%2Fsim%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Fsimstudioai%2Fsim%2Fissues%2Fnew%2Fchoose
waleedlatif1https://github.com/waleedlatif1
staginghttps://github.com/simstudioai/sim/tree/staging
investigate/folder-sorthttps://github.com/simstudioai/sim/tree/investigate/folder-sort
Conversation 3 https://github.com/simstudioai/sim/pull/6599
Commits 1 https://github.com/simstudioai/sim/pull/6599/commits
Checks 30 https://github.com/simstudioai/sim/pull/6599/checks
Files changed https://github.com/simstudioai/sim/pull/6599/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/6599/files
fix(files): order file folders in SQL like every other folder list https://github.com/simstudioai/sim/pull/6599/files#top
Show all changes 1 commit https://github.com/simstudioai/sim/pull/6599/files
771499a fix(files): order file folders in SQL like every other folder list waleedlatif1 Aug 12, 2026 https://github.com/simstudioai/sim/pull/6599/commits/771499acf67c2a0814e898214b190c4036b1b22c
Clear filters https://github.com/simstudioai/sim/pull/6599/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/6599/files
Please reload this pagehttps://github.com/simstudioai/sim/pull/6599/files
shared.ts https://github.com/simstudioai/sim/pull/6599/files#diff-20f230abfd622951bbc4374b69945ac4a47e4cdffdb0162f16b0bb12d45ce243
queries.ts https://github.com/simstudioai/sim/pull/6599/files#diff-8c09d4934ac710b9fc5d471563a51c44da290d6daee339c54f2d124faad282e4
workspace-file-folder-manager.ts https://github.com/simstudioai/sim/pull/6599/files#diff-7ab6712e7e7b3b214000c022f68393bf7da60abb4ec2a557d5fa912f10c245cc
workspace-file-folders.test.ts https://github.com/simstudioai/sim/pull/6599/files#diff-bd04931ba9e7ad3d16b12af6bb9cecff08d47ac99cafe1bf919d390400abf759
workspace-file-folders.ts https://github.com/simstudioai/sim/pull/6599/files#diff-94f722d12677d09f7a29274dae68cf644c6bb1a53e59f4f0f02e625c62865945
apps/sim/lib/api/contracts/v2/shared.tshttps://github.com/simstudioai/sim/pull/6599/files#diff-20f230abfd622951bbc4374b69945ac4a47e4cdffdb0162f16b0bb12d45ce243
View file https://github.com/simstudioai/sim/blob/771499acf67c2a0814e898214b190c4036b1b22c/apps/sim/lib/api/contracts/v2/shared.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/6599/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/6599/files#diff-20f230abfd622951bbc4374b69945ac4a47e4cdffdb0162f16b0bb12d45ce243
https://github.com/simstudioai/sim/pull/6599/files#diff-20f230abfd622951bbc4374b69945ac4a47e4cdffdb0162f16b0bb12d45ce243
apps/sim/lib/folders/queries.tshttps://github.com/simstudioai/sim/pull/6599/files#diff-8c09d4934ac710b9fc5d471563a51c44da290d6daee339c54f2d124faad282e4
View file https://github.com/simstudioai/sim/blob/771499acf67c2a0814e898214b190c4036b1b22c/apps/sim/lib/folders/queries.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/6599/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/6599/files#diff-8c09d4934ac710b9fc5d471563a51c44da290d6daee339c54f2d124faad282e4
https://github.com/simstudioai/sim/pull/6599/files#diff-8c09d4934ac710b9fc5d471563a51c44da290d6daee339c54f2d124faad282e4
apps/sim/lib/uploads/contexts/workspace/workspace-file-folder-manager.tshttps://github.com/simstudioai/sim/pull/6599/files#diff-7ab6712e7e7b3b214000c022f68393bf7da60abb4ec2a557d5fa912f10c245cc
View file https://github.com/simstudioai/sim/blob/771499acf67c2a0814e898214b190c4036b1b22c/apps/sim/lib/uploads/contexts/workspace/workspace-file-folder-manager.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/6599/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/6599/files#diff-7ab6712e7e7b3b214000c022f68393bf7da60abb4ec2a557d5fa912f10c245cc
https://github.com/simstudioai/sim/pull/6599/files#diff-7ab6712e7e7b3b214000c022f68393bf7da60abb4ec2a557d5fa912f10c245cc
https://github.com/simstudioai/sim/pull/6599/files#diff-7ab6712e7e7b3b214000c022f68393bf7da60abb4ec2a557d5fa912f10c245cc
https://github.com/simstudioai/sim/pull/6599/files#diff-7ab6712e7e7b3b214000c022f68393bf7da60abb4ec2a557d5fa912f10c245cc
https://github.com/simstudioai/sim/pull/6599/files#diff-7ab6712e7e7b3b214000c022f68393bf7da60abb4ec2a557d5fa912f10c245cc
https://github.com/simstudioai/sim/pull/6599/files#diff-7ab6712e7e7b3b214000c022f68393bf7da60abb4ec2a557d5fa912f10c245cc
apps/sim/lib/workspace-files/application/workspace-file-folders.test.tshttps://github.com/simstudioai/sim/pull/6599/files#diff-bd04931ba9e7ad3d16b12af6bb9cecff08d47ac99cafe1bf919d390400abf759
View file https://github.com/simstudioai/sim/blob/771499acf67c2a0814e898214b190c4036b1b22c/apps/sim/lib/workspace-files/application/workspace-file-folders.test.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/6599/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/6599/files#diff-bd04931ba9e7ad3d16b12af6bb9cecff08d47ac99cafe1bf919d390400abf759
https://github.com/simstudioai/sim/pull/6599/files#diff-bd04931ba9e7ad3d16b12af6bb9cecff08d47ac99cafe1bf919d390400abf759
apps/sim/lib/workspace-files/application/workspace-file-folders.tshttps://github.com/simstudioai/sim/pull/6599/files#diff-94f722d12677d09f7a29274dae68cf644c6bb1a53e59f4f0f02e625c62865945
View file https://github.com/simstudioai/sim/blob/771499acf67c2a0814e898214b190c4036b1b22c/apps/sim/lib/workspace-files/application/workspace-file-folders.ts
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/simstudioai/sim/pull/6599/{{ revealButtonHref }}
https://github.com/simstudioai/sim/pull/6599/files#diff-94f722d12677d09f7a29274dae68cf644c6bb1a53e59f4f0f02e625c62865945
https://github.com/simstudioai/sim/pull/6599/files#diff-94f722d12677d09f7a29274dae68cf644c6bb1a53e59f4f0f02e625c62865945
https://github.com/simstudioai/sim/pull/6599/files#diff-94f722d12677d09f7a29274dae68cf644c6bb1a53e59f4f0f02e625c62865945
https://github.com/simstudioai/sim/pull/6599/files#diff-94f722d12677d09f7a29274dae68cf644c6bb1a53e59f4f0f02e625c62865945
https://github.com/simstudioai/sim/pull/6599/files#diff-94f722d12677d09f7a29274dae68cf644c6bb1a53e59f4f0f02e625c62865945
https://github.com/simstudioai/sim/pull/6599/files#diff-94f722d12677d09f7a29274dae68cf644c6bb1a53e59f4f0f02e625c62865945
Please reload this pagehttps://github.com/simstudioai/sim/pull/6599/files
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.