You need to sign in to do that
Don't have an account?
Shriwastab Singh
How to fetch Object's all fields which value is not null .Is it possible by apex SOQL .
Hi
I want to fetch all fields which values is not null by SOQL like (Select * from ObjectName)
exp - Object A have 10 fields
In Obj A has 3 fieds values null and 7 is not null.So I fetch all not null vaues by SOQL
I want to fetch all fields which values is not null by SOQL like (Select * from ObjectName)
exp - Object A have 10 fields
In Obj A has 3 fieds values null and 7 is not null.So I fetch all not null vaues by SOQL
Hi Sriwastab,
Try this and for an exception, You can not filtred Address=null so plz skip this fields.becz address fields are concate with four fields
if you found this answer helpful then please mark it as best answer so it can help others.
Thanks
Akshay
All Answers
try this code I hope is very helpful for you.
if you found this answer helpful then please mark it as best answer so it can help others.
Thanks
Akshay
System.QueryException: Address fields can only be filtered using Distance expressions
Hi Sriwastab,
Try this and for an exception, You can not filtred Address=null so plz skip this fields.becz address fields are concate with four fields
if you found this answer helpful then please mark it as best answer so it can help others.
Thanks
Akshay