1 Reply Latest reply: Nov 8, 2012 1:22 AM by Jagadeesh P RSS

    search UI with wild char % not working

    954933
      all,

      i have created the below BS for search and in UI page when pass like operator in address1 field %main street% then search BS does not return anything , if i pass full address then it will return all the result set. for some reason search BS is not taking % for wild search, how do i get wild % search in BS? help is appreciated.

      here is my BS schema with Service Program CILCPRAS

      <schema searchBy="MAIN">
      <address1 mapField="ADDRESS1"/>
      <city mapField="CITY"/>
      <postal mapField="POSTAL"/>
      <Results type="list">
      <premiseId mapField="PREM_ID"/>
      <address1 mapField="ADDRESS1"/>
      <city mapField="CITY"/>
      <address mapField="ADDR_INFO"/>
      </Results>
      </schema>
        • 1. Re: search UI with wild char % not working
          Jagadeesh P
          Looks like you are using a different service which does not perform wild char search.

          Try this service CILCPRMS. let me know if this helps

          <schema searchBy="ALT">
          <address1 mapField="ADDRESS1"/>
          <city mapField="CITY"/>
          <postal mapField="POSTAL"/>
          <Results type="list">
          <premiseId mapField="PREM_ID"/>
          <address1 mapField="ADDRESS1"/>
          <city mapField="CITY"/>
          <address mapField="ADDR_INFO"/>
          </Results>
          </schema>


          Result :

          <xx-test>
          <address1>%ver%</address1>
          <postal/>
          <Results>
          <premiseId>2818516677</premiseId>
          <address1>100 Evergreen Avenue</address1>
          <city>Plainfield</city>
          <address>100 Evergreen Avenue, Plainfield, NJ, 07060</address>
          </Results>
          <Results>
          <premiseId>1840655541</premiseId>
          <address1>1004 Revere Avenue</address1>
          <city>San Francisco</city>
          <address>1004 Revere Avenue, San Francisco, CA, 94124</address>
          </Results>
          <Results>
          <premiseId>7585375530</premiseId>
          <address1>1224 Vermont Street</address1>
          <city>San Francisco</city>
          <address>1224 Vermont Street, San Francisco, CA, 94110</address>
          </Results>
          <Results>
          <premiseId>8035948527</premiseId>
          <address1>1228 Vermont Street</address1>
          <city>San Francisco</city>
          <address>1228 Vermont Street, San Francisco, CA, 94110</address>
          </Results>
          <Results>
          <premiseId>1324018867</premiseId>
          <address1>1232 Vermont Street</address1>
          <city>San Francisco</city>
          <address>1232 Vermont Street, San Francisco, CA, 94110</address>
          </Results>
          .
          .
          .
          .
          <Results>
          <premiseId>9226078790</premiseId>
          <address1>3774 Palos Verdes Way</address1>
          <city>South San Francisco</city>
          <address>3774 Palos Verdes Way, South San Francisco, CA, 94080</address>
          </Results>
          <city/>
          </xx-test>