QueryDSL和Hibernate Search isNull和isNotNull查询

Question

public class Contact{

    @OneToMany(mappedBy = "contact")
    @OrderBy("startDate DESC")
    @IndexedEmbedded
    private List<AddressTemporal> addressHistory;
}

AddressTemporal类

public class AddressTemporal{


    @NotNull
    @ManyToOne
    @ContainedIn
    private Contact contact;

    @Field(index = Index.YES, analyze = Analyze.YES, store = Store.NO, indexNullAs = Constants.LUCENE_NULL)
    @DateBridge(resolution = Resolution.DAY)
    private Date endDate;

}

我已经将lucene配置为使用字符串常量（“null”）索引空字段，这样我就可以使用该值查询空字段。

我的问题是，我需要执行一个查询，该查询将在AddresshiStory集合中搜索，但只筛选那些whereenddate字段为空的查询。现在

 FullTextEntityManager fullTextEntityManager = Search.getFullTextEntityManager(entityManager);
 fullTextEntityManager.createIndexer().startAndWait();
 QContact c = new QContact("contact");

 SearchQuery<Contact> query = new SearchQuery<> fullTextEntityManager.unwrap(FullTextSession.class), c)
 query.where(c.addressHistory.any().endDate.isNotNull());

query.where(c.addressHistory.any().endDate.eq(Constants.LUCENE_NULL));

谢谢

乌利塞斯

Answer 1

试试这个

queryBuilder queryBuilder=fulltextsession.getSearchFactory().buildQueryBuilder().forEntity（project.class).get（）；

querybuilder.keyword().onfield(fieldName).ignoreFieldBridge().matching（“null”）.createquery()