[2023-09-23 22:46:58 #278 query.manager]
<queryRequest query="select new lk.gov.health.phsp.pojcs.ClientBasicData(c.id, c.phn, c.person.name, c.person.nic, c.person.phone1, c.person.address )  from Client c  where c.retired=false  and  ( lower(c.phn)=:q  or  lower(c.person.localReferanceNo)=:q  or  lower(c.person.ssNumber)=:q  or  c.person.phone1=:q  or  c.person.phone2=:q  or  lower(c.person.nic)=:q  ) " args="{q->0715812399}" transactionId="-1" />


[2023-09-23 22:46:58 #279 query.tokenizer]
<tokenList>
  <token name="select" code="132" postion="0:6" />
  <token name="new" code="122" postion="7:10" />
  <token name="lk" code="1" postion="11:13" />
  <token name="." code="6" postion="13:14" />
  <token name="gov" code="1" postion="14:17" />
  <token name="." code="6" postion="17:18" />
  <token name="health" code="1" postion="18:24" />
  <token name="." code="6" postion="24:25" />
  <token name="phsp" code="1" postion="25:29" />
  <token name="." code="6" postion="29:30" />
  <token name="pojcs" code="1" postion="30:35" />
  <token name="." code="6" postion="35:36" />
  <token name="ClientBasicData" code="1" postion="36:51" />
  <token name="(" code="14" postion="51:52" />
  <token name="c" code="1" postion="52:53" />
  <token name="." code="6" postion="53:54" />
  <token name="id" code="1" postion="54:56" />
  <token name="," code="9" postion="56:57" />
  <token name="c" code="1" postion="58:59" />
  <token name="." code="6" postion="59:60" />
  <token name="phn" code="1" postion="60:63" />
  <token name="," code="9" postion="63:64" />
  <token name="c" code="1" postion="65:66" />
  <token name="." code="6" postion="66:67" />
  <token name="person" code="1" postion="67:73" />
  <token name="." code="6" postion="73:74" />
  <token name="name" code="1" postion="74:78" />
  <token name="," code="9" postion="78:79" />
  <token name="c" code="1" postion="80:81" />
  <token name="." code="6" postion="81:82" />
  <token name="person" code="1" postion="82:88" />
  <token name="." code="6" postion="88:89" />
  <token name="nic" code="1" postion="89:92" />
  <token name="," code="9" postion="92:93" />
  <token name="c" code="1" postion="94:95" />
  <token name="." code="6" postion="95:96" />
  <token name="person" code="1" postion="96:102" />
  <token name="." code="6" postion="102:103" />
  <token name="phone1" code="1" postion="103:109" />
  <token name="," code="9" postion="109:110" />
  <token name="c" code="1" postion="111:112" />
  <token name="." code="6" postion="112:113" />
  <token name="person" code="1" postion="113:119" />
  <token name="." code="6" postion="119:120" />
  <token name="address" code="1" postion="120:127" />
  <token name=")" code="15" postion="128:129" />
  <token name="from" code="103" postion="131:135" />
  <token name="Client" code="1" postion="136:142" />
  <token name="c" code="1" postion="143:144" />
  <token name="where" code="150" postion="146:151" />
  <token name="c" code="1" postion="152:153" />
  <token name="." code="6" postion="153:154" />
  <token name="retired" code="1" postion="154:161" />
  <token name="=" code="21" postion="161:162" />
  <token name="false" code="2" postion="162:167" value="false" type="boolean" />
  <token name="and" code="73" postion="169:172" />
  <token name="(" code="14" postion="174:175" />
  <token name="lower" code="117" postion="176:181" />
  <token name="(" code="14" postion="181:182" />
  <token name="c" code="1" postion="182:183" />
  <token name="." code="6" postion="183:184" />
  <token name="phn" code="1" postion="184:187" />
  <token name=")" code="15" postion="187:188" />
  <token name="=" code="21" postion="188:189" />
  <token name=":" code="7" postion="189:190" />
  <token name="q" code="1" postion="190:191" />
  <token name="or" code="128" postion="193:195" />
  <token name="lower" code="117" postion="197:202" />
  <token name="(" code="14" postion="202:203" />
  <token name="c" code="1" postion="203:204" />
  <token name="." code="6" postion="204:205" />
  <token name="person" code="1" postion="205:211" />
  <token name="." code="6" postion="211:212" />
  <token name="localReferanceNo" code="1" postion="212:228" />
  <token name=")" code="15" postion="228:229" />
  <token name="=" code="21" postion="229:230" />
  <token name=":" code="7" postion="230:231" />
  <token name="q" code="1" postion="231:232" />
  <token name="or" code="128" postion="234:236" />
  <token name="lower" code="117" postion="238:243" />
  <token name="(" code="14" postion="243:244" />
  <token name="c" code="1" postion="244:245" />
  <token name="." code="6" postion="245:246" />
  <token name="person" code="1" postion="246:252" />
  <token name="." code="6" postion="252:253" />
  <token name="ssNumber" code="1" postion="253:261" />
  <token name=")" code="15" postion="261:262" />
  <token name="=" code="21" postion="262:263" />
  <token name=":" code="7" postion="263:264" />
  <token name="q" code="1" postion="264:265" />
  <token name="or" code="128" postion="267:269" />
  <token name="c" code="1" postion="271:272" />
  <token name="." code="6" postion="272:273" />
  <token name="person" code="1" postion="273:279" />
  <token name="." code="6" postion="279:280" />
  <token name="phone1" code="1" postion="280:286" />
  <token name="=" code="21" postion="286:287" />
  <token name=":" code="7" postion="287:288" />
  <token name="q" code="1" postion="288:289" />
  <token name="or" code="128" postion="291:293" />
  <token name="c" code="1" postion="295:296" />
  <token name="." code="6" postion="296:297" />
  <token name="person" code="1" postion="297:303" />
  <token name="." code="6" postion="303:304" />
  <token name="phone2" code="1" postion="304:310" />
  <token name="=" code="21" postion="310:311" />
  <token name=":" code="7" postion="311:312" />
  <token name="q" code="1" postion="312:313" />
  <token name="or" code="128" postion="315:317" />
  <token name="lower" code="117" postion="319:324" />
  <token name="(" code="14" postion="324:325" />
  <token name="c" code="1" postion="325:326" />
  <token name="." code="6" postion="326:327" />
  <token name="person" code="1" postion="327:333" />
  <token name="." code="6" postion="333:334" />
  <token name="nic" code="1" postion="334:337" />
  <token name=")" code="15" postion="337:338" />
  <token name="=" code="21" postion="338:339" />
  <token name=":" code="7" postion="339:340" />
  <token name="q" code="1" postion="340:341" />
  <token name=")" code="15" postion="343:344" />
</tokenList>


[2023-09-23 22:46:58 #280 query.tokenizer]
<token name="QUERY" code="67" postion="0:0">
  <token name="select" code="132" postion="0:6">
        <token name="new" code="122" postion="7:10">
          <token name="." code="6" postion="35:36">
            <token name="." code="6" postion="29:30">
              <token name="." code="6" postion="24:25">
                <token name="." code="6" postion="17:18">
                  <token name="." code="6" postion="13:14">
                    <token name="lk" code="1" postion="11:13" />
                    <token name="gov" code="1" postion="14:17" />
                  </token>
                  <token name="health" code="1" postion="18:24" />
                </token>
                <token name="phsp" code="1" postion="25:29" />
              </token>
              <token name="pojcs" code="1" postion="30:35" />
            </token>
            <token name="ClientBasicData" code="1" postion="36:51" />
            <token name="(" code="14" postion="51:52">
              <token name="." code="6" postion="53:54">
                <token name="c" code="1" postion="52:53" />
                <token name="id" code="1" postion="54:56" />
              </token>
              <token name="." code="6" postion="59:60">
                <token name="c" code="1" postion="58:59" />
                <token name="phn" code="1" postion="60:63" />
              </token>
              <token name="." code="6" postion="73:74">
                <token name="." code="6" postion="66:67">
                  <token name="c" code="1" postion="65:66" />
                  <token name="person" code="1" postion="67:73" />
                </token>
                <token name="name" code="1" postion="74:78" />
              </token>
              <token name="." code="6" postion="88:89">
                <token name="." code="6" postion="81:82">
                  <token name="c" code="1" postion="80:81" />
                  <token name="person" code="1" postion="82:88" />
                </token>
                <token name="nic" code="1" postion="89:92" />
              </token>
              <token name="." code="6" postion="102:103">
                <token name="." code="6" postion="95:96">
                  <token name="c" code="1" postion="94:95" />
                  <token name="person" code="1" postion="96:102" />
                </token>
                <token name="phone1" code="1" postion="103:109" />
              </token>
              <token name="." code="6" postion="119:120">
                <token name="." code="6" postion="112:113">
                  <token name="c" code="1" postion="111:112" />
                  <token name="person" code="1" postion="113:119" />
                </token>
                <token name="address" code="1" postion="120:127" />
              </token>
              <token name=")" code="15" postion="128:129" />
            </token>
          </token>
        </token>
  </token>
  <token name="from" code="103" postion="131:135">
        <token name="c" code="1" postion="143:144">
          <token name="Client" code="1" postion="136:142" />
        </token>
  </token>
  <token name="where" code="150" postion="146:151">
        <token name="and" code="73" postion="169:172">
          <token name="=" code="21" postion="161:162">
            <token name="." code="6" postion="153:154">
              <token name="c" code="1" postion="152:153" />
              <token name="retired" code="1" postion="154:161" />
            </token>
            <token name="false" code="2" postion="162:167" value="false" type="boolean" />
          </token>
          <token name="or" code="128" postion="315:317">
            <token name="or" code="128" postion="291:293">
              <token name="or" code="128" postion="267:269">
                <token name="or" code="128" postion="234:236">
                  <token name="or" code="128" postion="193:195">
                    <token name="=" code="21" postion="188:189">
                      <token name="lower" code="117" postion="176:181">
                        <token name="(" code="14" postion="181:182">
                          <token name="." code="6" postion="183:184">
                            <token name="c" code="1" postion="182:183" />
                            <token name="phn" code="1" postion="184:187" />
                          </token>
                          <token name=")" code="15" postion="187:188" />
                        </token>
                      </token>
                      <token name=":" code="7" postion="189:190">
                        <token name="q" code="1" postion="190:191" />
                      </token>
                    </token>
                    <token name="=" code="21" postion="229:230">
                      <token name="lower" code="117" postion="197:202">
                        <token name="(" code="14" postion="202:203">
                          <token name="." code="6" postion="211:212">
                            <token name="." code="6" postion="204:205">
                              <token name="c" code="1" postion="203:204" />
                              <token name="person" code="1" postion="205:211" />
                            </token>
                            <token name="localReferanceNo" code="1" postion="212:228" />
                          </token>
                          <token name=")" code="15" postion="228:229" />
                        </token>
                      </token>
                      <token name=":" code="7" postion="230:231">
                        <token name="q" code="1" postion="231:232" />
                      </token>
                    </token>
                  </token>
                  <token name="=" code="21" postion="262:263">
                    <token name="lower" code="117" postion="238:243">
                      <token name="(" code="14" postion="243:244">
                        <token name="." code="6" postion="252:253">
                          <token name="." code="6" postion="245:246">
                            <token name="c" code="1" postion="244:245" />
                            <token name="person" code="1" postion="246:252" />
                          </token>
                          <token name="ssNumber" code="1" postion="253:261" />
                        </token>
                        <token name=")" code="15" postion="261:262" />
                      </token>
                    </token>
                    <token name=":" code="7" postion="263:264">
                      <token name="q" code="1" postion="264:265" />
                    </token>
                  </token>
                </token>
                <token name="=" code="21" postion="286:287">
                  <token name="." code="6" postion="279:280">
                    <token name="." code="6" postion="272:273">
                      <token name="c" code="1" postion="271:272" />
                      <token name="person" code="1" postion="273:279" />
                    </token>
                    <token name="phone1" code="1" postion="280:286" />
                  </token>
                  <token name=":" code="7" postion="287:288">
                    <token name="q" code="1" postion="288:289" />
                  </token>
                </token>
              </token>
              <token name="=" code="21" postion="310:311">
                <token name="." code="6" postion="303:304">
                  <token name="." code="6" postion="296:297">
                    <token name="c" code="1" postion="295:296" />
                    <token name="person" code="1" postion="297:303" />
                  </token>
                  <token name="phone2" code="1" postion="304:310" />
                </token>
                <token name=":" code="7" postion="311:312">
                  <token name="q" code="1" postion="312:313" />
                </token>
              </token>
            </token>
            <token name="=" code="21" postion="338:339">
              <token name="lower" code="117" postion="319:324">
                <token name="(" code="14" postion="324:325">
                  <token name="." code="6" postion="333:334">
                    <token name="." code="6" postion="326:327">
                      <token name="c" code="1" postion="325:326" />
                      <token name="person" code="1" postion="327:333" />
                    </token>
                    <token name="nic" code="1" postion="334:337" />
                  </token>
                  <token name=")" code="15" postion="337:338" />
                </token>
              </token>
              <token name=":" code="7" postion="339:340">
                <token name="q" code="1" postion="340:341" />
              </token>
            </token>
            <token name=")" code="15" postion="343:344" />
          </token>
        </token>
  </token>
</token>


[2023-09-23 22:46:58 #281 query.compiler]
<queryCompilation query="select new lk.gov.health.phsp.pojcs.ClientBasicData(c.id, c.phn, c.person.name, c.person.nic, c.person.phone1, c.person.address )  from Client c  where c.retired=false  and  ( lower(c.phn)=:q  or  lower(c.person.localReferanceNo)=:q  or  lower(c.person.ssNumber)=:q  or  c.person.phone1=:q  or  c.person.phone2=:q  or  lower(c.person.nic)=:q  ) ">
  <symbolManager>
        <parameters>
          <q type="java.lang.String" />
        </parameters>
        <variables>
          <c varId="0" type="lk.gov.health.phsp.entity.Client" subtypes="include" typeId="12" binding="null" nav="111">
            <keys>
              <secondary ix="0" name="-120" nav="100" />
              <secondary ix="1" name="-121" nav="10" />
            </keys>
            <navigations>
              <id member="id" memberType="java.lang.Long" id="8" keyPos="0" />
              <person member="person" memberType="lk.gov.health.phsp.entity.Person" id="2" />
              <phn member="phn" memberType="java.lang.String" id="1" />
              <retired member="retired" memberType="boolean" id="0" />
            </navigations>
          </c>
          <v$1 varId="1" type="lk.gov.health.phsp.entity.Person" subtypes="include" typeId="7" binding="c.person" nav="11011111000">
            <keys>
              <secondary ix="0" name="-112" nav="0" />
              <secondary ix="1" name="-114" nav="1000" />
              <secondary ix="2" name="-126" nav="1000000000" />
              <secondary ix="3" name="-115" nav="10000000" />
              <secondary ix="4" name="-116" nav="0" />
              <secondary ix="5" name="-117" nav="100000" />
              <secondary ix="6" name="-118" nav="1000000" />
              <secondary ix="7" name="-119" nav="10000" />
            </keys>
            <navigations>
              <ssNumber member="ssNumber" memberType="java.lang.String" id="4" />
              <localReferanceNo member="localReferanceNo" memberType="java.lang.String" id="3" />
              <nic member="nic" memberType="java.lang.String" id="7" />
              <name member="name" memberType="java.lang.String" id="9" />
              <phone2 member="phone2" memberType="java.lang.String" id="6" />
              <address member="address" memberType="java.lang.String" id="10" />
              <phone1 member="phone1" memberType="java.lang.String" id="5" />
            </navigations>
          </v$1>
        </variables>
  </symbolManager>
  <queryCompData>
        <query exp="query(where(and(or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q)),(c.retired=false),(c.person join v$1))),select(c.id,c.phn,v$1.name,v$1.nic,v$1.phone1,v$1.address))" var="c,v$1" directVar="c,v$1" ext="11111111111">
          <where exp="where(and(or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q)),(c.retired=false),(c.person join v$1)))" var="c,v$1" directVar="c,v$1" ext="11111111">
            <and exp="and(or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q)),(c.retired=false),(c.person join v$1))" type="boolean" var="c,v$1" directVar="c,v$1" ext="11111111">
              <or exp="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))" type="boolean" var="c,v$1" directVar="c,v$1" ext="11111010">
                <equals exp="(toLower(v$1.nic)=:q)" type="boolean" var="v$1" directVar="v$1" ext="10000000">
                  <toLower exp="toLower(v$1.nic)" type="java.lang.String" var="v$1" directVar="v$1" ext="10000000">
                    <member exp="v$1.nic" type="java.lang.String" var="v$1" directVar="v$1" ext="10000000" memberName="nic" />
                  </toLower>
                  <parameter exp=":q" type="java.lang.String" var="" directVar="" ext="0" />
                </equals>
                <equals exp="(v$1.phone2=:q)" type="boolean" var="v$1" directVar="v$1" ext="1000000">
                  <member exp="v$1.phone2" type="java.lang.String" var="v$1" directVar="v$1" ext="1000000" memberName="phone2" />
                  <parameter exp=":q" type="java.lang.String" var="" directVar="" ext="0" />
                </equals>
                <equals exp="(v$1.phone1=:q)" type="boolean" var="v$1" directVar="v$1" ext="100000">
                  <member exp="v$1.phone1" type="java.lang.String" var="v$1" directVar="v$1" ext="100000" memberName="phone1" />
                  <parameter exp=":q" type="java.lang.String" var="" directVar="" ext="0" />
                </equals>
                <equals exp="(toLower(v$1.ssNumber)=:q)" type="boolean" var="v$1" directVar="v$1" ext="10000">
                  <toLower exp="toLower(v$1.ssNumber)" type="java.lang.String" var="v$1" directVar="v$1" ext="10000">
                    <member exp="v$1.ssNumber" type="java.lang.String" var="v$1" directVar="v$1" ext="10000" memberName="ssNumber" />
                  </toLower>
                  <parameter exp=":q" type="java.lang.String" var="" directVar="" ext="0" />
                </equals>
                <equals exp="(toLower(v$1.localReferanceNo)=:q)" type="boolean" var="v$1" directVar="v$1" ext="1000">
                  <toLower exp="toLower(v$1.localReferanceNo)" type="java.lang.String" var="v$1" directVar="v$1" ext="1000">
                    <member exp="v$1.localReferanceNo" type="java.lang.String" var="v$1" directVar="v$1" ext="1000" memberName="localReferanceNo" />
                  </toLower>
                  <parameter exp=":q" type="java.lang.String" var="" directVar="" ext="0" />
                </equals>
                <equals exp="(toLower(c.phn)=:q)" type="boolean" var="c" directVar="c" ext="10">
                  <toLower exp="toLower(c.phn)" type="java.lang.String" var="c" directVar="c" ext="10">
                    <member exp="c.phn" type="java.lang.String" var="c" directVar="c" ext="10" memberName="phn" />
                  </toLower>
                  <parameter exp=":q" type="java.lang.String" var="" directVar="" ext="0" />
                </equals>
              </or>
              <equals exp="(c.retired=false)" type="boolean" var="c" directVar="c" ext="1">
                <member exp="c.retired" type="boolean" var="c" directVar="c" ext="1" memberName="retired" />
                <literal exp="false" type="boolean" var="" directVar="" ext="0" />
              </equals>
              <join exp="(c.person join v$1)" type="boolean" var="c,v$1" directVar="c,v$1" ext="100">
                <member exp="c.person" type="lk.gov.health.phsp.entity.Person" var="c" directVar="c" ext="100" memberName="person" />
                <variable exp="v$1" type="lk.gov.health.phsp.entity.Person" var="v$1" directVar="v$1" ext="0" varId="1" />
              </join>
            </and>
          </where>
          <select exp="select(c.id,c.phn,v$1.name,v$1.nic,v$1.phone1,v$1.address)" var="c,v$1" directVar="c,v$1" ext="11110100010">
            <member exp="c.id" type="java.lang.Long" var="c" directVar="c" ext="100000000" memberName="id" />
            <member exp="c.phn" type="java.lang.String" var="c" directVar="c" ext="10" memberName="phn" />
            <member exp="v$1.name" type="java.lang.String" var="v$1" directVar="v$1" ext="1000000000" memberName="name" />
            <member exp="v$1.nic" type="java.lang.String" var="v$1" directVar="v$1" ext="10000000" memberName="nic" />
            <member exp="v$1.phone1" type="java.lang.String" var="v$1" directVar="v$1" ext="100000" memberName="phone1" />
            <member exp="v$1.address" type="java.lang.String" var="v$1" directVar="v$1" ext="10000000000" memberName="address" />
          </select>
        </query>
        <globals globalVariables="c,v$1" globalNavigations="11110100010" />
  </queryCompData>
</queryCompilation>


[2023-09-23 22:46:58 #282 query.compiler]
<query-planning>
  <sub-planning vars="c" filter="(c.retired=false)">
        <step vars="()+c" future="true">
          <filterPlan complexity="15.6015" eval="4.70/6.30" filter="(c.retired=false)">
            <extractPlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)">
              <btreePlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)" scope="type(Client[all])" />
            </extractPlan>
          </filterPlan>
          <filterPlan complexity="15.7525" eval="6.63/6.30" filter="(c.retired=false)">
            <extractPlan complexity="15.7313" eval="6.60/6.30" variable="c(Client)">
              <btreePlan complexity="13.7313" eval="4.11/6.30" variable="c(Client)" scope="index(-120[all])" />
            </extractPlan>
          </filterPlan>
          <filterPlan complexity="16.8123" eval="6.63/6.30" filter="(c.retired=false)">
            <extractPlan complexity="16.7911" eval="6.61/6.30" variable="c(Client)">
              <btreePlan complexity="14.7911" eval="4.44/6.30" variable="c(Client)" scope="index(-121[all])" />
            </extractPlan>
          </filterPlan>
        </step>
        <selected-plans>
          <filterPlan complexity="15.6015" eval="4.70/6.30" filter="(c.retired=false)" />
        </selected-plans>
  </sub-planning>
  <sub-planning vars="v$1" filter="">
        <step vars="()+v$1" future="true">
          <btreePlan complexity="12.4831" eval="3.70/6.30" variable="v$1(Person)" scope="index(-116[all])" />
          <btreePlan complexity="12.5457" eval="3.72/6.30" variable="v$1(Person)" scope="index(-119[all])" />
          <btreePlan complexity="12.6125" eval="3.75/6.30" variable="v$1(Person)" scope="index(-118[all])" />
          <btreePlan complexity="12.7688" eval="3.80/6.30" variable="v$1(Person)" scope="index(-114[all])" />
          <btreePlan complexity="13.9482" eval="4.17/6.30" variable="v$1(Person)" scope="index(-117[all])" />
          <btreePlan complexity="14.3198" eval="4.29/6.30" variable="v$1(Person)" scope="index(-115[all])" />
          <btreePlan complexity="14.745" eval="4.42/6.30" variable="v$1(Person)" scope="index(-126[all])" />
          <btreePlan complexity="17.5762" eval="5.26/6.30" variable="v$1(Person)" scope="type(Person[all])" />
        </step>
        <selected-plans>
          <btreePlan complexity="12.4831" eval="3.70/6.30" variable="v$1(Person)" scope="index(-116[all])" />
          <btreePlan complexity="12.5457" eval="3.72/6.30" variable="v$1(Person)" scope="index(-119[all])" />
          <btreePlan complexity="12.6125" eval="3.75/6.30" variable="v$1(Person)" scope="index(-118[all])" />
          <btreePlan complexity="12.7688" eval="3.80/6.30" variable="v$1(Person)" scope="index(-114[all])" />
          <btreePlan complexity="13.9482" eval="4.17/6.30" variable="v$1(Person)" scope="index(-117[all])" />
          <btreePlan complexity="14.3198" eval="4.29/6.30" variable="v$1(Person)" scope="index(-115[all])" />
          <btreePlan complexity="14.745" eval="4.42/6.30" variable="v$1(Person)" scope="index(-126[all])" />
          <btreePlan complexity="17.5762" eval="5.26/6.30" variable="v$1(Person)" scope="type(Person[all])" />
        </selected-plans>
  </sub-planning>
  <sub-planning vars="c,v$1" filter="and(or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q)),(c.retired=false),(c.person join v$1))">
        <step vars="(v$1)+c" future="true">
          <multiVarPlan complexity="24.0847" eval="10.01/9.45" var="c,v$1">
            <extractPlan complexity="17.5762" eval="5.26/6.30" variable="v$1(Person)">
              <btreePlan complexity="17.5762" eval="5.26/6.30" variable="v$1(Person)" scope="type(Person[all])" />
            </extractPlan>
            <filterPlan complexity="3.2543" eval="3.71/3.15" filter="(c.retired=false)">
              <filterPlan complexity="3.2331" eval="3.69/3.15" filter="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))">
                <extractPlan complexity="3.0" eval="3.45/3.15" variable="c(Client)">
                  <btreePlan complexity="1.0" eval="0.90/3.15" variable="c(Client)" scope="index(-120[v$1->v$1])" />
                </extractPlan>
              </filterPlan>
            </filterPlan>
          </multiVarPlan>
          <multiVarPlan complexity="20.9916" eval="10.01/9.45" var="c,v$1">
            <extractPlan complexity="14.4831" eval="6.60/6.30" variable="v$1(Person)">
              <btreePlan complexity="12.4831" eval="3.70/6.30" variable="v$1(Person)" scope="index(-116[all])" />
            </extractPlan>
            <filterPlan complexity="3.2543" eval="3.71/3.15" filter="(c.retired=false)">
              <filterPlan complexity="3.2331" eval="3.69/3.15" filter="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))">
                <extractPlan complexity="3.0" eval="3.45/3.15" variable="c(Client)">
                  <btreePlan complexity="1.0" eval="0.90/3.15" variable="c(Client)" scope="index(-120[v$1->v$1])" />
                </extractPlan>
              </filterPlan>
            </filterPlan>
          </multiVarPlan>
          <multiVarPlan complexity="21.0542" eval="10.01/9.45" var="c,v$1">
            <extractPlan complexity="14.5457" eval="6.60/6.30" variable="v$1(Person)">
              <btreePlan complexity="12.5457" eval="3.72/6.30" variable="v$1(Person)" scope="index(-119[all])" />
            </extractPlan>
            <filterPlan complexity="3.2543" eval="3.71/3.15" filter="(c.retired=false)">
              <filterPlan complexity="3.2331" eval="3.69/3.15" filter="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))">
                <extractPlan complexity="3.0" eval="3.45/3.15" variable="c(Client)">
                  <btreePlan complexity="1.0" eval="0.90/3.15" variable="c(Client)" scope="index(-120[v$1->v$1])" />
                </extractPlan>
              </filterPlan>
            </filterPlan>
          </multiVarPlan>
          <multiVarPlan complexity="21.1211" eval="10.01/9.45" var="c,v$1">
            <extractPlan complexity="14.6125" eval="6.60/6.30" variable="v$1(Person)">
              <btreePlan complexity="12.6125" eval="3.75/6.30" variable="v$1(Person)" scope="index(-118[all])" />
            </extractPlan>
            <filterPlan complexity="3.2543" eval="3.71/3.15" filter="(c.retired=false)">
              <filterPlan complexity="3.2331" eval="3.69/3.15" filter="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))">
                <extractPlan complexity="3.0" eval="3.45/3.15" variable="c(Client)">
                  <btreePlan complexity="1.0" eval="0.90/3.15" variable="c(Client)" scope="index(-120[v$1->v$1])" />
                </extractPlan>
              </filterPlan>
            </filterPlan>
          </multiVarPlan>
          <multiVarPlan complexity="21.2773" eval="10.01/9.45" var="c,v$1">
            <extractPlan complexity="14.7688" eval="6.60/6.30" variable="v$1(Person)">
              <btreePlan complexity="12.7688" eval="3.80/6.30" variable="v$1(Person)" scope="index(-114[all])" />
            </extractPlan>
            <filterPlan complexity="3.2543" eval="3.71/3.15" filter="(c.retired=false)">
              <filterPlan complexity="3.2331" eval="3.69/3.15" filter="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))">
                <extractPlan complexity="3.0" eval="3.45/3.15" variable="c(Client)">
                  <btreePlan complexity="1.0" eval="0.90/3.15" variable="c(Client)" scope="index(-120[v$1->v$1])" />
                </extractPlan>
              </filterPlan>
            </filterPlan>
          </multiVarPlan>
          <multiVarPlan complexity="22.4568" eval="10.01/9.45" var="c,v$1">
            <extractPlan complexity="15.9482" eval="6.60/6.30" variable="v$1(Person)">
              <btreePlan complexity="13.9482" eval="4.17/6.30" variable="v$1(Person)" scope="index(-117[all])" />
            </extractPlan>
            <filterPlan complexity="3.2543" eval="3.71/3.15" filter="(c.retired=false)">
              <filterPlan complexity="3.2331" eval="3.69/3.15" filter="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))">
                <extractPlan complexity="3.0" eval="3.45/3.15" variable="c(Client)">
                  <btreePlan complexity="1.0" eval="0.90/3.15" variable="c(Client)" scope="index(-120[v$1->v$1])" />
                </extractPlan>
              </filterPlan>
            </filterPlan>
          </multiVarPlan>
          <multiVarPlan complexity="22.8284" eval="10.01/9.45" var="c,v$1">
            <extractPlan complexity="16.3198" eval="6.61/6.30" variable="v$1(Person)">
              <btreePlan complexity="14.3198" eval="4.29/6.30" variable="v$1(Person)" scope="index(-115[all])" />
            </extractPlan>
            <filterPlan complexity="3.2543" eval="3.71/3.15" filter="(c.retired=false)">
              <filterPlan complexity="3.2331" eval="3.69/3.15" filter="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))">
                <extractPlan complexity="3.0" eval="3.45/3.15" variable="c(Client)">
                  <btreePlan complexity="1.0" eval="0.90/3.15" variable="c(Client)" scope="index(-120[v$1->v$1])" />
                </extractPlan>
              </filterPlan>
            </filterPlan>
          </multiVarPlan>
          <multiVarPlan complexity="23.2535" eval="10.01/9.45" var="c,v$1">
            <extractPlan complexity="16.745" eval="6.61/6.30" variable="v$1(Person)">
              <btreePlan complexity="14.745" eval="4.42/6.30" variable="v$1(Person)" scope="index(-126[all])" />
            </extractPlan>
            <filterPlan complexity="3.2543" eval="3.71/3.15" filter="(c.retired=false)">
              <filterPlan complexity="3.2331" eval="3.69/3.15" filter="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))">
                <extractPlan complexity="3.0" eval="3.45/3.15" variable="c(Client)">
                  <btreePlan complexity="1.0" eval="0.90/3.15" variable="c(Client)" scope="index(-120[v$1->v$1])" />
                </extractPlan>
              </filterPlan>
            </filterPlan>
          </multiVarPlan>
          <multiVarPlan complexity="49.2877" eval="11.25/12.60" var="c,v$1">
            <extractPlan complexity="17.5762" eval="5.26/6.30" variable="v$1(Person)">
              <btreePlan complexity="17.5762" eval="5.26/6.30" variable="v$1(Person)" scope="type(Person[all])" />
            </extractPlan>
            <filterPlan complexity="15.8558" eval="4.95/6.30" filter="(c.person join v$1)">
              <filterPlan complexity="15.8346" eval="4.93/6.30" filter="(c.retired=false)">
                <filterPlan complexity="15.8134" eval="4.91/6.30" filter="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))">
                  <extractPlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)">
                    <btreePlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)" scope="type(Client[all])" />
                  </extractPlan>
                </filterPlan>
              </filterPlan>
            </filterPlan>
          </multiVarPlan>
          <multiVarPlan complexity="44.822" eval="11.25/12.60" var="c,v$1">
            <extractPlan complexity="14.4831" eval="6.60/6.30" variable="v$1(Person)">
              <btreePlan complexity="12.4831" eval="3.70/6.30" variable="v$1(Person)" scope="index(-116[all])" />
            </extractPlan>
            <filterPlan complexity="15.8558" eval="4.95/6.30" filter="(c.person join v$1)">
              <filterPlan complexity="15.8346" eval="4.93/6.30" filter="(c.retired=false)">
                <filterPlan complexity="15.8134" eval="4.91/6.30" filter="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))">
                  <extractPlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)">
                    <btreePlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)" scope="type(Client[all])" />
                  </extractPlan>
                </filterPlan>
              </filterPlan>
            </filterPlan>
          </multiVarPlan>
          <multiVarPlan complexity="44.9472" eval="11.25/12.60" var="c,v$1">
            <extractPlan complexity="14.5457" eval="6.60/6.30" variable="v$1(Person)">
              <btreePlan complexity="12.5457" eval="3.72/6.30" variable="v$1(Person)" scope="index(-119[all])" />
            </extractPlan>
            <filterPlan complexity="15.8558" eval="4.95/6.30" filter="(c.person join v$1)">
              <filterPlan complexity="15.8346" eval="4.93/6.30" filter="(c.retired=false)">
                <filterPlan complexity="15.8134" eval="4.91/6.30" filter="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))">
                  <extractPlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)">
                    <btreePlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)" scope="type(Client[all])" />
                  </extractPlan>
                </filterPlan>
              </filterPlan>
            </filterPlan>
          </multiVarPlan>
          <multiVarPlan complexity="45.0808" eval="11.25/12.60" var="c,v$1">
            <extractPlan complexity="14.6125" eval="6.60/6.30" variable="v$1(Person)">
              <btreePlan complexity="12.6125" eval="3.75/6.30" variable="v$1(Person)" scope="index(-118[all])" />
            </extractPlan>
            <filterPlan complexity="15.8558" eval="4.95/6.30" filter="(c.person join v$1)">
              <filterPlan complexity="15.8346" eval="4.93/6.30" filter="(c.retired=false)">
                <filterPlan complexity="15.8134" eval="4.91/6.30" filter="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))">
                  <extractPlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)">
                    <btreePlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)" scope="type(Client[all])" />
                  </extractPlan>
                </filterPlan>
              </filterPlan>
            </filterPlan>
          </multiVarPlan>
          <multiVarPlan complexity="45.3933" eval="11.25/12.60" var="c,v$1">
            <extractPlan complexity="14.7688" eval="6.60/6.30" variable="v$1(Person)">
              <btreePlan complexity="12.7688" eval="3.80/6.30" variable="v$1(Person)" scope="index(-114[all])" />
            </extractPlan>
            <filterPlan complexity="15.8558" eval="4.95/6.30" filter="(c.person join v$1)">
              <filterPlan complexity="15.8346" eval="4.93/6.30" filter="(c.retired=false)">
                <filterPlan complexity="15.8134" eval="4.91/6.30" filter="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))">
                  <extractPlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)">
                    <btreePlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)" scope="type(Client[all])" />
                  </extractPlan>
                </filterPlan>
              </filterPlan>
            </filterPlan>
          </multiVarPlan>
          <multiVarPlan complexity="47.6597" eval="11.25/12.60" var="c,v$1">
            <extractPlan complexity="15.9482" eval="6.60/6.30" variable="v$1(Person)">
              <btreePlan complexity="13.9482" eval="4.17/6.30" variable="v$1(Person)" scope="index(-117[all])" />
            </extractPlan>
            <filterPlan complexity="15.8558" eval="4.95/6.30" filter="(c.person join v$1)">
              <filterPlan complexity="15.8346" eval="4.93/6.30" filter="(c.retired=false)">
                <filterPlan complexity="15.8134" eval="4.91/6.30" filter="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))">
                  <extractPlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)">
                    <btreePlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)" scope="type(Client[all])" />
                  </extractPlan>
                </filterPlan>
              </filterPlan>
            </filterPlan>
          </multiVarPlan>
          <multiVarPlan complexity="48.0314" eval="11.25/12.60" var="c,v$1">
            <extractPlan complexity="16.3198" eval="6.61/6.30" variable="v$1(Person)">
              <btreePlan complexity="14.3198" eval="4.29/6.30" variable="v$1(Person)" scope="index(-115[all])" />
            </extractPlan>
            <filterPlan complexity="15.8558" eval="4.95/6.30" filter="(c.person join v$1)">
              <filterPlan complexity="15.8346" eval="4.93/6.30" filter="(c.retired=false)">
                <filterPlan complexity="15.8134" eval="4.91/6.30" filter="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))">
                  <extractPlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)">
                    <btreePlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)" scope="type(Client[all])" />
                  </extractPlan>
                </filterPlan>
              </filterPlan>
            </filterPlan>
          </multiVarPlan>
          <multiVarPlan complexity="48.4565" eval="11.25/12.60" var="c,v$1">
            <extractPlan complexity="16.745" eval="6.61/6.30" variable="v$1(Person)">
              <btreePlan complexity="14.745" eval="4.42/6.30" variable="v$1(Person)" scope="index(-126[all])" />
            </extractPlan>
            <filterPlan complexity="15.8558" eval="4.95/6.30" filter="(c.person join v$1)">
              <filterPlan complexity="15.8346" eval="4.93/6.30" filter="(c.retired=false)">
                <filterPlan complexity="15.8134" eval="4.91/6.30" filter="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))">
                  <extractPlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)">
                    <btreePlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)" scope="type(Client[all])" />
                  </extractPlan>
                </filterPlan>
              </filterPlan>
            </filterPlan>
          </multiVarPlan>
        </step>
        <step vars="(c)+v$1" future="true">
          <multiVarPlan complexity="20.0677" eval="7.01/6.30" var="c,v$1">
            <filterPlan complexity="15.6015" eval="4.70/6.30" filter="(c.retired=false)">
              <extractPlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)">
                <btreePlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)" scope="type(Client[all])" />
              </extractPlan>
            </filterPlan>
            <filterPlan complexity="2.2331" eval="0.71/0.00" filter="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))">
              <extractPlan complexity="2.0" eval="0.48/0.00" variable="v$1(Person)">
                <boundPlan complexity="0.0" eval="0.00/0.00" variable="v$1(Person)" binding="bound(c.person)" />
              </extractPlan>
            </filterPlan>
          </multiVarPlan>
          <multiVarPlan complexity="32.0022" eval="8.65/9.45" var="c,v$1">
            <filterPlan complexity="15.6015" eval="4.70/6.30" filter="(c.retired=false)">
              <extractPlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)">
                <btreePlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)" scope="type(Client[all])" />
              </extractPlan>
            </filterPlan>
            <filterPlan complexity="8.2004" eval="2.34/3.15" filter="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))">
              <extractPlan complexity="7.9673" eval="2.11/3.15" variable="v$1(Person)">
                <btreePlan complexity="7.9673" eval="2.11/3.15" variable="v$1(Person)" scope="type(Person[set])" />
              </extractPlan>
            </filterPlan>
          </multiVarPlan>
        </step>
        <selected-plans>
          <multiVarPlan complexity="20.0677" eval="7.01/6.30" var="c,v$1" />
          <multiVarPlan complexity="32.0022" eval="8.65/9.45" var="c,v$1" />
        </selected-plans>
  </sub-planning>
