I am trying to migrate my Flex eSearch widget to the CMV Search widget. The query is not working. What can I do to make it work? Flex query:

<value prompt="Example: MN or MNPC">upper(ICAOcode) LIKE upper('%[value]%')</value>

CMV query = expression:

(upper \arpt_name\ LIKE upper \'%[value]%'\)

  • 1
    Please take the tour and edit your question to include what you have already tried and what exactly isn't working. If you are receiving an error message, include that. If you are receiving unexpected results, explain what those are vs. what you are expecting. – MaryBeth Apr 27 '16 at 17:46

The only change you should need to make to your original Flex where clause is to escape the single quotes around the value using the slash character:

expression: 'upper(ICAOcode) LIKE upper(\'%[value]%\')',

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.