How add rawQuery added ??

[vasanthmn1]

  @Query(
      "SELECT TableOne.*, TableTwo.tableName FROM TableOne LEFT JOIN Party ON TableOne.clientId = TableTwo.id WHERE TableOne.type = :getType ORDER BY TableTwo.clientName  ${order}")
  Future<List<TableOne>> getTableOneWithTableTwoName(
      String getType, String order);

Order Dynamic value come Expamle ASC or DESC

[!CAUTION] ${order} Not Work Err

How add order value add in ### Query ??

[vasanthmn1]

@dkaera @SEGVeenstra

[vasanthmn1]

use db.database.rawQuery

  Future<List<Statement>> getStatementsByInvoiceNoAscending(
      SortParams params) async {
    var db = await this.db();

String type=params.statementType;

    List<Map<String, dynamic>> dbData = await db.database.rawQuery(
        'SELECT TableOne.*, TableTwo.tableName FROM TableOne LEFT JOIN Party ON
        TableOne.clientId = TableTwo.id WHERE TableOne.type = :type
       ORDER BY TableTwo.clientName  ${params.sortingDirection}',
        [type]);
  }