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, 2016 at 17:46

1 Answer 1


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 and acknowledge that you have read and understand our privacy policy and code of conduct.

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