[hibernate-issues] [Hibernate-JIRA] Commented: (HSEARCH-499) Pass a "filter" query to MassIndexing: index changed entity based on timestamp

[Marc Schipperheyn (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-499?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=45214#comment-45214 ] 

Marc Schipperheyn commented on HSEARCH-499:
-------------------------------------------

my use case is this. I have an database of classifieds, market place like, they have start and end dates. The classifieds are stored in one table and the validity data in an inner joined other table. Of course, I can query the index based for valid classifieds based on those start and end dates, However, with the MassIndexer, the index will be much, much larger than needed, since the database will have more and more "invalid" classifieds over time. Implementation wise, a detecached criteria query would seem good, but hql would work for me as well, it tends to be a bit more flexible although I cannot see how we would need this flexibility. Criteria seems to be safer because you might want to be able to protect yourself against like "select cat.kittens from Cat cat inner join cat.kittens". So perhaps a criteria query that does not have the full range of flexibility such as projection since you only want to filter what comes back from a "select all from x" type query. 

> Pass a "filter" query to MassIndexing: index changed entity based on timestamp
> ------------------------------------------------------------------------------
>
>                 Key: HSEARCH-499
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-499
>             Project: Hibernate Search
>          Issue Type: New Feature
>          Components: massindexer
>            Reporter: Emmanuel Bernard
>            Assignee: Sanne Grinovero
>
> I was discussion the MassIndexer API. It would be nice to be able to filter the list of Entity ids to reindex based on a query:
> For example
> select u.id from User u where u.lastUpdate >= :yesterday
> or sue some kind of other flag.
> This would be a nice useful trick.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira