[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-298) allow joins in filters

[Steve Ebersole (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-298?page=comments#action_25765 ] 

Steve Ebersole commented on HHH-298:
------------------------------------

It was never a lack of a "business case".   I see the value of this (hence the reason I suggested it), but I do not have time to do this.

Contributions welcome!

> allow joins in filters
> ----------------------
>
>          Key: HHH-298
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-298
>      Project: Hibernate3
>         Type: Improvement

>   Components: core
>     Reporter: Steve Ebersole
>     Assignee: Steve Ebersole

>
>
> For the sake of performance with complex filters, it'd be nice to allow users to specify joins fragments to be added to the filter tags.  Somthing like:
> <filter name="myFilter">
>     <filter-join table="MyPermissionTable">
>         <condition>
>             {this}.id =
>             {MyPermissionTable}.object_id
>         </condition>
>     </filter-join>
>     <![CDATA[
>         {MyPermissionTable}.user_id =
>         :userId 
>             AND 
>         {MyPermissionTable}.perm_flg <
>         :userPermLevel
>     ]]>
> </filter>

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira