Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Since Aptify 5.5.2, the 6.0 web interface includes support for the creation of List, Chart, Calendar, Map, Card and Card Pivot Grid views through the web interface. For the Gantt and Pivot Table view types, users will need to create the views using the Aptify Desktop client. Additional details on creating views and view types can be found in Using the Viewing System.

...

...

Aptify 5.5.4 adds the Pivot Grid view to provide similar functionality to the Pivot Table view in the web interface. See Using Pivot Grid Views in the Web Interface for more information.

Example: Creating a List View

Follow these the below steps to create a list view View in web the Aptify Web interface:

  1. Open the Service for which you want to create a view and click the More Actionsbutton.
  2. Select Create View from the drop-down menu.

     More Actions - Create ViewImage RemovedMore - Create ViewImage Added

  3. Enter a name for the view in the Name field, and select List View from the View Type drop-down menu.

     Example Create ViewImage RemovedExample Create List ViewImage Added

  4. If you want to specify an alternate base view, select Advanced > Configuration from the drop-down and specify it now. Changing to base view later will reset the settings you have already configured.
  5. Select Filters from the drop-down menu.

     Select Filters from Drop-downImage RemovedFilters in Drop-Down MenuImage Added

  6. Create and define Filters by specifying the Field  ID, First Name, Operator, and Value Company.
    • Click the Add button to create a new line/filter.
    • Start typing in the name of the field you want to include and select it its field from the list.
      Image Removed
      Then specify the operator and value. You can also create a prompted filter as well by select the Prompted button next to the Value field.
       
      Adding Filters to a ViewImage RemovedAdd FiltersImage Added

      Filters addedImage Added
    • If you want to combine filters using an OR logic, you can do so by clicking the Logic button and change the logic from AND to OR. Note that clicking if you click the Refresh button, resets the filter logic will be reset to default (statements combined using AND).

       
      Changing Filter LogicImage RemovedImage Added

    • If you want to combine filters using and AND NOT or AND OR, you can do so by clicking the NOT button on the appropriate filter line. The button will be enabled. To remove the NOT logic, simply click the NOT button to disable it. Note that clicking if you click the Refresh button, resets the filter logic will be reset to default (statements combined using AND).

       
      Using NOT Filter LogicImage RemovedNot Filter LogicImage Added

    • You can also change the sequence and nesting for filter statements by selecting the Move Filter button on the filter statement you want to move and dragging it to a new location.

       
      Image RemovedMove FilterImage Added

    • To delete a filter, click the Delete button at the end of the filter statement.

       
      Deleting a FilterImage RemovedDelete FilterImage Added

  7. Select Fields from the pull-down menu, and select the Fields you want to include in the view.
    • The fields that are included by default are displayed in the right column and are fields that are included in the Default In View option for the service's Entities record.
    • To remove a field, select the field and drag it to the left column or use the "<" arrow to move it to the left. You can also move all fields at once with the "<<" arrow.
    • To add additional fields, select the field and drag it to the right column or use the ">" arrow to move it to the left. You can also move all fields at once with the ">>" arrow.
    • To rearrange the order of the fields, select the field you want to move and drag it (up or down) to the appropriate location in the right column.

      Image Added
       
      Add a New FieldImage Removed

  8. Select Sorting from the drop-down menu, to apply default preferences for sorting.
  9. Create and define Sorting by specifying a Field Name and Sort Order for any criteria you would like to sort.
    • Start typing in the name of the field you want to sort by and select the appropriate field.
      Selecting Sorting FieldImage Removed
      Sorting Image Added

    • Be By default each field is sorted in ascending order, however, you can change the sorting direction by clicking the Sort Order button.

       
      Changing Sorting OrderImage RemovedChange Sorting OrderImage Added

    • To delete a filter, click the Delete button at the end of the field.
      Adding Sorting PreferencesImage Removed
      Delete SortingImage Added

  10. If you want the view to run on a specified delay/at a designated time you can do so on the Scheduling tab. See Scheduling a View to Run Automatically for more information.
  11. Select Advanced > Configuration from the drop-down to do the following configurations:
    1. Entity Base View: If you want the view to use a different base view than the default, specify the alternate base view here.

      Note
      titleNote

      Changing the base view will clear all any settings that you have configured up to this point so it is recommended to specify the base view you want to use first.

    2. Form and Record Template: Reserved for future use.
    3. Preview Template: You can specify the template that appears when using the Preview Pane option. If none is specified, the default template from the entity will be displayed.
    4. Folder: If you want this view to be part of a view folder, you can specify the folder here.
    5. Show Preview Pane: This option is disabled, the preview pane is always hidden by default.
    6. Read Uncommitted: When checked, records that are locked can be read and when unchecked the records are blocked
  12. Select the Advanced > SQL from the drop-down menu to view the SQL syntax for the view. Note that the SQL is not editable in this version of the Aptify web interface.
  13. After adding your desired information, click OK to complete and launch your view.
    Click OK to Create ViewImage Removed
    Click OK to Create View	Image Added

You can also create Prompted views.