Searches of a list
kellyb at montana.com
Tue Jan 3 06:30:17 UTC 2023
> From Kelly I received the thing that really made it work, that is, how to square bracket the search.
> Instead of
> Use instead
> Calculate myString as con('$Search.',mySearchString)
> Do myList.[myString]
> It’s just a twist on how you do the square bracket, but it WORKED and that’s what matters.
That was slightly misquoted. The Calculate myString con() is wrong. It should be:
Calculate myString as con('$search(',mySearchString,')')
The point is to wrap the search string with $search(). It's the same 'trick' that I use to define a list with a user-selected set of columns. I found that
does not work, but the same approach of wrapping the columns string with $define() does work.
Calculate define as con('$define(',colString,')')
It's just something about the way the Omnis parser works.
More information about the omnisdev-en