Example of use of 'contains' to search for a sub-string when using zoho.crm.searchRecords - needs asterisks (wildcards)

Example of use of 'contains' to search for a sub-string when using zoho.crm.searchRecords - needs asterisks (wildcards)

In case anyone else has this question...I wasn't as clear from reading the documentation how to make this work...so I did some experimentation and came up with the following - the trick is to place asterisks directly before and after the 'substring' you are searching for (it doesn't make sense to me to ask users to do this)...note I am searching the 'First Name' field of CRM records...

searchSubString = "";
searchSubString = searchSubString + "(First Name|contains|";
searchSubString = searchSubString + "*" + input.Search_First_Name_By_Substring + "*";
searchSubString = searchSubString + ")";

// Display this to help with debugging...

alert "The searchSubString is :" + searchSubString;

ContactsList = zoho.crm.searchRecords("Contacts", searchSubString);

Hopefully this can help someone else.

Regards, 

Liam.