Full Text Search Filter

From WorkWithPlus 12 you will be able to use a new type of filter: "Full Text Filter". This kind of filter allows the developer to do cross filters which contemplate more than one attribute.

For example if you have the following transaction:

Company transaction structure in GeneXus shows the attribute list: CompanyId (Numeric 4.0, key), CompanyName (Character 20), and CompanyAddress (Address, GeneXus domain), each with a Description column and Nullable set to No.

And the following Selection:

Generated Company Work With Plus web application, under Other Options > Developer Menu > Company, displays a grid with Insert, Excel, PDF, and Select columns buttons above a search box, listing companies with Id, Name, and Address columns (e.g. 3M, Disco, DVelop Software, Geant, Genexus, IBM, Peugeot, Salto Grande, Tata), paginated across 2 pages.

You can filter by CompanyAddress or by CompanyName in the same search box:

Company Work With Plus grid filtered by a full-text search entry "Av It" typed into the search box (top right, marked by a red arrow), narrowing results to companies whose Address column (also flagged with a red arrow) contains that text: 3M, Genexus, Peugeot, and Tienda Inglesa, all with Av Italia address.

Company Work With Plus grid filtered by full-text search "DV" entered in the search box (red arrow), matching the Name column (also marked with a red arrow) and returning a single result, DVelop Software with Id 1, on Page 1 of 1.

To have this kind of filter you need to add a 'Filter Full Text' Node within a Grid Object (Selection, Prompt, Grid tab in View, etc.):

GeneXus pattern tree context menu with Add submenu expanded, listing node types to insert under Standard Action (ManageFilters): ErrorViewer, TextBlock, Image, FontIcon, UserTable, UserControl, WebComponent, Panel, Group, Section, Flex, ResponsiveTable, Attribute, Variable, VariableBasedOn, Table, Grid, FreeStyleGrid, Orders, FilterAttributeRange, FilterAttribute, FilterAttributeMultiple, FilterFullText, DynamicFilter, UserAction, StandardAction, ActionGroup, and Tabs; FilterFullText is highlighted and pointed to by a red arrow, with a build output panel showing "Building Succes..." behind the menu.

Then you need to customize the attributes which the filter will englobe with the property 'Attributes':

Company Selection pattern editor with the Full text filter node selected in the tree, its Properties panel showing Attributes set to "Default attributes" (highlighted, pointed to by a red arrow) and an open Full text filter attributes dialog listing Att. name/Att. description pairs (CompanyId/Company Id, CompanyName/Company Name, CompanyAddress/Company Address) with Add, Remove, Move up, Move down, OK, and Cancel buttons.

By default the attributes added depends on their types and what is configured in "WorkWithPlus Settings" -> "Filters" in the property "Include In Full Text Filter":

WorkWithPlus Pattern Settings dialog, Filters tab, with the Character filter type selected in the tree on the left (listing StartsWith, Contains, Empty for Character and Varchar, and LowerThan, Equals, HigherThan, GreaterThan0, Empty for Numeric, plus several Date filters). A red arrow points to the Properties panel on the right showing Default Operator (like), Default Operator Type (With dynamic operators), Include In Full Text Filter (True), Condition Casing (None), and Grid Title Filter settings (Include Title Filter True, Search Box Single, Data List Dynamic, Allow Multiple Selection False, Data List Include Total Records True, Data List Max Values 50).