How to set two simultaneos filters

wiji · **Joined:** Wed Oct 07, 2009 7:34 am **Posts:** 12

Im trying to implement two simultaneos filters fields on a search:

Code:

FullTextQuery fullTextQuery = fullTextSession.createFullTextQuery(query, entityClass).setCriteriaQuery(
               criterio);

Filter filtro = new LuceneFilter(panel.getFilterField(), NULL_FIELD_VALUE);
Filter filtro2 = new LuceneFilter("generaCompensacion", "true");
fullTextQuery.setFilter(filtro);
fullTextQuery.setFilter(filtro2);

But it filtering usign the last filter I setted (filtro2)

LuceneFilter.java:

Code:

public class LuceneFilter extends Filter {

   private static final long serialVersionUID = -2386071314600859702L;

   private String campoFiltrado;
   private String filtro;

   public LuceneFilter(String campoFiltrado, String valorFiltro) {
      super();
      this.campoFiltrado = campoFiltrado;
      this.filtro = valorFiltro;
   }

   public BitSet bits(IndexReader reader) throws IOException {

      BitSet bitSet = new BitSet(reader.maxDoc());

      Term term = new Term(campoFiltrado, filtro);
      TermDocs docs = reader.termDocs(term);

      while (docs.next()) {
         bitSet.set(docs.doc());
      }

      return bitSet;
   }
}

How can I filter usign two simultaneos fields???

amin-mc · **Joined:** Wed Oct 03, 2007 2:31 pm **Posts:** 205

Use a chained filter for example

Code:

FullTextQuery fullTextQuery = fullTextSession.createFullTextQuery(query, A.class);
Filter a = new Filter();
Filter b = new Filter();
ChainedFilter chainedFilter = new ChainedFilter(new Filter[]{a, b});
fullTextQuery.setFilter(chainedFilter );

You have the option to apply operators on the chained filter, so if you want to apply both of then and both must match you can do

Code:

ChainedFilter chainedFilter = new ChainedFilter(new Filter[]{a, b},  ChainedFilter.AND);

optional looks like:

Code:

ChainedFilter chainedFilter = new ChainedFilter(new Filter[]{a, b},  ChainedFilter.OR);

HTH

sanne.grinovero · **Posted:** Wed Oct 28, 2009 7:09 pm

Hi, setFilter(Filter filter) is semi-deprecated (I'm quoting the javadoc) because of this and other limitations;

use

Code:

fullTextQuery.enableFullTextFilter(filtro);
fullTextQuery.enableFullTextFilter(filtro2);

this will enable both filters, and make use of caching (if configured to) and some other tricks like lazy-bit-ANDing iterators to improve performance.

amin-mc · **Joined:** Wed Oct 03, 2007 2:31 pm **Posts:** 205

What happens if I don't define a filter using annotation (from javadocs 'Enable a given filter by its name'). In my situation I had to come up with a dynamic filter based on user role.

sanne.grinovero · **Posted:** Thu Oct 29, 2009 9:26 am

Quote:

What happens if I don't define a filter using annotation (from javadocs 'Enable a given filter by its name'). In my situation I had to come up with a dynamic filter based on user role.

right, you can define one dynamic filter using the setFilter, it should combine with the others you can enable from definitions.
good point to not deprecated it.

Actually, you could redefine your "dynamic filter" as a declarative filter using parameters?
You could benefit from some optimizations.