--- title: Sort a HubDB query by date description: A simple answer to the question of how you can sort a HubDB query by date on HubSpot. --- [Skip to Content](https://www.stephanieogaygarcia.com/hubspot-website-development/sort-a-hubdb-query-by-date#main-content) [![Stephanie O'Gay Garcia](https://www.stephanieogaygarcia.com/hubfs/Logos/stephanieogaygarcia_logo.svg "Stephanie O'Gay Garcia")](https://www.stephanieogaygarcia.com/) Open Navigation - [About](https://www.stephanieogaygarcia.com/about) - [Services](https://www.stephanieogaygarcia.com/services) - [Products](https://www.stephanieogaygarcia.com/shop) - [Work](https://www.stephanieogaygarcia.com/portfolio-work) - [Blog](https://www.stephanieogaygarcia.com/hubspot-website-development) - [Contact](https://www.stephanieogaygarcia.com/contact) - [About](https://www.stephanieogaygarcia.com/about) - [Services](https://www.stephanieogaygarcia.com/services) - [Products](https://www.stephanieogaygarcia.com/shop) - [Work](https://www.stephanieogaygarcia.com/portfolio-work) - [Blog](https://www.stephanieogaygarcia.com/hubspot-website-development) - [Contact](https://www.stephanieogaygarcia.com/contact) [HubSpot Sprocket Icon HubSpot Website Development ](https://www.stephanieogaygarcia.com/hubspot-website-development) [hubl, ](https://www.stephanieogaygarcia.com/hubspot-website-development/tag/hubl) [hubdb](https://www.stephanieogaygarcia.com/hubspot-website-development/tag/hubdb) # Sort a HubDB query by date Technical Difficulty: Advanced Written by [ Stephanie O'Gay Garcia ](https://www.stephanieogaygarcia.com/hubspot-website-development/author/stephanie-ogay-garcia) First Published: May 19, 2022 Last Updated: May 19, 2022 ⚠️ Note that this post hasn't been updated for at least a year and the information may be outdated, proceed with caution! *(Last updated: May 19, 2022)* Let's assume you have a HubDB table (ID 12345) with two columns:  - A date column (Date type) with the column name "date" - A title column (Text type) with the column name "title" In your code, you can use the `orderBy` parameter to sort your table by a specific column (in this case, "date"), adding a minus symbol in front of it if you want to reverse the order. So your query parameters will either be `"&orderBy=date"` or `"&orderBy=-date"` Using the [hubdb_table_rows](https://developers.hubspot.com/docs/cms/hubl/functions#hubdb-table-rows) function, this looks something like this:    See the Pen [ [Blog Post Example] Sort a HubDB query by date](https://codepen.io/stephanieogaygarcia/pen/qBxmgwB) by Stephanie O'Gay Garcia ([@stephanieogaygarcia](https://codepen.io/stephanieogaygarcia)) on [CodePen](https://codepen.io).   Note: if you've somehow landed on this post looking for a way to sort the actual HubDB table, unfortunately, that's not possible as of the time of writing this post unless you do some hacky export/order on a spreadsheet/re-import. But be sure to upvote the idea [here](https://community.hubspot.com/t5/HubSpot-Ideas/HubDB-rearrange-order/idi-p/5167)! In a recent update, HubSpot have said they're working on it so fingers crossed! If you found this helpful, buy me a coffee! ❤️ ←  Previous Article [How to combine posts from multiple HubSpot blogs in a custom module](https://www.stephanieogaygarcia.com/hubspot-website-development/how-to-combine-posts-from-multiple-hubspot-blogs-in-a-custom-module) Next Article  → [Prevent editing in content editors in coded HubSpot templates](https://www.stephanieogaygarcia.com/hubspot-website-development/prevent-editing-in-content-editors-in-coded-hubspot-templates) Contact ## Get help from a HubSpot CMS Expert - Custom HubSpot themes and reusable and easy-to-use HubSpot templates and modules - Technical support and guidance on the HubSpot CMS [ Tell me about your project ](https://www.stephanieogaygarcia.com/project-details) ##### Contact Need help with a HubSpot CMS project? Get in touch! [Email](mailto:stephanie@stephanieogaygarcia.com) | [Contact](https://www.stephanieogaygarcia.com/contact) ##### About - [ About ](https://www.stephanieogaygarcia.com/about) - [ Portfolio ](https://www.stephanieogaygarcia.com/portfolio-work) - [ LinkedIn ](https://www.linkedin.com/in/stephanieogaygarcia/) - [ Facebook ](https://www.facebook.com/stephanieogaygarcia) - [ Instagram ](https://www.instagram.com/stephanieogaygarcia/) ##### Services - [ HubSpot Website Development ](https://www.stephanieogaygarcia.com/services/hubspot-website-development) - [ HubSpot CMS Technical Support ](https://www.stephanieogaygarcia.com/services/hubspot-cms-technical-support) - [ Custom HubSpot CMS Themes ](https://www.stephanieogaygarcia.com/custom-hubspot-cms-hub-themes) - [ Pricing ](https://www.stephanieogaygarcia.com/services#pricing) ##### Latest Articles - [How to add an llms.txt page to your HubSpot website](https://www.stephanieogaygarcia.com/hubspot-website-development/add-an-llmstxt-page-to-your-hubspot-website) - [Switch an existing HubSpot custom module from global to local](https://www.stephanieogaygarcia.com/hubspot-website-development/switch-an-existing-hubspot-custom-module-from-global-to-local) - [Overriding HubSpot's new forms styling from theme settings](https://www.stephanieogaygarcia.com/hubspot-website-development/overriding-hubspots-new-forms-styling-from-theme-settings) - [All Articles](https://www.stephanieogaygarcia.com/hubspot-website-development) --- Copyright © 2018 - 2026 Stephanie O'Gay Garcia. All Rights Reserved. Freelance HubSpot CMS Developer based in Toronto, Canada 🇨🇦 [Terms of Service](https://www.stephanieogaygarcia.com/terms-of-service) | [Website Terms of Use](https://www.stephanieogaygarcia.com/website-terms-of-use) | [Privacy](https://www.stephanieogaygarcia.com/privacy-policy) | [Cookies](https://www.stephanieogaygarcia.com/cookie-policy) | [LLMs](https://www.stephanieogaygarcia.com/llms.txt) Scroll to Top ```json { "@context" : "https://schema.org", "@id" : "https://www.stephanieogaygarcia.com/#person", "@type" : "Person", "description" : "Freelance HubSpot CMS Developer specializing in custom HubSpot website development, themes, templates, and bespoke modules for small–mid sized B2B and SaaS companies.", "image" : "https://www.stephanieogaygarcia.com/hubfs/Logos/stephanieogaygarcia_logo.svg", "jobTitle" : "Freelance HubSpot CMS Developer", "knowsAbout" : [ "HubSpot CMS", "HubSpot themes", "HubSpot templates", "HubSpot modules", "HubDB", "Website migrations to HubSpot CMS", "Figma to HubSpot implementation" ], "name" : "Stephanie O'Gay Garcia", "sameAs" : [ "https://www.linkedin.com/in/stephanieogaygarcia/", "https://www.facebook.com/stephanieogaygarcia", "https://www.instagram.com/stephanieogaygarcia/", "https://ecosystem.hubspot.com/marketplace/solutions/stephanie-ogay-garcia/" ], "url" : "https://www.stephanieogaygarcia.com/", "worksFor" : { "@id" : "https://www.stephanieogaygarcia.com/#organization" } } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.stephanieogaygarcia.com/#organization", "@type" : "Organization", "address" : { "@type" : "PostalAddress", "addressCountry" : "IE", "addressLocality" : "Dublin", "postalCode" : "A94" }, "contactPoint" : { "@type" : "ContactPoint", "areaServed" : "Worldwide", "availableLanguage" : [ "en", "es" ], "contactType" : "sales", "email" : "stephanie@stephanieogaygarcia.com" }, "description" : "Portfolio and business site of freelance HubSpot CMS Developer Stephanie O'Gay Garcia, based in Dublin, Ireland.", "logo" : "https://www.stephanieogaygarcia.com/hubfs/Logos/stephanieogaygarcia_logo.svg", "name" : "Stephanie O'Gay Garcia", "sameAs" : [ "https://www.linkedin.com/in/stephanieogaygarcia/", "https://www.facebook.com/stephanieogaygarcia", "https://www.instagram.com/stephanieogaygarcia/", "https://ecosystem.hubspot.com/marketplace/solutions/stephanie-ogay-garcia/" ], "url" : "https://www.stephanieogaygarcia.com/" } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.stephanieogaygarcia.com/#website", "@type" : "WebSite", "name" : "Stephanie O’Gay Garcia – Freelance HubSpot CMS Developer", "publisher" : { "@id" : "https://www.stephanieogaygarcia.com/#organization" }, "url" : "https://www.stephanieogaygarcia.com/" } ``` ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Stephanie O'Gay Garcia", "url" : "https://www.stephanieogaygarcia.com/hubspot-website-development/author/stephanie-ogay-garcia" }, "dateModified" : "2022-05-19T16:03:21.098Z", "datePublished" : "2022-05-19T16:03:21.000Z", "headline" : "Sort a HubDB query by date", "mainEntityOfPage" : { "@id" : "https://www.stephanieogaygarcia.com/hubspot-website-development/sort-a-hubdb-query-by-date", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.stephanieogaygarcia.com/hubfs/Logos/stephanieogaygarcia_logo.svg" } } } ```