User Tools

Site Tools


tplcontrolbrowsefuzzymatching.htm
Navigation:  Templates > Guide to all Templates > Control Templates >====== BrowseFuzzyMatching control template ====== Previous pageReturn to chapter overviewNext page

The BrowseFuzzyMatching control template adds a set of controls (a GROUP box containing an ENTRY control and two BUTTON controls, Search and Clear), that lets end users perform weighted searches and sorts of the result.

The query examines the columns in the BrowseBox queue, (ListBox fields and Hot Fields), and returns the data sorted in their order of relevance to the search criteria. At runtime, the BrowseBox may contain an extra column that shows a calculated match result. Prior to searching, the initial match result is 100%. No match to the search criteria gives a 0% match result.

Requirements:

This template requires a BrowseBox control.

Populating the Control Template

1.Open the Window Designer for any procedure that contains a BrowseBox control.

2.Open the Control Templates Pad

3.Click on the BrowseFuzzyMatching entry for the corresponding Browse in the Control Templates Pad, and then click on the window at the position where you want the Fuzzy Search controls to be placed. This populates an ENTRY control, two BUTTON controls, and a GROUP box surrounding them.

4.Modify the text and properties of these controls as desired. For example, you may want to change the text of the GROUP box to read “Search Personnel Records” instead of the default text.

5.RIGHT-CLICK on the GROUP box, then select Actions from the popup menu to set the Fuzzy Match options.

Template Prompts

The BrowseFuzzyMatching template provides the following prompts:

Display Match Results in Browse Listbox Check this box to display the match result percentage in the Browse Listbox.
Display Match Results in Browse Listbox Check this box to display the match result percentage in the Browse Listbox.
Display Where Specifies the position of the match result column in the Browse Listbox. Choose from:
First ColumnPopulates the match result column as the first column in the Browse Listbox.
Last ColumnPopulates the match result column as the last column in the Browse Listbox.
Column Format Specifies the display format of the match result column. The formatting information is set using the same syntax as the FORMAT() attribute for a LIST control.
Match Score Filter Value Specifies the minimum match value to display in the Browse Listbox. Using a value of 1 will filter out any data that has no matches to the search data.
Reset Fuzzy Match Result Order on Control Event? Check this box to reset the Browse Listbox results from another control and event on the window.
Control Choose a control from the droplist that will control the reset of the query.
Event Choose the event (Selected or Accepted), which will force a reset on the query when it occurs on the selected control.
Fuzzy Group Resize Options Allows the definition of the resizing techniques to use for the group of populated controls.
Resposition Strategy Specify how the horizontal and vertical position is determined when the end user resizes the window. Valid reposition equates should be used. The reposition EQUATE's are defined in ABRESIZE.INC. The default is set to Resize:FixNearestX + Resize:FixNearestY.
Resize Strategy Specify how the control's height and width is determined when the end user resizes the window. Valid resize equates should be used. The resize EQUATE's are defined in ABRESIZE.INC. The default is set to Resize:LockSize

Global Options

From the Application Tree, press the Global button.

Select the General tab if it is not already selected.

The following prompts are available from the Global Options dialog, Enable Fuzzy Matching, and Fuzzy Matching Options'Ignore Case and Word Only. See Template Overview'Global ABC Template Settings'General Tab Options.

tplcontrolbrowsefuzzymatching.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1