Starting November 20, the site will be set to read-only.
On December 4, 2023,
Apex Code Development (90768)
General Development (55146)
Visualforce Development (37251)
Lightning (18265)
APIs and Integration (17146)
Trailhead (11680)
Formulas & Validation Rules Discussion (11337)
Other Salesforce Applications (8116)
Jobs Board (6655)
Force.com Sites & Site.com (4842)
Mobile (2694)
You need to sign in to do that
Don't have an account?
naj Hi
"3) Editted the query by select id,name from recordtype where name="xxxxx"" is only for workbench if you want to get the record id. and xxxxx in "xxxxx" is your record name
but if you got below steps in dataloader than that should do
1) tried to export the opportunity object and selected all the fields.
2) added a condition saying recordtypeid equals
012A0000000kBZ9IAM
as you select fields and add the condition you should see that your query is building up as below in query window. then finish.
Select Id, IsDeleted, AccountId, RecordTypeId FROM Opportunity WHERE RecordTypeId = '012A0000000kBZ9IAM'
All Answers
You can use the Dataloader to export out into CSV file from the Opportunity Object.
Ya i tried to export using dataloader but the file tht i am trying to export is in one of the record type. When i selected the opportunities object ,it not showing the record type thats in the opportunity.
Any help?
one thing you can do is find the recordtypeid for your record type from recordtype table by exporting the data out of that table or running
select id, name from recordtype where name ="xxxxxx"
and then use that id as filter on opportunity object by using recordtypeid field
else you can use workbench and then select opportunity object then run below soql
Select <include all fields you want seperated by comma> ,o.recordtype.name From Opportunity o where o.recordtype.name ='YOUR RECORD TYPE NAME'
Hi Manohar,
I am trying to follow your message
1) tried to export the opportunity object and selected all the fields.
2) added a condition saying recordtypeid equals
012A0000000kBZ9IAM
3) Editted the query by select id,name from recordtype where name="xxxxx"
Should i mention xxxxx as the recordtype name? i.e. IDX
"3) Editted the query by select id,name from recordtype where name="xxxxx"" is only for workbench if you want to get the record id. and xxxxx in "xxxxx" is your record name
but if you got below steps in dataloader than that should do
1) tried to export the opportunity object and selected all the fields.
2) added a condition saying recordtypeid equals
012A0000000kBZ9IAM
as you select fields and add the condition you should see that your query is building up as below in query window. then finish.
Select Id, IsDeleted, AccountId, RecordTypeId FROM Opportunity WHERE RecordTypeId = '012A0000000kBZ9IAM'