search

stablekernel / aqueduct

Dart HTTP server framework for building REST APIs. Includes PostgreSQL ORM and OAuth2 provider.
https://aqueduct.io
BSD 2-Clause "Simplified" License
2.42k stars 280 forks source link

Join Cards with user and filter cards by date. #939

Closed bahramee closed 3 years ago

bahramee commented 3 years ago

i have a issue with joining card and filter them by used at date. for example i want all cards which used this month. in my card table, i have usedAt field.

this is my card query...

final cardQuery = Query<User>(context)
      ..where((u) => u.company).identifiedBy(companyId)
      ..join(set: (u) => u.card)
          .where((x) => x.product)
          .identifiedBy(productId);
bahramee commented 3 years ago

i filter that, out of my query...