[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: Tom Sedge
    Created: Sat, 12 Jul 2003 9:05 AM
       Body:
Fantastic.  Thanks Gavin.  :)
---------------------------------------------------------------------
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: Closed
   Priority: Minor
 Resolution: FIXED

    Project: Hibernate2
   Versions:
             2.0.1

   Assignee: 
   Reporter: Tom Sedge

    Created: Fri, 11 Jul 2003 2:57 AM
    Updated: Sat, 12 Jul 2003 4:02 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