This discussion is archived
1 Reply Latest reply: Nov 7, 2012 11:22 PM by Jagadeesh P RSS

search UI with wild char % not working

954933 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points