[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-183) Add <where> clause for main class

[<leg...@at...>]

The following comment has been added to this issue:

     Author: Max Rydahl Andersen
    Created: Fri, 11 Jul 2003 5:22 AM
       Body:
Why not just define a View for that ? 
---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-183


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-183
    Summary: Add <where> clause for main class
       Type: New Feature

     Status: Unassigned
   Priority: Minor

    Project: Hibernate2
   Versions:
             2.0.1

   Assignee: 
   Reporter: Tom Sedge

    Created: Fri, 11 Jul 2003 2:57 AM
    Updated: Fri, 11 Jul 2003 2:57 AM
Environment: N/A

Description:
Please add a simple way to add a where clause on all SELECTs for a class - like the <where> tag in collections.

The situation is that I am mapping a legacy table where I don't want or need to deal with all rows. Therefore on a SELECT * or any other query I only want to select certain rows. Which rows depends on the value of two columns (e.g. where t.c1 > 20 and t.c2 < 300) so a discriminator is no help for this. 

However, I *do* have more than one type of object in the table, which is why I wish to ignore some rows. 

I daresay I could do this with a custom persister, but it looks like this should be built-in functionality to me. 



---------------------------------------------------------------------
JIRA INFORMATION:
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

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira