add test text to pattern table and drop position

[mobile-ledger.git] / app / src / main / java / net / ktnx / mobileledger / dao / PatternHeaderDAO.java

diff --git a/app/src/main/java/net/ktnx/mobileledger/dao/PatternHeaderDAO.java b/app/src/main/java/net/ktnx/mobileledger/dao/PatternHeaderDAO.java
index 40659b5b4fa5d765bd66a569d29940981100576f..4f4dcd7a8c5f6c7ada3ce4897430cb77dd640573 100644 (file)
--- a/app/src/main/java/net/ktnx/mobileledger/dao/PatternHeaderDAO.java
+++ b/app/src/main/java/net/ktnx/mobileledger/dao/PatternHeaderDAO.java
@@ -40,7 +40,7 @@ public interface PatternHeaderDAO {
     @Delete
     void delete(PatternHeader item);
 
-    @Query("SELECT * FROM patterns")
+    @Query("SELECT * FROM patterns ORDER BY UPPER(name) NULLS FIRST")
     LiveData<List<PatternHeader>> getPatterns();
 
     @Query("SELECT * FROM patterns WHERE id = :id")