[SalesForce] How to get an 18 digit ID from 15 digit ID using SOQL

I have a 15 digit Sfdc ID, but I do not know which object it belongs to.

How can I find out which objects it belongs to and the convert it to 18 digits – all using SOQL?

P.S. I was annoyed at having to do this manually every single time, so I created a small app that detects 15 digits SFDC IDs and then automatically up converts them to 18 digits.

Video: https://www.youtube.com/watch?v=1xwd9WkcG10

Github: https://github.com/rgelb/SfdcIdUpConverter

Download: https://github.com/rgelb/SfdcIdUpConverter/releases/download/1.2/SfdcIdUpConverterSetup.exe

P.S. The code no longer works with the latest rev of Salesforce. I am not planning to make any updates as I no longer work with Salesforce. If anyone wants to fork the GitHub repo, it might live on.

Best Answer

To convert it to 18 digits you can simply set it to an Id type variable:

Id someId = '001J000001eun1Q';

Which will automatically convert it for you:

system.debug(someId); // 001J000001eun1QIAQ

Then you can simply call the getSObjectType() method on the Id variable which will return the object name:

Schema.SObjectType objectType = someId.getSObjectType();
system.debug(objectType); // Account

Related Solutions

[SalesForce] How to get the current timestamp using SOQL query

Date values are stored in UTC time format in Salesforce, the timezone is only applied when the date is displayed. If you are in Apex, you can use the various methods it provides to return an automatically adjusted value or the GMT value.

Remember that dateTime field values are stored as Coordinated Universal Time (UTC). When one of these values is returned in the Salesforce application, it is automatically adjusted for the timezone specified in your organization preferences. Your application may need to handle this conversion.

You can retrieve the current time zone using the UserInfo class.

TimeZone tz = 
  UserInfo.getTimeZone();
System.debug(
  'Display name: ' + 
  tz.getDisplayName());
System.debug(
  'ID: ' + 
  tz.getID());

[SalesForce] Does Userinfo.getUserId ALWAYS return 18 digit ID

From my observation, UserInfo.getUserId should always return an 18-character ID. However, the return type is "String" for this method, so there is no guarantee that the return value will always be the 18-character ID format. However, you can guarantee that an ID will always be 18-characters if you use the Id data type:

Id userId = UserInfo.getUserId();

This works because the Id type automatically validates the String is a valid ID and automatically calculates the parity bits for the ID (the last three characters).

Best Answer

Related Solutions

[SalesForce] How to get the current timestamp using SOQL query

[SalesForce] Does Userinfo.getUserId ALWAYS return 18 digit ID

Related Topic