mirror of https://github.com/nocodb/nocodb
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
1 lines
6.7 KiB
1 lines
6.7 KiB
"use strict";(self.webpackChunknoco_docs=self.webpackChunknoco_docs||[]).push([[9060],{3905:(e,t,r)=>{r.d(t,{Zo:()=>p,kt:()=>f});var o=r(67294);function n(e,t,r){return t in e?Object.defineProperty(e,t,{value:r,enumerable:!0,configurable:!0,writable:!0}):e[t]=r,e}function i(e,t){var r=Object.keys(e);if(Object.getOwnPropertySymbols){var o=Object.getOwnPropertySymbols(e);t&&(o=o.filter((function(t){return Object.getOwnPropertyDescriptor(e,t).enumerable}))),r.push.apply(r,o)}return r}function a(e){for(var t=1;t<arguments.length;t++){var r=null!=arguments[t]?arguments[t]:{};t%2?i(Object(r),!0).forEach((function(t){n(e,t,r[t])})):Object.getOwnPropertyDescriptors?Object.defineProperties(e,Object.getOwnPropertyDescriptors(r)):i(Object(r)).forEach((function(t){Object.defineProperty(e,t,Object.getOwnPropertyDescriptor(r,t))}))}return e}function l(e,t){if(null==e)return{};var r,o,n=function(e,t){if(null==e)return{};var r,o,n={},i=Object.keys(e);for(o=0;o<i.length;o++)r=i[o],t.indexOf(r)>=0||(n[r]=e[r]);return n}(e,t);if(Object.getOwnPropertySymbols){var i=Object.getOwnPropertySymbols(e);for(o=0;o<i.length;o++)r=i[o],t.indexOf(r)>=0||Object.prototype.propertyIsEnumerable.call(e,r)&&(n[r]=e[r])}return n}var s=o.createContext({}),c=function(e){var t=o.useContext(s),r=t;return e&&(r="function"==typeof e?e(t):a(a({},t),e)),r},p=function(e){var t=c(e.components);return o.createElement(s.Provider,{value:t},e.children)},d="mdxType",u={inlineCode:"code",wrapper:function(e){var t=e.children;return o.createElement(o.Fragment,{},t)}},g=o.forwardRef((function(e,t){var r=e.components,n=e.mdxType,i=e.originalType,s=e.parentName,p=l(e,["components","mdxType","originalType","parentName"]),d=c(r),g=n,f=d["".concat(s,".").concat(g)]||d[g]||u[g]||i;return r?o.createElement(f,a(a({ref:t},p),{},{components:r})):o.createElement(f,a({ref:t},p))}));function f(e,t){var r=arguments,n=t&&t.mdxType;if("string"==typeof e||n){var i=r.length,a=new Array(i);a[0]=g;var l={};for(var s in t)hasOwnProperty.call(t,s)&&(l[s]=t[s]);l.originalType=e,l[d]="string"==typeof e?e:n,a[1]=l;for(var c=2;c<i;c++)a[c]=r[c];return o.createElement.apply(null,a)}return o.createElement.apply(null,r)}g.displayName="MDXCreateElement"},82187:(e,t,r)=>{r.r(t),r.d(t,{assets:()=>s,contentTitle:()=>a,default:()=>u,frontMatter:()=>i,metadata:()=>l,toc:()=>c});var o=r(87462),n=(r(67294),r(3905));const i={title:"Sorting records",description:"Learn how to sort records in NocoDB.",tags:["Table operations","Sort","Gallery view","Kanban view","Grid view"],keywords:["NocoDB table","sort","sort records"]},a=void 0,l={unversionedId:"table-operations/sort",id:"table-operations/sort",title:"Sorting records",description:"Learn how to sort records in NocoDB.",source:"@site/docs/060.table-operations/040.sort.md",sourceDirName:"060.table-operations",slug:"/table-operations/sort",permalink:"/table-operations/sort",draft:!1,editUrl:"https://github.com/nocodb/nocodb/tree/develop/packages/noco-docs/docs/docs/060.table-operations/040.sort.md",tags:[{label:"Table operations",permalink:"/tags/table-operations"},{label:"Sort",permalink:"/tags/sort"},{label:"Gallery view",permalink:"/tags/gallery-view"},{label:"Kanban view",permalink:"/tags/kanban-view"},{label:"Grid view",permalink:"/tags/grid-view"}],version:"current",sidebarPosition:40,frontMatter:{title:"Sorting records",description:"Learn how to sort records in NocoDB.",tags:["Table operations","Sort","Gallery view","Kanban view","Grid view"],keywords:["NocoDB table","sort","sort records"]},sidebar:"tutorialSidebar",previous:{title:"Filtering records",permalink:"/table-operations/filter"},next:{title:"Grouping records",permalink:"/table-operations/group-by"}},s={},c=[{value:"Adding or Editing Sort",id:"adding-or-editing-sort",level:3},{value:"Deleting Sort",id:"deleting-sort",level:3},{value:"Related topics",id:"related-topics",level:3}],p={toc:c},d="wrapper";function u(e){let{components:t,...i}=e;return(0,n.kt)(d,(0,o.Z)({},p,i,{components:t,mdxType:"MDXLayout"}),(0,n.kt)("p",null,"Sorting enables you to arrange your data alphabetically (A \u2192 Z) or (Z \u2192 A) for text based types and in ascending or descending order for numerical types. NocoDB supports nested sorting, allowing you to select fields and the order in which to apply nested sorting. "),(0,n.kt)("h3",{id:"adding-or-editing-sort"},"Adding or Editing Sort"),(0,n.kt)("ol",null,(0,n.kt)("li",{parentName:"ol"},"Click the ",(0,n.kt)("inlineCode",{parentName:"li"},"Sort")," button in the toolbar menu."),(0,n.kt)("li",{parentName:"ol"},"Choose the ",(0,n.kt)("inlineCode",{parentName:"li"},"Field")," to sort by."),(0,n.kt)("li",{parentName:"ol"},"Configure the sorting ",(0,n.kt)("inlineCode",{parentName:"li"},"Direction")," : ascending or descending")),(0,n.kt)("p",null,(0,n.kt)("img",{alt:"Sort Field",src:r(87792).Z,width:"2304",height:"1020"})),(0,n.kt)("p",null,(0,n.kt)("img",{alt:"Sort Direction",src:r(56722).Z,width:"2306",height:"858"})),(0,n.kt)("ul",null,(0,n.kt)("li",{parentName:"ul"},"You can configure multiple fields for subsequent-level sorting.")),(0,n.kt)("p",null,(0,n.kt)("img",{alt:"Nested Sorting",src:r(41967).Z,width:"2306",height:"940"})),(0,n.kt)("admonition",{type:"info"},(0,n.kt)("p",{parentName:"admonition"},"Field configured at the top will be used for the first-level sorting, followed by subsequent fields in a top-down order")),(0,n.kt)("h3",{id:"deleting-sort"},"Deleting Sort"),(0,n.kt)("ul",null,(0,n.kt)("li",{parentName:"ul"},"Click the ",(0,n.kt)("inlineCode",{parentName:"li"},"Sort")," button in the toolbar.",(0,n.kt)("ul",{parentName:"li"},(0,n.kt)("li",{parentName:"ul"},"Click on the bin icon to the right of the sort you wish to delete.")))),(0,n.kt)("p",null,(0,n.kt)("img",{alt:"Delete Sorting",src:r(25969).Z,width:"2306",height:"940"})),(0,n.kt)("h3",{id:"related-topics"},"Related topics"),(0,n.kt)("ul",null,(0,n.kt)("li",{parentName:"ul"},(0,n.kt)("a",{parentName:"li",href:"field-operations"},"Field operations")),(0,n.kt)("li",{parentName:"ul"},(0,n.kt)("a",{parentName:"li",href:"filter"},"Filter")),(0,n.kt)("li",{parentName:"ul"},(0,n.kt)("a",{parentName:"li",href:"group-by"},"GroupBy")),(0,n.kt)("li",{parentName:"ul"},(0,n.kt)("a",{parentName:"li",href:"row-height"},"record height")),(0,n.kt)("li",{parentName:"ul"},(0,n.kt)("a",{parentName:"li",href:"search"},"Quick Search")),(0,n.kt)("li",{parentName:"ul"},(0,n.kt)("a",{parentName:"li",href:"download"},"Download"))))}u.isMDXComponent=!0},87792:(e,t,r)=>{r.d(t,{Z:()=>o});const o=r.p+"assets/images/sort-1-fa0fe0c81f35a773f6c03ae98c05751f.png"},56722:(e,t,r)=>{r.d(t,{Z:()=>o});const o=r.p+"assets/images/sort-2-9b1d1e39e76dca86dbf63d9c4d59f940.png"},41967:(e,t,r)=>{r.d(t,{Z:()=>o});const o=r.p+"assets/images/sort-3-3b0cf33ff1728c5649bcf6de7a5073ff.png"},25969:(e,t,r)=>{r.d(t,{Z:()=>o});const o=r.p+"assets/images/sort-4-124856ebba5f7b4ca9d8cc67ff97a32b.png"}}]); |