[hibernate-issues] [Hibernate-JIRA] Commented: (HSEARCH-471) Ability to "filter" entities from the search indexes

[Dobes Vandermeer (JIRA)]

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

Dobes Vandermeer commented on HSEARCH-471:
------------------------------------------

Sure, here's a simple one:

We have a table User which contains a list of all the users.

We have a table Activity which records user activities, which references the User table.

An administrator can mark a user as "removed" which removes them from search and makes that user inactivated, unable to log in or perform any action.

However, the Activity logs for that user are still preserved, and the user's row remains in the database as a foreign key for later use to display that user's name/email.

The administrator may want to search the list of "non-removed" users by name, email, or other fields on the user.

The activity logs also record which "object" was operated on.  For example, it may have been an invoice.  When viewing the activity log we can see the user, and the invoice.  So both of these stay in the database forever, even after they are "removed".

We have database indexes that make it quick to ignore the "removed" entities in queries.

However, in lucene we will never search for these objects so it would be nice to remove them from the index.



> Ability to "filter" entities from the search indexes
> ----------------------------------------------------
>
>                 Key: HSEARCH-471
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-471
>             Project: Hibernate Search
>          Issue Type: New Feature
>          Components: mapping
>    Affects Versions: 3.1.1.GA
>            Reporter: Dobes Vandermeer
>            Priority: Minor
>
> In our system we have entities that are searched but not all of them are available for search - some of them are flagged as "removed".  It would improve the efficiency of our search subsystem if we could implement a kind of "filter" that blocked these entities from being added to the search index, since we wouldn't have to make that a search term and our indexes would be somewhat smaller.

-- 
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