You need to sign in to do that
Don't have an account?
Mario Conteddu 1
Filtering null long text area fields in SOQL
Would it be possibile to filter null long text area fields in SOQL?
I need to run process where if a number of text area fields in contact are null then do something.
Thanks in advance!
Yes, Sandhya is right. You can not use text area field in filter critea but you can check null after query for eg.
I hope this helps you.
Thanks,
Sukanya
All Answers
You can not use text area fields in SOQL and SOSL filter criteria's.
Please refer below links which have some proposed solution that can help you.
https://developer.salesforce.com/forums/?id=906F00000008zxSIAQ
http://lc169.blogspot.sg/2013/06/long-text-field-limitations.html
http://sfdcmaniac.blogspot.sg/2014/03/you-cannt-include-textarea-fields-in.html
Hope this helps you!
If this helps you , please mark it as solved so that it will be available for others as a proper solution.
Thanks and Regards
Sandhya
Yes, Sandhya is right. You can not use text area field in filter critea but you can check null after query for eg.
I hope this helps you.
Thanks,
Sukanya
you can achieve this by using a formula field in your custom object,
Try the below formula to calculate the number of fields that are not blank:(give your text area fields hereas field1 field2 field3...)
You will get the number of null fields in that field and can use it in your logic
Let me know if you have any issues.
Regards
If the operation whichi you want to perform are not much complex.
You can use Process Builder to do the same.
Thanks
Ajay Mishra
Email: mishraajay.m1@gmail.com