I'm trying to add a data selection rule to a table in Jet Data Manager Data Sources. The field seems to contain boolean values (they show as 0/1 in SQL Server queries and True/False in Jet Table Preview). I've tried "Current Status = 1" and "Current Status = True". Using "True" causes the Deploy and Execute to fail and using "1" has no effect i.e. Deploying and Executing and then previewing table shows no impact.
I've also tried applying a filter to a numeric field in the same source and this also has no effect.
We have a filter working on another data source which works as expected.
Has anyone got any ideas? I must be missing something.
Thanks in advance
Data Selection Rule - not working