X-Git-Url: https://git.ktnx.net/?a=blobdiff_plain;ds=sidebyside;f=app%2Fsrc%2Fmain%2Fjava%2Fnet%2Fktnx%2Fmobileledger%2Fdao%2FPatternHeaderDAO.java;h=a8ef1533720c9ed1da0df2cb6dda5f1570b6dc04;hb=72bbdba090181d9d725cd1d80f96e6ea1ab4c28c;hp=4f4dcd7a8c5f6c7ada3ce4897430cb77dd640573;hpb=c2bc2a73948d991a4c827d230ae93e239401b9b9;p=mobile-ledger.git

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 4f4dcd7a..a8ef1533 100644
--- a/app/src/main/java/net/ktnx/mobileledger/dao/PatternHeaderDAO.java
+++ b/app/src/main/java/net/ktnx/mobileledger/dao/PatternHeaderDAO.java
@@ -23,9 +23,11 @@ import androidx.room.Delete;
 import androidx.room.Insert;
 import androidx.room.OnConflictStrategy;
 import androidx.room.Query;
+import androidx.room.Transaction;
 import androidx.room.Update;
 
 import net.ktnx.mobileledger.db.PatternHeader;
+import net.ktnx.mobileledger.db.PatternWithAccounts;
 
 import java.util.List;
 
@@ -40,14 +42,13 @@ public interface PatternHeaderDAO {
     @Delete
     void delete(PatternHeader item);
 
-    @Query("SELECT * FROM patterns ORDER BY UPPER(name) NULLS FIRST")
+    @Query("SELECT * FROM patterns ORDER BY UPPER(name)")
     LiveData<List<PatternHeader>> getPatterns();
 
     @Query("SELECT * FROM patterns WHERE id = :id")
     LiveData<PatternHeader> getPattern(Long id);
 
-//    not useful for now
-//    @Transaction
-//    @Query("SELECT * FROM patterns")
-//    List<PatternWithAccounts> getPatternsWithAccounts();
+    @Transaction
+    @Query("SELECT * FROM patterns WHERE id = :id")
+    LiveData<PatternWithAccounts> getPatternWithAccounts(Long id);
 }