{"id":247,"date":"2021-03-23T13:06:53","date_gmt":"2021-03-23T13:06:53","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/?page_id=247"},"modified":"2021-03-25T09:21:52","modified_gmt":"2021-03-25T09:21:52","slug":"sorting-records","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/national-4\/sorting-records\/","title":{"rendered":"Sorting Records"},"content":{"rendered":"<ul>\n<li>Click on the &#8220;Browse Data&#8221; tab, and select the table to edit:<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-353\" src=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25091510\/DB4SQL-browse-table.png\" alt=\"\" width=\"522\" height=\"62\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25091510\/DB4SQL-browse-table.png 522w, https:\/\/glow-prod-sh.s3.eu-west-1.amazonaws.com\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25091510\/DB4SQL-browse-table-300x36.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELD%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQDnqdD%2Fq%2Be6%2Bb%2FOV6pVLjTeM1XUUtcIw4NYtnpED9oatQIhAPIJsw0YC9sTxTC9xOyzknREJndrxjEM%2FJNSlHqwSAYWKrkFCHkQBRoMMjczNTcwMTk1NDMzIgwUtJTz1AQcO8gf%2BbUqlgWA5lhQGnlnj7oOfDLQaCbhKMFBzemKVNO2QYep87vpKNAAPb9aAc%2FyzwGK7EoqB7Q%2BZjJFh8wpdO%2B3IeXyjPUTV63SgGopTb%2Bcr0CygV%2BTobaZCb1hmrqG%2B1so9cEZ0t%2FQo3ZMK7MzpfdRgqmGchujmYoflKrGYXQN1OaU0dXtuXqJtyapdwFmOwdA1EYm81BLiIG0iBbxywQzl32KYBgi0kD0KBfBVhkZ9hRiIMEh4dTpnOm3cpwnQ9StNCaxy9nuOYfdNkKWmU%2Fz6JT%2Fc25Kaj0BXck2cY1Qwr4i2vHe7uUcr0t9j%2F36LcWkVCwcgC5nz5enMiuBzeSjEgpkUGxvZH4yNyYgFjRHIPjhncn6pJizJAe%2Buk58n2PaVmaiW7tql9492G0zK3Ht58YcaueAdSWBxSAoimGRxpc103W6PFVsJ7oLmG4sAyWhhbqqQIqQqCOBoSVduFh9Z0HZZFQBufCg5%2F%2Ff4J2yi2OGAvxhf%2FDM8fK6DSvXdFu7bR2Zdm5DwEm%2BGGmICHaI6FXiBDkaxTIuRqubcXaH8IRUsdjJ2%2BOV2EDEdZg17qy7bAv1qqz3sF7fGG8W6%2FX%2FsRxDi%2Fw4adIhNtXMMIAy42a9BkNp%2Bhj%2Bsab9xKGf4aocfw4RUC00Rzlc6EAA3yUPTC1FWQai81Xf8lKCmLE1chxjN1R%2BHO0vO3gAhaD5DeSnt1new4gd%2F59ocn6RRqUUA0KXqRnGsZB%2BmPsR0T71gShVVR0cBGt4zp1rdmJ1SjoHdORJrUpG4ahufU8IEG%2BE6FPn7NQJaZxWqmegPQwK7n8AbMv3qXHKA50SkwPVZ9vpV6gr5C8if64mRMdtu2nXsk1GdyzxxI2aVkwRSS5zfizWtvLNF8r1iRKwojDi3OjWBjqwATR1PZnuGPCYyxuwxq00GOQTzeGY6F5DNXSM0iS6P17S%2FrDGUCLBQhL0qdfoL0LgAvSEfTz4pcalYgihB27dpnSqU%2FFjwQgaQf8cAfm%2FAU%2Bv1V44BRNlHrOD%2Bmem6KjB4a1C9nuEr2SLx6BzYEpJ6A%2BzqYlWF1iN7jG7JHx%2FrH1lFimtt4zFSPG2mpecK4q%2Fnxb2w5PSLNmgEXSoch6qMpGkvJLHxoa0vsmicAtZyn2J&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXPFB5WQP%2F20261022%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261022T160408Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=05a5c9c6005bb161f8a5217362493c97f55489554089ee720bd9514332487759 300w\" sizes=\"(max-width: 522px) 100vw, 522px\" \/><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li>To sort the records into <strong>ascending\/alphabetical order<\/strong>, click on the column name (town):<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-350\" src=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25091027\/DB4SQL-sorting-1.png\" alt=\"\" width=\"742\" height=\"172\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25091027\/DB4SQL-sorting-1.png 742w, https:\/\/glow-prod-sh.s3.eu-west-1.amazonaws.com\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25091027\/DB4SQL-sorting-1-300x70.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELD%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQDnqdD%2Fq%2Be6%2Bb%2FOV6pVLjTeM1XUUtcIw4NYtnpED9oatQIhAPIJsw0YC9sTxTC9xOyzknREJndrxjEM%2FJNSlHqwSAYWKrkFCHkQBRoMMjczNTcwMTk1NDMzIgwUtJTz1AQcO8gf%2BbUqlgWA5lhQGnlnj7oOfDLQaCbhKMFBzemKVNO2QYep87vpKNAAPb9aAc%2FyzwGK7EoqB7Q%2BZjJFh8wpdO%2B3IeXyjPUTV63SgGopTb%2Bcr0CygV%2BTobaZCb1hmrqG%2B1so9cEZ0t%2FQo3ZMK7MzpfdRgqmGchujmYoflKrGYXQN1OaU0dXtuXqJtyapdwFmOwdA1EYm81BLiIG0iBbxywQzl32KYBgi0kD0KBfBVhkZ9hRiIMEh4dTpnOm3cpwnQ9StNCaxy9nuOYfdNkKWmU%2Fz6JT%2Fc25Kaj0BXck2cY1Qwr4i2vHe7uUcr0t9j%2F36LcWkVCwcgC5nz5enMiuBzeSjEgpkUGxvZH4yNyYgFjRHIPjhncn6pJizJAe%2Buk58n2PaVmaiW7tql9492G0zK3Ht58YcaueAdSWBxSAoimGRxpc103W6PFVsJ7oLmG4sAyWhhbqqQIqQqCOBoSVduFh9Z0HZZFQBufCg5%2F%2Ff4J2yi2OGAvxhf%2FDM8fK6DSvXdFu7bR2Zdm5DwEm%2BGGmICHaI6FXiBDkaxTIuRqubcXaH8IRUsdjJ2%2BOV2EDEdZg17qy7bAv1qqz3sF7fGG8W6%2FX%2FsRxDi%2Fw4adIhNtXMMIAy42a9BkNp%2Bhj%2Bsab9xKGf4aocfw4RUC00Rzlc6EAA3yUPTC1FWQai81Xf8lKCmLE1chxjN1R%2BHO0vO3gAhaD5DeSnt1new4gd%2F59ocn6RRqUUA0KXqRnGsZB%2BmPsR0T71gShVVR0cBGt4zp1rdmJ1SjoHdORJrUpG4ahufU8IEG%2BE6FPn7NQJaZxWqmegPQwK7n8AbMv3qXHKA50SkwPVZ9vpV6gr5C8if64mRMdtu2nXsk1GdyzxxI2aVkwRSS5zfizWtvLNF8r1iRKwojDi3OjWBjqwATR1PZnuGPCYyxuwxq00GOQTzeGY6F5DNXSM0iS6P17S%2FrDGUCLBQhL0qdfoL0LgAvSEfTz4pcalYgihB27dpnSqU%2FFjwQgaQf8cAfm%2FAU%2Bv1V44BRNlHrOD%2Bmem6KjB4a1C9nuEr2SLx6BzYEpJ6A%2BzqYlWF1iN7jG7JHx%2FrH1lFimtt4zFSPG2mpecK4q%2Fnxb2w5PSLNmgEXSoch6qMpGkvJLHxoa0vsmicAtZyn2J&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXPFB5WQP%2F20261022%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261022T160408Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=0c8a5e1b8c93f615061dfe0c409d68e7164949a7c8d4065cb292d558ce466c5e 300w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li>To sort the records into <strong>descending order<\/strong>, click on the column name again:<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-351\" src=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25091029\/DB4SQL-sorting-2.png\" alt=\"\" width=\"742\" height=\"173\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25091029\/DB4SQL-sorting-2.png 742w, https:\/\/glow-prod-sh.s3.eu-west-1.amazonaws.com\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25091029\/DB4SQL-sorting-2-300x70.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELD%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQDnqdD%2Fq%2Be6%2Bb%2FOV6pVLjTeM1XUUtcIw4NYtnpED9oatQIhAPIJsw0YC9sTxTC9xOyzknREJndrxjEM%2FJNSlHqwSAYWKrkFCHkQBRoMMjczNTcwMTk1NDMzIgwUtJTz1AQcO8gf%2BbUqlgWA5lhQGnlnj7oOfDLQaCbhKMFBzemKVNO2QYep87vpKNAAPb9aAc%2FyzwGK7EoqB7Q%2BZjJFh8wpdO%2B3IeXyjPUTV63SgGopTb%2Bcr0CygV%2BTobaZCb1hmrqG%2B1so9cEZ0t%2FQo3ZMK7MzpfdRgqmGchujmYoflKrGYXQN1OaU0dXtuXqJtyapdwFmOwdA1EYm81BLiIG0iBbxywQzl32KYBgi0kD0KBfBVhkZ9hRiIMEh4dTpnOm3cpwnQ9StNCaxy9nuOYfdNkKWmU%2Fz6JT%2Fc25Kaj0BXck2cY1Qwr4i2vHe7uUcr0t9j%2F36LcWkVCwcgC5nz5enMiuBzeSjEgpkUGxvZH4yNyYgFjRHIPjhncn6pJizJAe%2Buk58n2PaVmaiW7tql9492G0zK3Ht58YcaueAdSWBxSAoimGRxpc103W6PFVsJ7oLmG4sAyWhhbqqQIqQqCOBoSVduFh9Z0HZZFQBufCg5%2F%2Ff4J2yi2OGAvxhf%2FDM8fK6DSvXdFu7bR2Zdm5DwEm%2BGGmICHaI6FXiBDkaxTIuRqubcXaH8IRUsdjJ2%2BOV2EDEdZg17qy7bAv1qqz3sF7fGG8W6%2FX%2FsRxDi%2Fw4adIhNtXMMIAy42a9BkNp%2Bhj%2Bsab9xKGf4aocfw4RUC00Rzlc6EAA3yUPTC1FWQai81Xf8lKCmLE1chxjN1R%2BHO0vO3gAhaD5DeSnt1new4gd%2F59ocn6RRqUUA0KXqRnGsZB%2BmPsR0T71gShVVR0cBGt4zp1rdmJ1SjoHdORJrUpG4ahufU8IEG%2BE6FPn7NQJaZxWqmegPQwK7n8AbMv3qXHKA50SkwPVZ9vpV6gr5C8if64mRMdtu2nXsk1GdyzxxI2aVkwRSS5zfizWtvLNF8r1iRKwojDi3OjWBjqwATR1PZnuGPCYyxuwxq00GOQTzeGY6F5DNXSM0iS6P17S%2FrDGUCLBQhL0qdfoL0LgAvSEfTz4pcalYgihB27dpnSqU%2FFjwQgaQf8cAfm%2FAU%2Bv1V44BRNlHrOD%2Bmem6KjB4a1C9nuEr2SLx6BzYEpJ6A%2BzqYlWF1iN7jG7JHx%2FrH1lFimtt4zFSPG2mpecK4q%2Fnxb2w5PSLNmgEXSoch6qMpGkvJLHxoa0vsmicAtZyn2J&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXPFB5WQP%2F20261022%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261022T160408Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=bba3f3bfd73e90647bc1c35c4dd2cb3e0617806975d92b65677f421da468e093 300w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/li>\n<\/ul>\n<ul>\n<li>To <strong>remove any sorting<\/strong>, click on the &#8220;Reset order&#8221; button <img decoding=\"async\" class=\"alignnone size-full wp-image-349\" src=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25091027\/DB4SQL-button-sorting-2.png\" alt=\"\" width=\"15\" height=\"16\" \/>:<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-352\" src=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25091030\/DB4SQL-button-sorting-1.png\" alt=\"\" width=\"422\" height=\"59\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25091030\/DB4SQL-button-sorting-1.png 422w, https:\/\/glow-prod-sh.s3.eu-west-1.amazonaws.com\/sh\/public\/ahscomputingsql\/uploads\/sites\/3269\/2021\/03\/25091030\/DB4SQL-button-sorting-1-300x42.png?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&amp;X-Amz-Security-Token=IQoJb3JpZ2luX2VjELD%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJIMEYCIQDnqdD%2Fq%2Be6%2Bb%2FOV6pVLjTeM1XUUtcIw4NYtnpED9oatQIhAPIJsw0YC9sTxTC9xOyzknREJndrxjEM%2FJNSlHqwSAYWKrkFCHkQBRoMMjczNTcwMTk1NDMzIgwUtJTz1AQcO8gf%2BbUqlgWA5lhQGnlnj7oOfDLQaCbhKMFBzemKVNO2QYep87vpKNAAPb9aAc%2FyzwGK7EoqB7Q%2BZjJFh8wpdO%2B3IeXyjPUTV63SgGopTb%2Bcr0CygV%2BTobaZCb1hmrqG%2B1so9cEZ0t%2FQo3ZMK7MzpfdRgqmGchujmYoflKrGYXQN1OaU0dXtuXqJtyapdwFmOwdA1EYm81BLiIG0iBbxywQzl32KYBgi0kD0KBfBVhkZ9hRiIMEh4dTpnOm3cpwnQ9StNCaxy9nuOYfdNkKWmU%2Fz6JT%2Fc25Kaj0BXck2cY1Qwr4i2vHe7uUcr0t9j%2F36LcWkVCwcgC5nz5enMiuBzeSjEgpkUGxvZH4yNyYgFjRHIPjhncn6pJizJAe%2Buk58n2PaVmaiW7tql9492G0zK3Ht58YcaueAdSWBxSAoimGRxpc103W6PFVsJ7oLmG4sAyWhhbqqQIqQqCOBoSVduFh9Z0HZZFQBufCg5%2F%2Ff4J2yi2OGAvxhf%2FDM8fK6DSvXdFu7bR2Zdm5DwEm%2BGGmICHaI6FXiBDkaxTIuRqubcXaH8IRUsdjJ2%2BOV2EDEdZg17qy7bAv1qqz3sF7fGG8W6%2FX%2FsRxDi%2Fw4adIhNtXMMIAy42a9BkNp%2Bhj%2Bsab9xKGf4aocfw4RUC00Rzlc6EAA3yUPTC1FWQai81Xf8lKCmLE1chxjN1R%2BHO0vO3gAhaD5DeSnt1new4gd%2F59ocn6RRqUUA0KXqRnGsZB%2BmPsR0T71gShVVR0cBGt4zp1rdmJ1SjoHdORJrUpG4ahufU8IEG%2BE6FPn7NQJaZxWqmegPQwK7n8AbMv3qXHKA50SkwPVZ9vpV6gr5C8if64mRMdtu2nXsk1GdyzxxI2aVkwRSS5zfizWtvLNF8r1iRKwojDi3OjWBjqwATR1PZnuGPCYyxuwxq00GOQTzeGY6F5DNXSM0iS6P17S%2FrDGUCLBQhL0qdfoL0LgAvSEfTz4pcalYgihB27dpnSqU%2FFjwQgaQf8cAfm%2FAU%2Bv1V44BRNlHrOD%2Bmem6KjB4a1C9nuEr2SLx6BzYEpJ6A%2BzqYlWF1iN7jG7JHx%2FrH1lFimtt4zFSPG2mpecK4q%2Fnxb2w5PSLNmgEXSoch6qMpGkvJLHxoa0vsmicAtZyn2J&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UXPFB5WQP%2F20261022%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20261022T160408Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=5e4313532925948b189c1d23d787ad85f6e733c8fa2ee38c911d76ecfbdb6bf4 300w\" sizes=\"(max-width: 422px) 100vw, 422px\" \/><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Click on the &#8220;Browse Data&#8221; tab, and select the table to edit: &nbsp; To sort the records into ascending\/alphabetical order, click on the column name (town): &nbsp; To sort the records into descending order, click on the column name again: To remove any sorting, click on the &#8220;Reset order&#8221; button :<\/p>\n","protected":false},"author":7,"featured_media":0,"parent":226,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-247","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/247","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/comments?post=247"}],"version-history":[{"count":9,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/247\/revisions"}],"predecessor-version":[{"id":360,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/247\/revisions\/360"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/226"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/media?parent=247"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}