SAP / olingo-jpa-processor-v4

The JPA Processor fills the gap between Olingo V4 and the database, by providing a mapping between JPA metadata and OData metadata, generating queries and supporting the entity manipulations.
Apache License 2.0
129 stars 80 forks source link

$expand with $count fails when having a join table #376

Closed wog48 closed 1 month ago

wog48 commented 2 months ago

When trying to get the number of expand entities e.g., .../entitySet?$expand=navigation($count=true), the service response with a http 500. The error message states:

ON condition right attribute is null / not found.

dbhandari555 commented 2 months ago

Can you please provide an example for the above mentioned scenario using the entities defined in sap-jpa project? I can't reproduce the issue. For example, I tried Organizations?$expand=Roles($count=true) and it succeeds without error.

wog48 commented 1 month ago

@dbhandari555 The example you use has no join table. Try JoinSource?$expand=OneToMany($count=true).

dbhandari555 commented 1 month ago

ok I got you. I can see the reproduce with JoinSources?$expand=OneToMany($count=true)

wog48 commented 1 month ago

The issue shall be fixed with 2.2.0