{"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 loading=\"lazy\" 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=IQoJb3JpZ2luX2VjEO3%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCIET%2Bx01bOd6BQbHbN5Jy%2FjqAqWf6j75Gp4s%2FMm%2FCEH7UAiBGWj4NdI7cl2UrTZ5%2BpR6eU4SDM9sFq7dARGD%2B5pnsUyrCBQi1%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F8BEAUaDDI3MzU3MDE5NTQzMyIMlTWW%2B1JTZOGRj681KpYF7YqtDjsrf3AnjjCuPsoN%2BZaiGW%2F3x%2Bmvm5wVjhudQGOXZcfu6zW6nfrakEsW9FE3yIlvDclKm3fT6xZzrKrozFwtxtSY43e%2FqwWGYWFVSkIfRyH0WSim1kO40Pl6miFqo%2FTNSCzOdLmhTkpztffQJ8080Pr5JI6DPIAgto5d3uVIkfFFCItO5E0iHV4tWFHrt2p5r55XrNZYCtjWp5haqNSiOfNGduYylS2WAECg5Z2sznjPgMavZAfXFjkEjh8FG6JKKEa8ds6bdBc%2BDxd%2BZ0o%2FY%2F6TPHRjgy5p8nkfyXpQecZjF65cyVl9B9q3JoQqxqjD41JY64AYLvmF4K9PFDQC6HBplMavkC2lTgkjgc8HFeNSXLqhS7Mb2J34X1AFQmWnpxLs2uZMdd0zM6aK%2B4H14CJ%2BafV8I1vc3fIVHF%2Bu%2BN86A%2BG53dCnY2WwPsFr1tQ6EMqvf4cH2Chk95kqzTnDXCGUHrIMW1uPv7gL3NNAybY7LT2jUfpL9AA9b0jjKHk6yhIFw3ZkzX1mkO%2BXxVxCRord3dkZg4aqbrA5ugxxxWu8DkbfQ5V7LGvyRuY9i0yYuV%2FCHWO2H%2BCmT5o3%2FryJ5MC8VAsE5g8fJJPJs9LrXENg1SihAD4piP%2B8%2Bmd1t6p0qA9pnYuU8qSdPU%2BwRnLQZUIGow%2FF76mB4lhqevvsISg73muXz2eZoULX840Mq7d6awreQdCd9rAmrqCGG53OABuQQQXLS5e7R0yJMnGuAQ2XGNzYdvlhdSc5RuoOASgjKoZMQGIX6kO%2FsgwGBGcMrzwgnZYCtxdkWuSfOfhh9q4LI9iSQsN9hwMC5xyAwjBsk0r%2B%2FZr7onF6UH3o%2Bor%2B%2Fyc9aG9oHaKmE%2BJGOqeYDMpnUSEwg6Wq0AY6sgFYFekOgboKM4ECtV2eJe35DjI5QU3ik%2BEewqh1yJt%2BjXMv1rg4rjUz%2FcxBZiXSMvYBiB4wt9S6fstPBJtIDpvT6peSihYql8qpTAx9E6hsqTpjrREb6crnUTwo0NsXv1g80p0wIhqkkGlmL0aXQUJxfnJ1xXzAqmKZQJymXfemgPUDORcvYseI9Ei4yqIo60DmvfnXhk1uhIwQfoL9n8GWB316U8UZWWlI%2FMVSDARFYUCg&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UYXEBP2WV%2F20260518%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260518T050111Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=5247f302906f991931a2085934c7ea11b4d108ca3b1b1eb14335ba840ccf0d7d 300w\" sizes=\"auto, (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 loading=\"lazy\" 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=IQoJb3JpZ2luX2VjEO3%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCIET%2Bx01bOd6BQbHbN5Jy%2FjqAqWf6j75Gp4s%2FMm%2FCEH7UAiBGWj4NdI7cl2UrTZ5%2BpR6eU4SDM9sFq7dARGD%2B5pnsUyrCBQi1%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F8BEAUaDDI3MzU3MDE5NTQzMyIMlTWW%2B1JTZOGRj681KpYF7YqtDjsrf3AnjjCuPsoN%2BZaiGW%2F3x%2Bmvm5wVjhudQGOXZcfu6zW6nfrakEsW9FE3yIlvDclKm3fT6xZzrKrozFwtxtSY43e%2FqwWGYWFVSkIfRyH0WSim1kO40Pl6miFqo%2FTNSCzOdLmhTkpztffQJ8080Pr5JI6DPIAgto5d3uVIkfFFCItO5E0iHV4tWFHrt2p5r55XrNZYCtjWp5haqNSiOfNGduYylS2WAECg5Z2sznjPgMavZAfXFjkEjh8FG6JKKEa8ds6bdBc%2BDxd%2BZ0o%2FY%2F6TPHRjgy5p8nkfyXpQecZjF65cyVl9B9q3JoQqxqjD41JY64AYLvmF4K9PFDQC6HBplMavkC2lTgkjgc8HFeNSXLqhS7Mb2J34X1AFQmWnpxLs2uZMdd0zM6aK%2B4H14CJ%2BafV8I1vc3fIVHF%2Bu%2BN86A%2BG53dCnY2WwPsFr1tQ6EMqvf4cH2Chk95kqzTnDXCGUHrIMW1uPv7gL3NNAybY7LT2jUfpL9AA9b0jjKHk6yhIFw3ZkzX1mkO%2BXxVxCRord3dkZg4aqbrA5ugxxxWu8DkbfQ5V7LGvyRuY9i0yYuV%2FCHWO2H%2BCmT5o3%2FryJ5MC8VAsE5g8fJJPJs9LrXENg1SihAD4piP%2B8%2Bmd1t6p0qA9pnYuU8qSdPU%2BwRnLQZUIGow%2FF76mB4lhqevvsISg73muXz2eZoULX840Mq7d6awreQdCd9rAmrqCGG53OABuQQQXLS5e7R0yJMnGuAQ2XGNzYdvlhdSc5RuoOASgjKoZMQGIX6kO%2FsgwGBGcMrzwgnZYCtxdkWuSfOfhh9q4LI9iSQsN9hwMC5xyAwjBsk0r%2B%2FZr7onF6UH3o%2Bor%2B%2Fyc9aG9oHaKmE%2BJGOqeYDMpnUSEwg6Wq0AY6sgFYFekOgboKM4ECtV2eJe35DjI5QU3ik%2BEewqh1yJt%2BjXMv1rg4rjUz%2FcxBZiXSMvYBiB4wt9S6fstPBJtIDpvT6peSihYql8qpTAx9E6hsqTpjrREb6crnUTwo0NsXv1g80p0wIhqkkGlmL0aXQUJxfnJ1xXzAqmKZQJymXfemgPUDORcvYseI9Ei4yqIo60DmvfnXhk1uhIwQfoL9n8GWB316U8UZWWlI%2FMVSDARFYUCg&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UYXEBP2WV%2F20260518%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260518T050112Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=899&amp;X-Amz-Signature=8cd737970ee465a3d3469dcb6d7dee78cd919ac7518406e2af284832338447e4 300w\" sizes=\"auto, (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 loading=\"lazy\" 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=IQoJb3JpZ2luX2VjEO3%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCIET%2Bx01bOd6BQbHbN5Jy%2FjqAqWf6j75Gp4s%2FMm%2FCEH7UAiBGWj4NdI7cl2UrTZ5%2BpR6eU4SDM9sFq7dARGD%2B5pnsUyrCBQi1%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F8BEAUaDDI3MzU3MDE5NTQzMyIMlTWW%2B1JTZOGRj681KpYF7YqtDjsrf3AnjjCuPsoN%2BZaiGW%2F3x%2Bmvm5wVjhudQGOXZcfu6zW6nfrakEsW9FE3yIlvDclKm3fT6xZzrKrozFwtxtSY43e%2FqwWGYWFVSkIfRyH0WSim1kO40Pl6miFqo%2FTNSCzOdLmhTkpztffQJ8080Pr5JI6DPIAgto5d3uVIkfFFCItO5E0iHV4tWFHrt2p5r55XrNZYCtjWp5haqNSiOfNGduYylS2WAECg5Z2sznjPgMavZAfXFjkEjh8FG6JKKEa8ds6bdBc%2BDxd%2BZ0o%2FY%2F6TPHRjgy5p8nkfyXpQecZjF65cyVl9B9q3JoQqxqjD41JY64AYLvmF4K9PFDQC6HBplMavkC2lTgkjgc8HFeNSXLqhS7Mb2J34X1AFQmWnpxLs2uZMdd0zM6aK%2B4H14CJ%2BafV8I1vc3fIVHF%2Bu%2BN86A%2BG53dCnY2WwPsFr1tQ6EMqvf4cH2Chk95kqzTnDXCGUHrIMW1uPv7gL3NNAybY7LT2jUfpL9AA9b0jjKHk6yhIFw3ZkzX1mkO%2BXxVxCRord3dkZg4aqbrA5ugxxxWu8DkbfQ5V7LGvyRuY9i0yYuV%2FCHWO2H%2BCmT5o3%2FryJ5MC8VAsE5g8fJJPJs9LrXENg1SihAD4piP%2B8%2Bmd1t6p0qA9pnYuU8qSdPU%2BwRnLQZUIGow%2FF76mB4lhqevvsISg73muXz2eZoULX840Mq7d6awreQdCd9rAmrqCGG53OABuQQQXLS5e7R0yJMnGuAQ2XGNzYdvlhdSc5RuoOASgjKoZMQGIX6kO%2FsgwGBGcMrzwgnZYCtxdkWuSfOfhh9q4LI9iSQsN9hwMC5xyAwjBsk0r%2B%2FZr7onF6UH3o%2Bor%2B%2Fyc9aG9oHaKmE%2BJGOqeYDMpnUSEwg6Wq0AY6sgFYFekOgboKM4ECtV2eJe35DjI5QU3ik%2BEewqh1yJt%2BjXMv1rg4rjUz%2FcxBZiXSMvYBiB4wt9S6fstPBJtIDpvT6peSihYql8qpTAx9E6hsqTpjrREb6crnUTwo0NsXv1g80p0wIhqkkGlmL0aXQUJxfnJ1xXzAqmKZQJymXfemgPUDORcvYseI9Ei4yqIo60DmvfnXhk1uhIwQfoL9n8GWB316U8UZWWlI%2FMVSDARFYUCg&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UYXEBP2WV%2F20260518%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260518T050112Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=638d2e6f9b8b61d7079a8de01703b3026a0024276817078997e23adc92651ccb 300w\" sizes=\"auto, (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 loading=\"lazy\" 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 loading=\"lazy\" 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=IQoJb3JpZ2luX2VjEO3%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMSJGMEQCIET%2Bx01bOd6BQbHbN5Jy%2FjqAqWf6j75Gp4s%2FMm%2FCEH7UAiBGWj4NdI7cl2UrTZ5%2BpR6eU4SDM9sFq7dARGD%2B5pnsUyrCBQi1%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F8BEAUaDDI3MzU3MDE5NTQzMyIMlTWW%2B1JTZOGRj681KpYF7YqtDjsrf3AnjjCuPsoN%2BZaiGW%2F3x%2Bmvm5wVjhudQGOXZcfu6zW6nfrakEsW9FE3yIlvDclKm3fT6xZzrKrozFwtxtSY43e%2FqwWGYWFVSkIfRyH0WSim1kO40Pl6miFqo%2FTNSCzOdLmhTkpztffQJ8080Pr5JI6DPIAgto5d3uVIkfFFCItO5E0iHV4tWFHrt2p5r55XrNZYCtjWp5haqNSiOfNGduYylS2WAECg5Z2sznjPgMavZAfXFjkEjh8FG6JKKEa8ds6bdBc%2BDxd%2BZ0o%2FY%2F6TPHRjgy5p8nkfyXpQecZjF65cyVl9B9q3JoQqxqjD41JY64AYLvmF4K9PFDQC6HBplMavkC2lTgkjgc8HFeNSXLqhS7Mb2J34X1AFQmWnpxLs2uZMdd0zM6aK%2B4H14CJ%2BafV8I1vc3fIVHF%2Bu%2BN86A%2BG53dCnY2WwPsFr1tQ6EMqvf4cH2Chk95kqzTnDXCGUHrIMW1uPv7gL3NNAybY7LT2jUfpL9AA9b0jjKHk6yhIFw3ZkzX1mkO%2BXxVxCRord3dkZg4aqbrA5ugxxxWu8DkbfQ5V7LGvyRuY9i0yYuV%2FCHWO2H%2BCmT5o3%2FryJ5MC8VAsE5g8fJJPJs9LrXENg1SihAD4piP%2B8%2Bmd1t6p0qA9pnYuU8qSdPU%2BwRnLQZUIGow%2FF76mB4lhqevvsISg73muXz2eZoULX840Mq7d6awreQdCd9rAmrqCGG53OABuQQQXLS5e7R0yJMnGuAQ2XGNzYdvlhdSc5RuoOASgjKoZMQGIX6kO%2FsgwGBGcMrzwgnZYCtxdkWuSfOfhh9q4LI9iSQsN9hwMC5xyAwjBsk0r%2B%2FZr7onF6UH3o%2Bor%2B%2Fyc9aG9oHaKmE%2BJGOqeYDMpnUSEwg6Wq0AY6sgFYFekOgboKM4ECtV2eJe35DjI5QU3ik%2BEewqh1yJt%2BjXMv1rg4rjUz%2FcxBZiXSMvYBiB4wt9S6fstPBJtIDpvT6peSihYql8qpTAx9E6hsqTpjrREb6crnUTwo0NsXv1g80p0wIhqkkGlmL0aXQUJxfnJ1xXzAqmKZQJymXfemgPUDORcvYseI9Ei4yqIo60DmvfnXhk1uhIwQfoL9n8GWB316U8UZWWlI%2FMVSDARFYUCg&amp;X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=ASIAT7MQN47UYXEBP2WV%2F20260518%2Feu-west-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20260518T050112Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=900&amp;X-Amz-Signature=c1274b83b9671f8c7694ef649c21b42446b2ba0796694c242de9c64a00ed1809 300w\" sizes=\"auto, (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}]}}