Extract the real value of the relationship lookup field in soql
I'm a newbie to soql relationship queries. I've been trying to to get this working but not sure if this is even possible.
Select Id, Name, CustomObject__r.name From Account where customobject__c != null
Gives me a result that has a column of 'customobject__c', but which I have to click on to see the real value. I want to see the real value in the table, so that I can extract it to a csv. CustomObject is a lookup field in Account.
Is this possible? Thanks.
You need a better SOQL editor. What are you using at the moment?
Data Loader (officially supported tool) should give you these full relationship "path names" when you export data but it's a bit too clunky to be used on daily basis. You'd be designing your queries in one tool and pasting them to DL...
I'm a big fan of RealForceExplorer ;) See How to add comments in SOQL for some hints and pick your favorite editor.
- Creating firebase user with authentication information from Salesforce
- Problem with sha pointer ["error": "--from is not a valid sha pointer: \"origin/master\"",]
- Getting error unable to get local issuer certificate in Bruno
- How to connect apex(salesforce) language server using raw Java?
- How to get allMetadata retrieval using SF VSCode.. insufficient access rights on entity: GenAiPromptTemplate
- Error when testing chained queueable apex in Salesforce
- Looking for hacks to shim objects when their prototype are sealed
- Add wordpress custom post type data to an external db
- SOQL Query - How to write a SOQL query by making a field to lowercase and compare?
- Connecting Palantir to Salesforce - how do you access the data tables (the SObjects)?
- How to show only extracted error message from Custom Validation on a Visualforce Page?
- How to upload files and attachments to the sobject record using REST API?
- HTTP Callout restriction doesn't allow Record-Triggered Flow to run on updates
- Get a list of API Names of all Fields for an Object.
- Adding comment to a commit when Azure release pipeline fails
- How to change the Button background color in lightning Data Table on onrowaction?
- OpenSSL not creating a key file from a RSA private key
- How to change value in tooltip charJS
- How to Click a Button Inside an LWC Component Using TestCafe?
- Username/password JWT with Salesforce Named Credentials
- salesforce rest api INVALID_SESSION_ID error
- How to create a Salesforce Case with attachments using REST API?
- Salesforce User with a certain profile can only delete contact base on Account.field__c and the user.field__c is the same
- Copy activity and query with new Salesforce connector
- Given that node modules can't be used, suggest an approach integrating Roomle with Salesforce
- Authenticate Salesforce community user using rest api in connected App
- How to package a Custom Metadata Type in a Salesforce 2GMP (Second Generation Managed Package)?
- How to Pass Selected Record IDs from a Custom Object List View to an Apex Controller?
- Dynamic form fields on lightning record page is not working
- INTERNAL ERRORS Bigquery Data Transfer Services for Salesforce