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
@Entity
@Include(rootLevel = true, name = "transfer", description = "A monetary transfer transaction")
class TransferTransaction(
// ...
)
My join definition in my reservestats hjson table:
joins: [
{
name: reserveTransfer
to: transfer
# Full Join is not supported for: H2
# type: full
definition: '{{$reserveId}} = {{reserveTransfer.$id}}'
}
]
Generates:
SELECT count(_reservestats_reserveTransfer_138211222.id) AS count
FROM currency_reserve AS _reservestats
LEFT OUTER JOIN TransferTransaction AS _reservestats_reserveTransfer_138211222
ON _reservestats.id = _reservestats_reserveTransfer_138211222.reserve
It should generate:
SELECT count(_reservestats_reserveTransfer_138211222.id) AS count
FROM currency_reserve AS _reservestats
LEFT OUTER JOIN transfer_transaction AS _reservestats_reserveTransfer_138211222
ON _reservestats.id = _reservestats_reserveTransfer_138211222.reserve_id
i.e.:
TransferTransaction > transfer_transaction
reserve > reserve_id
The text was updated successfully, but these errors were encountered:
My Spring config fragment:
My JPA entity (kotlin):
My join definition in my
reservestats
hjson table:Generates:
SELECT count(
_reservestats_reserveTransfer_138211222
.id
) AScount
FROM
currency_reserve
AS_reservestats
LEFT OUTER JOIN
TransferTransaction
AS_reservestats_reserveTransfer_138211222
ON
_reservestats
.id
=_reservestats_reserveTransfer_138211222
.reserve
It should generate:
SELECT count(
_reservestats_reserveTransfer_138211222
.id
) AScount
FROM
currency_reserve
AS_reservestats
LEFT OUTER JOIN
transfer_transaction
AS_reservestats_reserveTransfer_138211222
ON
_reservestats
.id
=_reservestats_reserveTransfer_138211222
.reserve_id
i.e.:
The text was updated successfully, but these errors were encountered: