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".

  • 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 '12 at 6:24
  • Agreed with LaceySnr .This can be easily researched and let us know if you still did not get any hint – Mohith Shrivastava Oct 23 '12 at 6:55
  • 1
    You can start here : eu1.salesforce.com/help/doc/en/reports_overview.htm – Saariko Oct 23 '12 at 7:18
up vote 2 down vote accepted

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!

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

Your Answer

 
discard

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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