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

[ http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-471?pag... ] 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. -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira