Edit

Introduction

MyViews is a term we use to describe the "list" displays throughout the application. In addition to presenting you with column information, you can manipulate these displays in several ways to better represent the information in a manner that best suites your needs. There are a ton of features available with MyViews, so this document serves to outline all of these features regardless of which product you are utilizing.

Note: Many of the "advanced" features described in this document are only available as part of Premier.

Edit

Locating Rows

In MyViews, you can locate a data row by typing the initial characters of the values contained in this row.

To locate the nearest row that contains a specific value in a specific column, do the following:

• Focus any cell in the column, against which a search will be performed.
• Type the initial character(s) of the value to be located. The nearest row that contains the specified value in the clicked column will be located.
• To proceed with the search in the forward direction, press CTRL+DOWN ARROW.
• To proceed with the search in the backward direction, press CTRL+UP ARROW.
• To erase the previously typed characters in the search string, press BACKSPACE.

Edit

Hide Columns

Do one of the following:

• Click a column header and drag it onto the grid control's cell area, until the cursor changes its image to big 'X'. Then drop the header.

• Drag and drop a column header onto the Customization Form if it's open:

Edit

Show Hidden Columns

• Open the Customization Form by right-clicking a column header and selecting Column Chooser:

• The Customization Form will be displayed listing hidden columns (if any):

• Drag the required column from the Customization Form onto the column header panel and drop it at a specific position.

Edit

Reorder Columns

To reorder columns, drag and drop a column header to a new position:


Edit

Resize Columns

To resize columns, drag the right edge of the target column header:


To change a column's width so that it displays its contents compactly in their entirety, do one of the following:

• Double-click the right edge of the column header.
• Right-click the column's header and select Best Fit:

To change the widths of all columns so that they display their contents in the best possible way, right-click the header of any column and select Best Fit (all columns).

Edit

Sort Data

To sort records by a column's values and replace existing sort conditions that are applied to the current or other columns, click the target column's header until a UP or Down Arrow icon is displayed within the header. The Up and Down Arrows indicate ascending and descending sort orders respectively.



To sort records by a column's values while preserving existing sort conditions, do one of the following:

• Click a column header while holding the SHIFT key down, until an UP or Down Arrow icon is displayed within the header.
• Right-click a column header and select Sort Ascending or Sort Descending from the context menu that will appear:

To remove sorting by a column, click a column header while holding the CTRL key down.

Edit

Group Data

To group by a specific column, do one of the following:

• Drag a column header from the column header panel to the group panel:

• Right-click a column header and select Group By This Column from the context menu:

Edit

Ungroup Data

To ungroup data by a grouping column, do one of the following:

• Drag a column header from the group panel to the column header panel:

• Right-click a grouping column's header and selecting the UnGroup from the context menu:

To remove grouping by all columns, right click the group panel and select Clear Grouping from the context menu:



Edit

Change Group Order

To change group order, move a grouping column header to another position within the group panel:



Edit

Create a Simple Filter

To select records that contain a specific value in a specific column field, do the following:

Invoke the filter dropdown list containing available filter values. See below on how to do this. By default, if filtering is applied, the filter dropdown will only display the values which match the current filter criteria. If the SHIFT key is pressed while opening the filter dropdown, all values will be listed (not only those that match the current filter criteria).

Select the required filter value in the filter dropdown list:

The filter dropdown list will be immediately closed, and the control will display the records which contain the specified value in the specified column field.

If the filter dropdown list provides check boxes to the left of filter values, multiple values can be selected (checked) simultaneously:


In this mode, click Ok to close the filter dropdown list and apply the filter. You can sequentially filter data against multiple columns using the method described above.

Edit

Create Complex Filter

To construct filter criteria involving multiple columns fields, and using various comparison operators, do one of the following:

• Invoke the filter dropdown list (see below) and click Custom. This will invoke the Custom Filter Dialog, allowing you to compare a column with one or two values:

Use the Filter Builder, that allows complex filter criteria to be constructed.

Edit

Clear the Filter

To clear the filter applied to a specific column, do one of the following:

