To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82199 Issue #|82199 Summary|Formfilter does not work on booleans (JDBC) Component|Database access Version|OOo 2.3 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ftoth
------- Additional comments from [EMAIL PROTECTED] Tue Oct 2 20:26:29 +0000 2007 ------- This problem has been found using postgresql over jdbc (both in OO2.0.4 on debian and 2.3 on w2k and wxp). Step 1 Here's the results for Autofilter on a table: With postgresql over JDBC you need to use the "mixed" mode. Using "default" the error is: error boolean = integer (it tries to compare boolean field "billable" = 1) Using "SQL"and "Access" the error is: error setting filter criterium (it tries to compare "Billable" IS TRUE) Using "Mixed", Autofilter works fine. Step 2 Using Autofilter on a form in Mixed mode also works. Step 3 But using Formfilter on a form (still in mixed mode): Error: operator does not exist: boolean = integer. Once a boolean filter is applied using the Autofilter, you can go to FormFilter and apply additional (non boolean) filters without error. Ferry --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]