Firebird Migration: Form-Based Filters Don't Work

After migrating an existing ODB database to Firebird with the new migration assistant in LO 6.1.2 on MacOS, when I open my Form to view the database and attempt to perform a search using a Form-Based Filter I cannot complete the search.

I can click on the Form-Based Filter and the pop-up Filter Navigator appears and I am able to select my criteria (tested a few check boxes). Then I click Apply Form-Based Filter and I simply get the first record of all in alphabetical order. The navigation is greyed out and my Table Control scroll box is blank.

Any thoughts on what may be the issue?

Hello,

Have checked multiple forms and subform using Form based filter and all work without a problem.

Then tested specifically with checkboxes. When selecting this say as check is ON, the comparison is set to field = 1 and the problem you specify shows up. If, however, you edit this comparison to field = TRUE then the filtering works without a problem. Use TRUE, FALSE & IS NULL.

Wouldn’t call this a migration problem but rather just a Firebird problem.

Just tested the Form-Based Filter with field=TRUE in place of field=1 and indeed it now works. Also tested the number fields and text fields and all appears to work ok. Thank you.
Moving forward, what is the best way to address this? My database and form makes extensive use of checkboxes for fast searching, and it will be quite tedious to manually change the “1” to “TRUE” for each criteria. Any way to set this to always be 1=TRUE and 0=FALSE either in the table, the form designer, or other?

File Bug Report

Done, see Bug 120713

That’s good but as stated in answer it isn’t a migration problem. It’s more a Firebird SQL situation. Happens in Firebird Server connection also.

Bug title edited to remove ‘Migration’.