where codniton with multiple fields

[soniasweety]

Hi all,

I want to load data where multiples is not null or non Zero for 3 fields

I have tried this but not working any other alternate?

Where isnull(Avgscore)=0 and isnull(Isdate)=0 and isnull(attendies)=0;

[QFabian]

Hi @soniasweety , please check if this works :

Where
not isnull(Avgscore) and Avgscore <>0 and
not isnull(Isdate) and Isdate<>0 and
not isnull(attendies) and attendies<>0;

[MayilVahanan]

Hi @soniasweety 

Try like below

where Len(Trim(Avgscore)) > 0 and Len(Trim(Isdate))>0 and Len(Trim(attendies))>0 and Avgscore <> 0 and Isdate <> 0 and attendies<> 0;

-- Len(Trim(Avgscore)) > 0 and Len(Trim(Isdate))>0 and Len(Trim(attendies))>0 <-- it will check for null values 

-- Avgscore <> 0 and Isdate <> 0 and attendies<> 0 <-- it will check for zero values