Good afternoon! I am fairly new to Syteline but I have a grid on a subcollection. I also have a variable that I need to use to filter my grid on.
I can't find the proper syntax for filtering that grid on.
I have tried FILTER(Lot = FV(LotFromRcvVar)) - I get an incorrect syntax near ) error
I tried FILTER(Lot = FP(LotFromRcvVar)) - get an error that FP isn't a recognized built in function name
and tried ILTER(Lot = LotFromRcvVar) - I get an incorrect syntax near ) error.
This is in the grid|Binding|Properties|(Selection Options)Filter
I don't see much documentation on this.
Does someone have some insight?
Thanks!