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

When we set the editing type of the platform database field to select another table, we usually set it as follows:

The effect of this setting is as follows:

The above setting method can also achieve the function of selecting other tables, but if we want to select people, we can only click the down arrow in the picture to enter the selection interface, enter the filter criteria, and filter them; so what if we want to enter the filter criteria directly in the box behind the applicant?

We can set up quick retrieval when selecting settings for his table:

The running effect is as follows:

We can see that in the above settings, we set the quick retrieval of names to: include, while the quick retrieval of input codes is set to: left matching.

What's going on?

For better illustration, let's first set the quick retrieval of the input code to include

Run to view the results:

Do you see the difference?

Set the shortcut of the input code to: include, left match the difference is:

When the shortcut of the input code is set to match on the left, we enter the C letter, and the names of the people queried, and the simplified spelling all begin with the C letter.

When the shortcut of the input code is set to include, we enter the C letter, and the names of the people queried may not all begin with C, but all contain the C letter; similar to fuzzy query

Original address: http://bbs.delit.cn/thread-946-1-1.html

Please indicate the source of the reprint

Written by: measurement Technology http://www.delit.cn

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.