v1.0.320
Full Changelog: v1.0.301...v1.0.320
- Added sum of items, see below.
- Projection with filter fixed.
- Sql transformer rewritten to improve speed.
- Added transaction save points.
- likeAny query improved for Postgres.
- Added text length function like
Sql.text.length(.) - Added
updateSelect - Improved SaveChanges with directly generated queries instead of query expressions
Sql.coll.sum( (x) => x.products
.map((p) => ({
total: 1,
paid: p.orders
.filter((o) => o.status === "paid")
.some((o) => true) ? 1 : 0
}) )
This way you can get count of all orders and paid ones in a single call.