Shulou(Shulou.com)06/02 Report--

This article mainly introduces "how to solve the problem that data can not be searched after adding Dr to my contact on Fiori". In daily operation, I believe many people add Dr to my contact on Fiori. After searching for the problem that there is no data, the editor consulted all kinds of information and sorted out a simple and easy-to-use method of operation, hoping to help you answer the question of "how to solve the problem that you can't find data after adding Dr to my contact on Fiori." Next, please follow the editor to study!

After maintaining Account on My task UI, click Contact F4 value help:

We found that on GM6, as long as you add "Dr" to the search field, you can't search for contact, as shown in the figure below. But change it to something like "Florianna Adler".

Last night we struggled for a long time to know why there was such a strange behavior.

The reason was found through debug in the morning:

At first we suspected that the search after adding Dr did not come out with results, because DB did not query the data. After verification this morning, it was found that it was not. The open sql of Contact is dynamically generated in the following method:

These four tables are mainly used as inner join:

Then dynamically execute OPEN SQL in the following method, hitting 40 pieces of data.

The reason for hitting 40 entries is that the where condition of OPEN SQL is to scan the mc_name1 of account and the mc_name1 and mc_name2 of contact.

Therefore, data such as the first and third rows in the following figure also hit because one of their three column's value contains "DR":

After DB search finishes, do filter.

Iterate through the 40 entry of the result set one by one, perform three rounds of scanning for each entry, the scanning conditions are defined in lt_search_f ­, and each entry will only be returned to UI after all three rounds of scanning.

The specific logic of the scan: check whether the three red field of an entry contain the specified key word for each scan. If not, remove the row entry from the result set and process the next one.

Therefore, the reasons why the results cannot be found after adding Dr:

Contact F4 search still passes Dr as a free text to the background. After the background retrieves the data from DB for filter, if the string DR is not included in the three column of the result set, it will be filtered out from the result set. Only contact shaped like Andrew,Dragon in name1 & name2 has a chance. Search comes out.

At this point, the study on "how to solve the problem of not finding data after adding Dr to my contact on Fiori" is over. I hope to be able to solve everyone's doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.