Nest QueryContainer usage

Question

I am able to populate QueryContainer with DateRangeQuery array as shown below

        QueryContainer marriageDateQuerys = null;

        if (!string.IsNullOrEmpty((item.marriage_date)))
            {
                DateRangeQuery query = new DateRangeQuery();
                query.Field = "marriages.marriage_date";
                query.Name = item.marriage_date;
                query.GreaterThanOrEqualTo = item.marriage_date;
                query.LessThanOrEqualTo = item.marriage_date;

                marriageDateQuerys &= query;
            }

But when I use QueryContainer to use MatchQuery/TermQuery to populate data it is not happening.

           QueryContainer marriageSpouseFirstNameQuerys = null;  


            if (!string.IsNullOrEmpty((item.spouse_first_name)))
            {
                MatchQuery query = new MatchQuery();
                query.Field = "marriages.spouse_first_name";
                query.Name = item.spouse_first_name;
                marriageSpouseFirstNameQuerys &= query;
            }

Query object is created in last if condition but marriageSpouseFirstNameQuerys is not populated with the same. I even tried marriageSpouseFirstNameQuerys += query; but without any success

score 5 · Accepted Answer · answered Jun 01 '17 at 17:40

Didn't try it but you can try something like this

              Query = new QueryContainer(new BoolQuery
                    {
                        Must = new List<QueryContainer>
                        {
                            new MatchQuery
                            {
                                //props
                            },
                            new TermQuery
                            {
                                Field = field
                                Value = value
                            },
                        }
                    })

I used your code and made some changes to make it working for my requirement — Sushil, Jun 07 '17 at 14:39

score 1 · Answer 2 · answered Jun 07 '17 at 14:42

Below code worked for me after making changes with eyildiz answer

       if (!string.IsNullOrEmpty((item.spouse_last_name)))
                {
                    marriageSpouseLastNameQuery = new QueryContainer(
                        new MatchQuery
                        {
                            Field = "marriages.spouse_last_name",
                            Query = item.spouse_last_name
                        });
                    lstmarriageSpouseLastNameQuerys.Add(marriageSpouseLastNameQuery);
                }

Nest QueryContainer usage

2 Answers2