Differences

This shows you the differences between two versions of the page.

--- visionx:data_modeling_and_representation [2020/06/08 12:16]
cduncan [Define the Writeback Table]
+++ visionx:data_modeling_and_representation [2020/06/08 12:18]
cduncan [Filters]
@@ Line 487: / Line 487: @@
 ====== Filters ======
-To be honest, showing the location table in the departments screen is dispensable. As my use-case is to show all available assets by their locations, I could have done easier by creating a filter editor for the asset's location. Let's give a try:
+To be honest, showing the location table in the departments screen is dispensable. As my use-case is to show all available assets by their locations, I could have done so more easily by creating a filter editor for the asset's location. Let's give that a try:
 Open the "Assets with Filter" screen in designer view and drag and drop the "Search" editor (1) to the screen (2).
@@ Line 493: / Line 493: @@
 {{:visionx:data_modeling_and_representation:filters_step1.png?nolink|Filters: add filter}}
-Select the editor, press the "Customize" icon (1) and specify the Search Mode in the lower part of the popup. Let's select "Like" as search mode (2) and "[Localized Assets.Location]" as column (3) to search in.
+Select the editor, press the "Customize" icon (1), and specify the search mode in the lower part of the popup. Let's select "Like" as search mode (2) and "[Localized Assets.Location]" as column (3) to search in.
 {{:visionx:data_modeling_and_representation:filters_step2.png?nolink|Filters: specify filter}}
-VisionX automatically creates a drop-down list for the location filter editor due to the Automatic Link Reference between the storage [Localized Assets.Location] and the table LOCATIONS. But the "Like" filter does more than simple text matching. You can use the wildcard character ? as placeholder for any single character and * or % as placeholders for any number of characters.
+VisionX automatically creates a dropdown list for the location filter editor due to the automatic link reference between the storage [Localized Assets.Location] and the table LOCATIONS. But the "Like" filter does more than simple text matching. You can use the wildcard character ? as placeholder for any single character and * or % as placeholders for any number of characters.
 For example, you may want to filter for assets at locations starting with "South" (such as **South**lake, **South** San Francisco or **South** Brunswick) by entering "South*" (or "South%") into the location filter editor. Or you enter "*en*" (or "%en%") to get all assets at locations containing "en" (such as "UK C**en**tral" or "V**en**ice").