Page 1 of 1

Filter doesn't give expected records

Posted: 2021-04-01 04:47
by Philou
Hello,

I use the last appgini 5.95 rev 1136
character enconding UTF8

I have a simple table with records and try to use filter on a field containing varchar value (3 differents values comming from a dropdown selector).
when I create a filter... I don't have errors but the results are not correct.


I have 50 records in the table
30 have the value 'Soldé'
3 have the value 'En cours'
17 without values => NULL

when I try to filter records doesnt contain 'Soldé' I just have the 3 records 'En cours' but I don't have the 'NULL' records

Re: Filter doesn't give expected records

Posted: 2021-04-01 08:03
by D Oliveira
are you using UTF-8?

Re: Filter doesn't give expected records

Posted: 2021-04-01 19:15
by Philou
Hello,

yes I use UTF-8

I have try to change DB content to escape this kind of issue => replacing 'Soldé' by 'Solde' does not change the result

:?

Re: Filter doesn't give expected records

Posted: 2021-04-17 02:48
by sacgtdev
I also want to know the workarounds to show NULL records when the filter was applied.