NOT Exists (function behavior)

[pablolabbe]

I attached a sample application to test the strange behavior when using not exists against a previous loaded field with same fieldname and different fieldname compared.

Someone has an explanation ?

[lironbaram]

hi

the problem is that while evluating the value on the field dt_table2

in the start you your exists list contain one value 01/01/2009 ,

so the first rows don't load because the filed in the date_filter table

but after the first row with the vakue 02/01/2009 is loaded from table 2

now the exsits list is containing two values 01/01/2009,02/01/2009

so all the dont load either

it because your filter field and traget field have the same name.

[lironbaram]

hi

the problem is that while evluating the value on the field dt_table2

in the start you your exists list contain one value 01/01/2009 ,

so the first rows don't load because the filed in the date_filter table

but after the first row with the value 02/01/2009 is loaded from table 2

now the exsits list is containing two values 01/01/2009,02/01/2009

so all the dont load either

it because your filter field and traget field have the same name.