I'm trying to build a filter statement for a LoadCollection in the form script for Syteline 10 On Prem. I was wondering if there was a way to build it to act the way sql does when using 'like'.
For example, we have several similar groups that have permissions to different fields on a custom form, and I want to grab which group that user is a part of (each group has 'eCRP' in the name). In Sql, I'd write <select * from UserGroupMaps where username = '[username]' and GroupName like '%eCRP%'>, is there a way I can do this for the LoadCollection filter?
The way I'm imagining it'd work is <sFilter = Sting.Format("Username='{0}' and GroupName like '{1}'"), username, "eCRP")> though it doesn't seem to work.