[ https://issues.apache.org/jira/browse/DELTASPIKE-1160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15318056#comment-15318056 ]
ASF GitHub Bot commented on DELTASPIKE-1160: -------------------------------------------- Github user Danny02 closed the pull request at: https://github.com/apache/deltaspike/pull/52 > Not possible to select non Entity or other Entity object via Native query > ------------------------------------------------------------------------- > > Key: DELTASPIKE-1160 > URL: https://issues.apache.org/jira/browse/DELTASPIKE-1160 > Project: DeltaSpike > Issue Type: New Feature > Components: Data-Module > Affects Versions: 0.6, 0.7, 1.0.0, 1.0.1, 1.0.2, 1.0.3, 1.1.0, 1.2.0, > 1.2.1, 1.3.0, 1.4.0, 1.4.1, 1.4.2, 1.5.0, 1.5.1, 1.5.2, 1.5.3, 1.5.4, 1.6.0, > 1.6.1 > Reporter: Daniel Heinrich > Assignee: Daniel Heinrich > Priority: Minor > Fix For: 1.7.0 > > Original Estimate: 1h > Remaining Estimate: 1h > > [DELTASPIKE-1089|https://issues.apache.org/jira/browse/DELTASPIKE-1089] > enabled to return none mapped types from a native query from a Repository. > This was done with an extra flag on the Query annotation. > The default for native Queries in Repositories is to return the entity type > fo the repository. > It should be possible to return other entity types from queries of the same > repository. > e.g. > {code:java} > interface FooRepository extends EntityRepository<Foo, Long> > { > @Query(isNative = true,value = "SELECT Bar.* FROM Foo JOIN Bar ON > Foo.bar_fk = Bar.pk WHERE Foo.pk = ?1") > Bar getBarFromFooByPk(long fooPk); > @Query(isNative = true,value = "SELECT Bar.* FROM Foo JOIN Bar ON > Foo.bar_fk = Bar.pk WHERE Foo.age = ?1") > List<Bar> getBarFromFooWithAge(int age); > } > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)