Loading

Salesforce Reports Automatically Use the 18-Character Record ID When Filtering by Record ID

Julkaisupäivä: May 4, 2026
Kuvaus

When adding a filter to a Salesforce report using a record's Salesforce ID, entering a 15-character ID will automatically convert it to the full 18-character version once the filter is applied. For example, if you enter the 15-character ID "001ABC123DEF456", Salesforce automatically converts it to the 18-character case-safe version "001ABC123DEF456GHI" when the filter is saved. This is expected behavior in Salesforce reports.

Ratkaisu

Salesforce report filters internally use the 18-character record ID format, also known as the case-safe ID. The report user interface displays only the 15-character ID in the column view. Both IDs refer to the same record, and the automatic conversion to 18 characters is by design.

How to Display the 18-Character Record ID in a Report

If you need to display the full 18-character Record ID as a column in your report, you can create a Formula field on the object:

  1. Navigate to Setup and open the Object Manager for the relevant object (for example, Account or Contact).
  2. Select Fields and Relationships, then click New.
  3. Select Formula as the field type and click Next.
  4. Give the field a label such as "18-Character Record ID" and set the return type to Text.
  5. In the formula editor, enter the following formula: CASESAFEID(Id)
  6. Save the field.
  7. Add the new formula field as a column in your report to display the 18-character Record ID.
Lisäresurssit

To convert 15 - character ID to 18 - character ID, please refer the below article:

https://help.salesforce.com/s/articleView?id=000385066&type=1

Knowledge-artikkelin numero

005131264

 
Ladataan
Salesforce Help | Article