If you have a comment on this topic, contact Aptify Documentation. If you want to return to the Aptify Community Site, please click here.

Creating a View in the Aptify 5.5.2 and up Web Interface

Since Aptify 5.5.2, the web interface includes support for the creation of List, Chart, Calendar, Map, and Card 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 steps to create a list view in web interface:

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

     More Actions - Create View

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

     

  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.

     

  6. Create and define Filters by specifying the Field Name, Operator, and Value.
    • 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 field from the list.



    • 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 View

    • 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 the Refresh button, resets the filter logic to default (statements combined using AND).

       
      Changing Filter Logic

    • 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 the Refresh button, resets the filter logic to default (statements combined using AND).

       
      Using NOT Filter Logic

    • 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.

       


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

       
      Deleting a Filter

  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.

       
      Add a New Field

  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 Field

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

       
      Changing Sorting Order

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

      Adding Sorting Preferences

  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 default, specify the alternate base view here.

      Note

      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 View

You can also create Prompted views. For detailed information, see Creating Prompt Views

Copyright © 2014-2017 Aptify - Confidential and Proprietary