SQL problem

[karam mohammed 1]

Hello, I use this SQL to filter library entries by (Done ) field, which is Boolean field . The filter work only if done is checked in edit modebut didn't work if I check Done in card , table or list enteries 

Thanks in advance 

SELECT 

  id,

  "Patient",

  "Done"

FROM "test 2"

WHERE 

  removed = 0

  AND CAST("Done" AS INTEGER) = 0

[David Gilmore]

I suspect your issue is that when a field is updated in the Edit screen, the "Before/After Create" and  "Before/After Update" triggers are run. However, when updating a field in a card, table or list view, those triggers are not (the Before or After Field Update triggers are run, though).

But why are you doing the "Cast"? Why not just:

 SELECT id, Patient, Done from "Test 2" WHERE removed = 0 and Done = false

[karam mohammed 1]

i tried this and it didn't work . the problem is only with Boolean field

[David Gilmore]

It certainly works for me, both on Android and on the PC. Could you share whatever error message you might have gotten?

[David Gilmore]

I take it back. My test was incorrect, it does fail on the PC like you say. But does work on Android.

[David Gilmore]

Further correction: I did get it to work on the PC. (Scripting is a little different on the PC than it is on Android. I rarely script on the PC).

But I did the where clause without the CAST to work on the PC .

[karam mohammed 1]

With Boolean?

[David Gilmore]

Yes, exactly as I showed. Remember that the "false" is in lower case.

I had some problems when testing my SQL string on the PC, which I was able to finally fix by closely examining the error messages. Which is why I asked to see yours.