- sql = "SELECT distinct tr.id, tr.date from transactions tr JOIN " +
- "transaction_accounts ta " +
- "ON ta.transaction_id=tr.id AND ta.profile=tr.profile WHERE tr.profile=? " +
- "and ta.account_name LIKE ?||'%' AND ta" +
- ".amount <> 0 ORDER BY tr.date desc, tr.id desc";
- params = new String[]{profile_uuid, filterAccName[0]};
+ transactions = DB.get()
+ .getTransactionDAO()
+ .getAllWithAccountsFilteredSync(profileId, accFilter);