about summary refs log tree commit diff
diff options
context:
space:
mode:
authorJune McEnroe <june@causal.agency>2020-07-11 19:05:48 -0400
committerJune McEnroe <june@causal.agency>2020-07-11 19:05:48 -0400
commitc68d3c98973c276c46227db0e3968b4e97d90831 (patch)
tree1b074cc8010631b991ae3922f4bf132d820b2713
parentDim search result context links (diff)
downloadscooper-c68d3c98973c276c46227db0e3968b4e97d90831.tar.gz
scooper-c68d3c98973c276c46227db0e3968b4e97d90831.zip
Sort networks and contexts case-insensitively
-rw-r--r--contexts.c2
-rw-r--r--networks.c2
2 files changed, 2 insertions, 2 deletions
diff --git a/contexts.c b/contexts.c
index e7f44e4..39974bb 100644
--- a/contexts.c
+++ b/contexts.c
@@ -38,7 +38,7 @@ const char *ContextsQuery = SQL(
 		SELECT name, query
 		FROM contexts
 		WHERE network = :network AND query <= NOT :public
-		ORDER BY query, name
+		ORDER BY query, name COLLATE NOCASE
 	)
 	SELECT name, query, 1 FROM activeContexts
 	UNION ALL
diff --git a/networks.c b/networks.c
index 4fcd476..c0f171a 100644
--- a/networks.c
+++ b/networks.c
@@ -36,7 +36,7 @@ const char *NetworksQuery = SQL(
 	), allNetworks AS (
 		SELECT DISTINCT network
 		FROM contexts
-		ORDER BY network
+		ORDER BY network COLLATE NOCASE
 	)
 	SELECT network, 1 FROM activeNetworks
 	UNION ALL