1 Reply Latest reply: Dec 11, 2012 3:31 PM by wlessard RSS

    Binding Parmeter

    976799
      I am trying to create a templated theme (for Oracel Maps JavaScript API) with 'LIKE' operator. ie Wildcard. Can somebody help me how I can do that. Thanks in advance.


      Khairul
      City of Toronto
        • 1. Re: Binding Parmeter
          wlessard
          Hi - I was able to do something similar using the Oracle MapBuilder utility, maybe the XML syntax produced by this tool will you.

          In my example I'm only displaying the STATE theme for those US States which have an abbreviation beginning with 'A%': (i.e Alabama, Alaska, Arizona, Arkansas).

          <?xml version="1.0" standalone="yes"?>
          <styling_rules>
          <rule>
          <features style="C.STATES"> (STATE_ABRV like 'A%') </features>
          <label column="STATE_ABRV" style="T.STATE_ABBRV"> 1 </label>
          </rule>
          </styling_rules>

          Notes:
          - C.STATES is a "color style" rendering the colour grey enclosed by a black border.