BUG? FMP 12: Portal Filter work with literal search but not global variable?!
Very simply put, I have a portal pointing to database "X" and told to FILTER based on matching X:TextFieldName = "TEST" (literally as in I spelled it out in quotes), it works. All records in X:TextFieldName = "TEST" are listed.
When I change the filter to X:TextFieldName = $$global_var and set $$global_var = "TEST" I get completely wrong results. Am I missing something here? I have data viewer visible showing that $$global_var = "TEST" and I have even tried to set manually.