You need to sign in to do that
Don't have an account?
Rich13
Contains in Data Loader
Hi,
How to use Contains in Data Loader. I would like to export Task records with text field "Subject" contains "ABC" . But Data loader filter doesn't have the Contains operator as it is in the SFDC reports.
Please help.
Thank you
Hi,
We don't have that option for Tasks to use the contains option to extract the records through dataloader. But you can create a formula field(Text type) by giving in the list. After that when you're using the Data loader, use the custom field for extracting data into CSV file.
If this post is helpful please throw Kudos.If this post solves your problem kindly mark it as solution.
Thanks,
Subhani,
Salesforce Certified Developer,
www.mydbsync.com.
Subject LIKE '%ABC%'
Hello,
Can you use LIKE operator to retreive the details.
select id,name from objectname where name like '%ABC%'
Thanks,
Krishna
Hi Vbs,
It does not show up in the Operator field you can type contains and the value in the value box ( say click on add button), you will see the query and that will also give you your result.
Regards,
Ashish
Tutorial here : https://nicolas.vuillamy.fr/how-to-detect-bad-words-in-salesforce-records-using-sfdx-data-loader-and-sfdx-hardis-171db40a9bac