Web Service

Reason why data does not come out even if you search in the list view of Salesforce

Share this for your friends.

Reason why data does not come out even if you search in the list view of Salesforce


When I try to view the data in Salesforce, the data that should have been registered does not appear...


Salesforce is a CRM (customer management system) and a web service used all over the world.

Although it is a web service, it has a certain degree of customizability, and many companies use it for purposes other than sales.


However, the specifications of foreign-affiliated services are difficult to understand. occurs.

Why can't I find it when I search?

Therefore, Today, I will introduce reasons why data does not appear when searching in the list view of Salesforce.

Author


Mid-carieer engineer (AI, system). Good at Python and SQL.

Advantage to read

You can understand "Reason why data does not come out even if you search in the list view of Salesforce". Then you can find data in Salesforce.


Data does not come out even if you search in Salesforce

First, let's take a look at Phenomenon of data not appearing when searching in Salesforce.


As a reference, let's look at the data in the Trailhead environment for Salesforce education.

(Data picks leads, but they don't have to.)

Salesforce data sample (Trailhead environment)
Salesforce data sample (Trailhead environment)

The data displayed here is small, but as the amount of data increases, it becomes tempting to search the data.

Therefore, even if you enter the string you want to search in "Search this list" surrounded by red frame, No data.

I know that if the data is not registered, it will not come up even if I search, but The data that should have been registered does not come out That's what it means.


I want to search, but I can't. . . why?


Why is this happening?



Reason why data does not come out even if you search in list view of Salesforce

The reason why you can't find any data by searching in Salesforce list view is that list view search is limited to the first 2000 items.


What do you mean?
You are searching within 2000, not all.


The list view search help says:

When you search a list view, only the first 2,000 records in the list are searched. If you can’t find your record, try a more specific search or modify your filters or sorting. For example, your accounts list view contains 8,000 records. You search for an account that starts with Z, but that account isn’t in the search results. To find the account you want, sort the Account Name field from Z to A so that the account beginning with Z falls in the first 2,000 records listed. You can also add filters to make the list view more specific.

Reference:Search List Views in Lightning Experience


Search in list view is limited to the first 2000 results instead of 2000 results.

So even if the data you want to find is registered, if it is not in the 2000 cases, it cannot be searched by list view search.

Usability is quite subtle.


Isn't it bad for searching?
Honestly, it's pretty hard to use


Moreover, there are considerable restrictions on search conditions.

Search doesn’t find partial strings in a field label unless the string is at the beginning of the label or the string follows a space. This rule applies to strings of words and numbers. For example:

A search for the word commun finds Edge Communications, but a search for the string dge or cation doesn’t.
A search for the number 12 finds Leads Report 12 but not Leads Report-12.

Reference:Search List Views in Lightning Experience


Even if it's not 2000, it's easy to use



Use "Global Search" to search data in Salesforce

Salesforce's list view search has a limit of 2000 searches, and it was a specification that even existing data could not be searched.

So it's not the case that you can't search in Salesforce.

There are ways to search for data in Salesforce.


Use "Global Search" to search data in Salesforce.

The global search box is above the list view search box.


Salesforce Global Search
Salesforce Global Search

The global search box corresponds to the red frame on the screen above.

Here, you can search without receiving 2000 contracts.

However, in this case, if you do not specify the search range, it will search other than the lead, so if you want to search only the lead narrow down the search to the lead in advance. .


This is better if you can just get the data that exists properly




Conclusion

Today, I explained the reasons why data does not appear when searching in the list view of Salesforce.


The reasons why data does not come out even if you search in the list view of Salesforce are as follows.

Important notice

  • The search range of the list view search is not all data, but only the first 2000, so data not included in the first 2000 cannot be searched


If you want to search data, use global search at the top of the screen instead of list view search.


It's hard to understand intuitively.
We don't know, but maybe Salesforce has its own policy



There are other articles about web services, so please take a look if you are interested.


Share this for your friends.

If you felt this article is useful, please share.

にほんブログ村 IT技術ブログへ

-Web Service
-,

© 2023 ITips