You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
final maps =await db.rawQuery('SELECT t.*, c.${CategoryTransactionFields.name} as ${TransactionFields.categoryName}, c.${CategoryTransactionFields.color} as ${TransactionFields.categoryColor}, c.${CategoryTransactionFields.symbol} as ${TransactionFields.categorySymbol}, b1.${BankAccountFields.name} as ${TransactionFields.bankAccountName}, b2.${BankAccountFields.name} as ${TransactionFields.bankAccountTransferName} FROM $transactionTable as t LEFT JOIN $categoryTransactionTable as c ON t.${TransactionFields.idCategory} = c.${CategoryTransactionFields.id} LEFT JOIN $bankAccountTable as b1 ON t.${TransactionFields.idBankAccount} = b1.${BankAccountFields.id} LEFT JOIN $bankAccountTable as b2 ON t.${TransactionFields.idBankAccountTransfer} = b2.${BankAccountFields.id} WHERE t.${TransactionFields.id} = ?', [id]);
if (maps.isNotEmpty) {
returnTransaction.fromJson(maps.first);
} else {
throwException('ID $id not found');
}
}
The fix is easy but I would rather close this issue before moving on to push the whole PR.
The text was updated successfully, but these errors were encountered:
While working on #149, I have noticed that this query returns an error:
sossoldi/lib/model/transaction.dart
Lines 195 to 204 in 366238e
The fix is easy but I would rather close this issue before moving on to push the whole PR.
The text was updated successfully, but these errors were encountered: