Mailing-List: contact java-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: java-user@lucene.apache.org
Received-SPF: pass (athena.apache.org: domain of mohitanchlia@gmail.com
 designates 209.85.213.176 as permitted sender)
MIME-Version: 1.0
Date: Mon, 21 May 2012 11:36:38 -0700
Message-ID: 
 <CAOT3TWqXnfFkJEr_UJ6R8ETOJqBw-1yRBkATbWfa3s5cU0r-+A@mail.gmail.com>
Subject: Searching accross 2 fields
From: Mohit Anchlia <mohitanchlia@gmail.com>
To: java-user@lucene.apache.org
Content-Type: multipart/alternative; boundary=20cf307f34c8b151a204c0902ea8

--20cf307f34c8b151a204c0902ea8
Content-Type: text/plain; charset=ISO-8859-1

I am new to search and just went through some concepts of "Lucene in
Action". I have few questions:

Problem I am having is this. Say I have these json docs for eg. Now I want
to query forms.id = 40 and fields.id = L31A and fields.value = 3000. I
expect it to return doc 1. But with the regular search I'll also get doc 2.
What's the best way of designing search for such queries?

Json doc 1
{
   "fileName":"filename",
   "createdDate":"05/20/12 16:21:56",
   "setModel":[
      {
         "id":"1",
         "compliance":false,
         "forms":[
            {
               "id":"40",
               "copy":null,
               "tpsId":null,
               "forms":[
                  {
                     "id":"F40_SW_2",
                     "copy":null,
                     "tpsId":"1[]/F40[]",
                     "forms":[
                     ],
                     "tables":[
                     ],
                     "fields":[
                        {
                           "id":"L31A",
                           "security":null,
                           "value":"3000."
                        },
                        {
                           "id":"MRSSN1",
                           "security":null,
                           "value":"656465464"
                        }
                     ]
                  }
                ]
             }
}


Json doc 2
{
   "fileName":"filename",
   "createdDate":"05/20/12 16:21:56",
   "setModel":[
      {
         "id":"1",
         "compliance":false,
         "forms":[
            {
               "id":"50",
               "copy":null,
               "tpsId":null,
               "forms":[
                  {
                     "id":"F50_SW_2",
                     "copy":null,
                     "tpsId":"1[]/F50[]",
                     "forms":[
                     ],
                     "tables":[
                     ],
                     "fields":[
                        {
                           "id":"L31A",
                           "security":null,
                           "value":"3000."
                        },
                        {
                           "id":"MRSSN1",
                           "security":null,
                           "value":"656465464"
                        }
                     ]
                  }
                ]
             }

--20cf307f34c8b151a204c0902ea8--