AW: Searches of a list

Rudolf Bargholz rudolf at
Sun Jan 1 08:10:22 UTC 2023

Hi Das,

A $search loops through the list lines, and normally you want to test each line for a pattern in one of the columns in that list line. For this I tend to use "$ref." in my search structure.

> )>0|pos('b',low(ilMasterList.CB_NAME))>0|pos('b',low(ilMasterList.CB2_
> CER))>0|pos('b',low(ilMasterList.CB_MAST))>0


> CER))>0|pos('b',low(($ref.CB_MAST))>0

So your search would be 

Do ilMasterList.$search([icSearchString])

Or better, for testing purposes:

Do ilMasterList.$search( pos('b',low($ref.CB_SPEC))>0|pos('b',low(($ref.CB_COMM))>0|pos('b',low(($ref.CB_NAME))>0|pos('b',low(($ref.CB2_
> CER))>0|pos('b',low(($ref.CB_MAST))>0 )

You might want to try this out when fully written out as code, to see if this works as you expect before you put the search pattern in a variable and use this variable in your search string using square brackets.

If you are not working with nulls, you could also change your search pattern to

Do ilMasterList.$search(kFalse)
If ilMasterList.$search(
) > 0
  ;; Then I have found some lines
End If

as long as you are sure not to have NULL values in the data. Not sure if this is faster though. It is, in my opinion, a little easier to read.


Rudolf Bargholz

-----Ursprüngliche Nachricht-----
Von: omnisdev-en <omnisdev-en-bounces at> Im Auftrag von Das Goravani
Gesendet: Samstag, 31. Dezember 2022 19:49
An: OmnisDev List - English <omnisdev-en at>
Betreff: Re: Searches of a list

Method 1
Do ilMasterList.$search([icSearchString])

Method 2
Set current list ilMasterList
Set search as calculation {[icSearchString]} Search list (From start,Select matches (OR),Deselect non-matches (AND),Do not load line)

Neither of the above two approaches works to select lines in the list

> On Dec 31, 2022, at 1:40 PM, Das Goravani <goravanis at> wrote:
> I am doing a search of a list in Studio 4 on Windows
> I cannot get it to search my list. Examining it after this executes, there are no "S"s on the list lines when you examine the contents of the variable. I have tried my list.$search() and Set search as calculation way. 
> Is this a valid list search for "Set search as calculation"
> pos('b',low(ilMasterList.CB_SPEC))>0|pos('b',low(ilMasterList.CB_COMM)
> )>0|pos('b',low(ilMasterList.CB_NAME))>0|pos('b',low(ilMasterList.CB2_
> CER))>0|pos('b',low(ilMasterList.CB_MAST))>0
> It’s just the same thing over 5 times… if the search string, in this 
> case letter b, is in any one of the 5 fields, then select this line
> And when you use Set Search as Calculation with a VAR containing your search, do you use square brackets?
> Ie
> Set search as calculation [mySearchString]
> Or do you NOT use square brackets in that case.
> Do you think this should work
> Do myList.$search( [mySearchString] )

Manage your list subscriptions at Start a new message -> mailto:omnisdev-en at 

More information about the omnisdev-en mailing list