-1

Export a report on the Contract Record Type ID's. I want the name and Record type ID's (18 digit long ID's) of the Contract record types who's name starts with "BUNDLE".

3
  • 2
    Appu, it doesn't appear as you've done a lot of research before asking and I'd encourage you to do so. You can query the RecordType object using SOQL to achieve what you're after.
    – Matt Lacey
    Oct 23, 2012 at 6:24
  • Agreed with LaceySnr .This can be easily researched and let us know if you still did not get any hint Oct 23, 2012 at 6:55
  • 1
    You can start here : eu1.salesforce.com/help/doc/en/reports_overview.htm
    – Saariko
    Oct 23, 2012 at 7:18

1 Answer 1

2

This can't be done with reports, however, you can achieve this by using the Dataloader and exporting to CSV, you can then open the csv in Excel, Open Office or something else.

  1. Start up the dataloader
  2. Log in
  3. Export
  4. Check "Show all salesforce objects" at the top
  5. Click on RecordType in the list
  6. At choose target for extraction: you pick a directory on your hard drive where the CSV must be stored. Click NEXT
  7. In the next window, at the bottom, in the box saying "the generated query will appear below. You may edit it before finishing" you fill in:

    SELECT Name, Id, DeveloperName, SobjectType FROM RecordType WHERE SobjectType = 'Contract' AND DeveloperName LIKE 'BUNDLE%'

  8. Click Finish

  9. If a message box appears, click YES
  10. Now go to the directory you picked in step 6, and there you'll find your export.

Good luck!

3
  • 1
    Alternatively use workbench.developerforce.com and user query in step 7. Choose to export results as a csv Oct 23, 2012 at 8:33
  • Thanq thanq,,,its work
    – appu
    Oct 23, 2012 at 8:47
  • Your problem is fixed now? If so, please upvote my answer and mark it as correct please :)
    – pjcarly
    Oct 23, 2012 at 8:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.