</query-planning>


[2023-09-23 22:46:58 #283 query.compiler]
<finalPlans>
  <multiVarPlan 20.0677 7.01/6.30 c,v$1>
        <filterPlan 15.6015 4.70/6.30 (c.retired=false)>
          <extractPlan 15.5803 4.68/6.30 c(Client)>
            <btreePlan 15.5803 4.68/6.30 c(Client) type(Client[all]) />
          </extractPlan>
        </filterPlan>
        <filterPlan 2.2331 0.71/0.00 or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))>
          <extractPlan 2.0 0.48/0.00 v$1(Person)>
            <boundPlan 0.0 0.00/0.00 v$1(Person) bound(c.person) />
          </extractPlan>
        </filterPlan>
  </multiVarPlan>
  <multiVarPlan 32.0022 8.65/9.45 c,v$1>
        <filterPlan 15.6015 4.70/6.30 (c.retired=false)>
          <extractPlan 15.5803 4.68/6.30 c(Client)>
            <btreePlan 15.5803 4.68/6.30 c(Client) type(Client[all]) />
          </extractPlan>
        </filterPlan>
        <filterPlan 8.2004 2.34/3.15 or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))>
          <extractPlan 7.9673 2.11/3.15 v$1(Person)>
            <btreePlan 7.9673 2.11/3.15 v$1(Person) type(Person[set]) />
          </extractPlan>
        </filterPlan>
  </multiVarPlan>
