Differences

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

--- visionx:data_modeling_and_representation [2020/06/08 12:16]
cduncan [Set data read-only]
+++ visionx:data_modeling_and_representation [2020/06/08 12:21]
cduncan [Specify a BETWEEN filter]
@@ Line 461: / Line 461: @@
 {{:visionx:data_modeling_and_representation:views_storages_step7.png?nolink|Storage as data source: Desktop app Assets}}
-However, I do not want all that information to be editable in this screen. Let's set some of the data as readonly.
+However, I do not want all that information to be editable in this screen. Let's set some of the data as read-only.
 ===== Set Data as Read-Only =====
@@ 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").
@@ Line 505: / Line 505: @@
 {{:visionx:data_modeling_and_representation:filters_step3.png?nolink|Filters: result desktop}}
-===== Filters use IConditions =====
+===== Filters Use IConditions =====
 How does this work? Each filter editor creates an [[http://www.sibvisions.com/files/jvx/current/api/index.html?javax/rad/model/condition/ICondition.html|ICondition]] and is connected to other conditions by the logical operator AND. In other words, if multiple filters are set, the result contains only those rows that match all of the filters.
-Of course VisionX supports more than one search mode to use in filters and conditions. These are:
+Of course, VisionX supports more than one search mode to use in filters and conditions. These are:
 ^Search mode       ^Description                                                                                                                                 ^
@@ Line 521: / Line 521: @@
 |**Starts with**   |Matches all literals that start with the entered value ignoring the character casing. <html><br></html>Supports ?, * and % as wildcards.    |
-All the above filters operate on a specific column.
+All of the above filters operate on a specific column.
-===== Full text search =====
+===== Full Text Search =====
-And what about the default search editor, we've used in all our screens so far? If you just drag and drop the "Search" editor to a screen, a filter with the following specification is created:
+What about the default search editor we've used in all of our screens so far? If you just drag and drop the "Search" editor to a screen, a filter with the following specification is created:
 ^Search mode         ^Description                                                                                                          ^
@@ Line 532: / Line 532: @@
 The "full text search filter" operates on all columns of the data object.
-===== Specify a BETWEEN filter =====
+===== Specify a BETWEEN Filter =====
-Let's implement the possibility to filter for assets issued in a specific timespan, in other words, between two dates. Simply drag and drop two Search Editors and bind them to "[Localized Assets.Issue Date]" (1). Use "Greater equals" (2) for the first filter and "Less equals" for the second filter.
+Let's implement the possibility to filter for assets issued in a specific time span, in other words, between two dates. Simply drag and drop two search editors and bind them to "[Localized Assets.Issue Date]" (1). Use "Greater equals" (2) for the first filter and "Less equals" for the second filter.
 {{:visionx:data_modeling_and_representation:filters_step4.png?nolink|Filters: specify between filters}}