LoadCollection Filter in Form Script

nhussey

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.

Stephen Cena

You need to add the wildcards around the {1}:

sFilter = Sting.Format("Username='{0}' and GroupName like '%{1}%'"), username, "eCRP")

I'm blanking if the wildcard is % or *, but one of those should to it.