</finalPlans>


[2023-09-23 22:46:58 #284 query.manager]
<newQueryProgram>
  <multiVarPlan complexity="20.0677" eval="7.01/6.30" var="c,v$1">
        <filterPlan complexity="15.6015" eval="4.70/6.30" filter="(c.retired=false)">
          <extractPlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)">
            <btreePlan complexity="15.5803" eval="4.68/6.30" variable="c(Client)" scope="type(Client[all])" />
          </extractPlan>
        </filterPlan>
        <filterPlan complexity="2.2331" eval="0.71/0.00" filter="or((toLower(v$1.nic)=:q),(v$1.phone2=:q),(v$1.phone1=:q),(toLower(v$1.ssNumber)=:q),(toLower(v$1.localReferanceNo)=:q),(toLower(c.phn)=:q))">
          <extractPlan complexity="2.0" eval="0.48/0.00" variable="v$1(Person)">
            <boundPlan complexity="0.0" eval="0.00/0.00" variable="v$1(Person)" binding="bound(c.person)" />
          </extractPlan>
        </filterPlan>
  </multiVarPlan>
</newQueryProgram>


[2023-09-23 22:47:01 #285 query.manager]
<newQueryResponse isUnique="false" resultSize="7" fetchSize="0">
  <ObjectResultBuilder name="new lk.gov.health.phsp.pojcs.ClientBasicData(c.id, c.phn, c.person.name, c.person.nic, c.person.phone1, c.person.address )" type="java.lang.Object">
        <SimpleResultBuilder name="c.id" type="java.lang.Long" />
        <SimpleResultBuilder name="c.phn" type="java.lang.String" />
        <SimpleResultBuilder name="c.person.name" type="java.lang.String" />
        <SimpleResultBuilder name="c.person.nic" type="java.lang.String" />
        <SimpleResultBuilder name="c.person.phone1" type="java.lang.String" />
        <SimpleResultBuilder name="c.person.address" type="java.lang.String" />
  </ObjectResultBuilder>
</newQueryResponse>