Skip to main content
OCLC Support

SearchList

Find the syntax, use, parameters, return values, and an example for the SearchList macro command in Connexion client.
Syntax nNumRecords = CS.SearchList (sSearchTerm, sColumnName, bExactMatch)
Use to Search for a specified term in the current list data. You can specify the column name to search. You can also specify to match the search text exactly.
Parameters
  • For sSearchTerm, enter the search term string.
  • For sColumnName, enter the column name string.
  • For bExactMatch, enter true to match the search term exactly, or enter false to also return terms with different case or that contain the term.

    Examples:
    • If you specify exact match, the search term Jones does not retrieve jones.
    • If you specify no exact match, the search term free can also retrieve Free or freedom.
Comments The search is not case-sensitive.
Return values An integer, the number of records found.
Example Sub Main()

     Dim CS As Object
     Dim nNumRecords As Integer

     Set CS = GetObject(,“Connex.Client”)

     If CS.IsOnline = False Then
          CS.Logon ““, ““, ““
     End If

     If CS.Search(“WC”, “gon,wi,th,w/bks/1983-2003”) > 0 Then
          nNumRecords = CS.SearchList(“Margaret”, “Description”, False)

          MsgBox (nNumRecords) + “ records found”
     End If
End Sub

What this example does
  • Logs on to Connexion if not already logged on, using the default authorization and password you selected in Tools > Options > Authorizations tab.
  • Searches WorldCat for the title Gone with the Wind in Books format only and only items published between 1983 and 2003.
  • If the search retrieves multiple records (a brief list in this case), searches the description column of the list for any instance (not case-sensitive) of the term Margaret.
  • Returns the number of records containing Margaret or margaret in the message X records found (where X = the number of records).
  • Selects the records that contain the search term.