| || |
Filter syntax for field with lookup list
Can anyone help with the correct syntax for setting a filter on field where a lookup list is used. On the data entry side, the filter looks like this:
Field = Blue;Green -- where a user would have placed a check next to each value in the list
I am running OTA scripts, so I expected my code to look something like this:
myBug2.Field("BG_USER_30") = """Blue&;Green"""
I have tried various combinations and concatenations but am receiving no luck. I am using the bugfactory object.
Thanks for any insight here.
Re: Filter syntax for field with lookup list
Did you try
myBug2.Field("BG_USER_30") = "Blue OR Green"