Data Selection Rule - not working


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

1 comment

Please sign in to leave a comment.