X-Git-Url: https://git.ktnx.net/?p=mobile-ledger.git;a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fjava%2Fnet%2Fktnx%2Fmobileledger%2Fdao%2FAccountDAO.java;h=677fa81e0080631e9dcb730b32add5ca0056b7ab;hp=0cfed1b64c2e5ad4d13845197839069356a54c80;hb=05b38a3497aa098a5164d1ae85b13a6f08bf85a2;hpb=a6f4bdc4089cffc79592f2d2256358de14055116 diff --git a/app/src/main/java/net/ktnx/mobileledger/dao/AccountDAO.java b/app/src/main/java/net/ktnx/mobileledger/dao/AccountDAO.java index 0cfed1b6..677fa81e 100644 --- a/app/src/main/java/net/ktnx/mobileledger/dao/AccountDAO.java +++ b/app/src/main/java/net/ktnx/mobileledger/dao/AccountDAO.java @@ -119,6 +119,7 @@ public abstract class AccountDAO extends BaseDAO { public abstract List lookupNamesInProfileByNameSync(long profileId, @NonNull String term); + @Transaction @Query("SELECT * FROM accounts " + "WHERE profile_id=:profileId AND name_upper LIKE '%%'||:term||'%%' " + "ORDER BY CASE WHEN name_upper LIKE :term||'%%' THEN 1 " + @@ -126,8 +127,7 @@ public abstract class AccountDAO extends BaseDAO { " WHEN name_upper LIKE '%% '||:term||'%%' THEN 3 " + " ELSE 9 END, name_upper, rowid ") public abstract List lookupWithAmountsInProfileByNameSync(long profileId, - @NonNull - String term); + @NonNull String term); @Query("SELECT DISTINCT name, CASE WHEN name_upper LIKE :term||'%%' THEN 1 " + " WHEN name_upper LIKE '%%:'||:term||'%%' THEN 2 " +