Loading

Hyperlink fields used as a filter in SOQL, Reports, and List View show unexpected results

Дата публикации: Nov 20, 2025
Описание
Hyperlink fields in Salesforce allow users to store and display URLs as clickable links within records. Despite their usability, hyperlink fields in Salesforce have a limitation when it comes to using them as filter criteria in queries. Users are unable to directly use the equal (=) sign to filter records based on the content of hyperlink fields.

Syntax- HYPERLINK(url, friendly_name [,target])
[url] is the Web address, [friendly_name] - link text, and [target] tells the window or frame in which to display the content.

If you have a formula custom field that contains a HYPERLINK function, the server generates an HTML anchor for the link. For example, this function: HYPERLINK("/apex/VF_TEST", "VFLINK",'_self') generates this HTML output: <a href="/apex/VF_TEST" target="_self">VFLINK</a>.

Unlike other types of fields, such as text fields or date fields, where equal (=) operation is straightforward. Hyperlink has its own internal storage format, as a result, it cannot be directly utilized as a filter criterion when querying/filtering using an equal ('=') sign or operator.
Решение

As a workaround, use the LIKE or CONTAINS operator in the queries to filter records based on partial matches within the hyperlink field's content. This can be particularly useful when searching for specific keywords within the hyperlink descriptions.

Номер статьи базы знаний

000396201

 
Загрузка
Salesforce Help | Article