• Invoke the filter dropdown list (see below) and click (All).
• In MyViews, right-click the column header and select Clear Filter:

To clear the total filter criteria, click the Close Filter button within the Filter Panel:



Edit

Disable/Enable the Filter

Click the Enable Filter button within the Filter Panel:


Edit

Filter Dropdown List

• Hover over the column header. Click the filter button (} within the column header that appears.

Edit

Filter Editor

The Filter Editor is used to edit filter criteria. To create and customize filter criteria, use the and buttons embedded into the control and context menus supported by the editor's elements:


Remarks

A filter condition group is a set of conditions combined by the same logical operator. The following filter expression contains two groups combined by the logical OR operator: "(Product = 'Chang' And Quantity > 20) Or (Product In ('Tofu', 'Konbu') And Quantity < 100)". In the Filter Editor it's represented as follows:



Edit

Add Conditions

To add a condition to a logical group, do one of the following:

• Focus any condition within the group or the group's logical operator and then press INSERT or ADD on the keyboard.
• Click the button for the group.
• Click the group's logical operator and select Add Condition.

To add a group of conditions to another group, do one of the following:

• Focus any condition within the group or the group's logical operator and then press CTRL+ADD on the keyboard.
• Click the group's logical operator and select Add Group.
• To add a condition or a group of conditions that have been copied to the clipboard, press CTRL+V or SHIFT+INSERT. The new condition will be added to the focused group.

Edit

Delete Conditions

To delete a condition, do one of the following:

• Focus the condition and press DELETE or SUBTRACT.
• Click the button.

To delete a group of conditions, do one of the following:

• Focus the group's logical operator and press DELETE or SUBTRACT
• Click the group's logical operator and select Remove Group.

To delete all conditions, do one of the following:

• Focus the topmost logical operator and press DELETE or SUBTRACT.
• Click the topmost logical operator and select Clear All.

To cut a condition/group of conditions to the clipboard, focus this condition/the group's logical operator and press CTRL+X or SHIFT+DELETE.

Edit

Work with Clipboard

To copy a condition/group of conditions to the clipboard, focus this condition/the group's logical operator and press CTRL+C or CTRL+INSERT.

To cut a condition/group of conditions to the clipboard, focus this condition/the group's logical operator and press CTRL+X or SHIFT+DELETE.

To paste a condition/group of conditions from the clipboard to the focused group, press CTRL+V or SHIFT+INSERT.

Edit

Change Column in a Filter

To change a condition's column, invoke the column list by doing one of the following:

• Click the current column.
• Focus the current column via the keyboard and press SPACE or ALT+DOWN ARROW.

Then, choose the required column from the list that will be invoked

Edit

Change Op in a Filter

To change a condition's operator, invoke the operator list by doing one of the following:

• Click the condition's current operator.
• Focus the current operator via the keyboard and press SPACE or ALT+DOWN ARROW

Then, choose the required operator from the list that will be invoked.

Edit

Edit a Condition's Value

To edit a condition's value, click the operand value and type text.

To activate the operand value's edit box without changing the value, click the value or focus the operand value via the keyboard and press F2, SPACE, ENTER or ALT+DOWN

To close the active edit box, press ENTER.

To discard changes to the value and close the active edit box, press ESC.

Edit

Compare Col vs Col

Do one of the following:

• Click the toggle button:

• Press CTRL+Q

Then, specify the column via the operand value's edit box.

Edit

Navigation

To focus a specific filter condition or a group's operator within the Filter Editor, do one of the following:

• Click the target element.
• Use Arrow keys to move focus via the keyboard.

Edit

Invoke the Filter Editor

To invoke the Filter Editor do one of the following:

• Right-click any column's header and select Filter Editor:

• If the filter panel at the bottom of the grid control is visible, click the Edit Filter button:

The Filter Editor is also invoked when choosing the (Custom...) item in a column's filter dropdown list, if the current filter criteria applied to the column consists of three or more simple filter conditions, or if the filter criteria contain advanced comparison operators such as "Is between" and "Is any of".