Versions Compared

Key

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

Insert excerpt
_Banners
_Banners
nameanalysis
nopaneltrue

By the end of this section you will be able to:

  • Set a default sort order on a

...

  • view

Find the

...

table for this exercise:

  1. Open the analysis model

...

  1. Screens and Forms 01-08: Views, filters and

...

  1. screens

...

  1. Click on the table Overall Debt Levels, and go to the Sort Orders

...

  1. section.
  2. Add a sort order:

    ...

      1. Press 
        Insert excerpt
        _addIcon
        _addIcon
        nopaneltrue
        .
      2. Name: PaymentMeans,DebtLevel.
      3. Press
        Insert excerpt
        _save
        _save
        nopaneltrue
        .
      4. Press 
        Insert excerpt
        _table_attributes_show
        _table_attributes_show
        nopanel

    ...

    • You add attributes to the sort by dragging them into the right-hand column (Order Attributes)
    • You change the sort order by pressing Image Removed against an order attribute

    ...

      1. true
         under Sort Order Attributes.
      2. Add PaymentMeans to the list of Sort Order Attributes.
      3. Leave this as ascending (up arrow).
      4. Add DebtLevel to the list of Sort Order Attributes.
      5. Update this to descending - click on the arrow, it will reverse the direction (down arrow).
      6. Press 
        Insert excerpt
        _finish
        _finish
        nopaneltrue
         to save the sort order.
    1. Press
      Insert excerpt
      _save
      _save
      nopaneltrue
       on the table settings.
    2. Open the screen Overall Debt Levels
    3. Insert excerpt
      _view_show
      _view_show
      nopaneltrue
       configuration for the view.
    4. Set this as the Default Sort Order

    ...

    1. .
    2. Press 
      Insert excerpt
      _finish
      _finish
      nopaneltrue
      to save your changes

    ...

    1. .
    2. Go into
      Insert excerpt
      _app_mode
      _app_mode
      nopaneltrue
       to see the results.

    Add a further sort order to the

    ...

    table:

    1. Right-click on the view and press
      Insert excerpt
      _show_table_configuration
      _show_table_configuration
      nopaneltrue
    2. In the Sort Orders section, press 
      Insert excerpt
      _addIcon
      _addIcon
      nopaneltrue
    3. Name: PaymentMeans,CalculationDate
    4. Sort by PaymentMeans (ascending), CalculationDate (ascending)

    You will use this sort order in the next exercise.

    In PhixFlow, any saved sort order used on a view on a

    ...

    table can be used on any other view defined on that

    ...

    table.