Asset Sorting Tool

Last Updated: 17 Dec 2015

The Asset Sorting Tool allows users to permanently re-order assets in the Asset Map based on a standard asset field, such as asset id or asset name or an asset attribute field such as name or file for a MS Word Document.

The Sort Options section of the Asset Sorting Tool screen is shown in the figure below.

5-0-0_sort-options-section-asset-field-sort-type.png
The Sort Options section of the Asset Sorting Tool screen

Sorting by the Asset Sorting Tool is performed by the database. This means that unless a locale is set, the database will treat characters as ASCII encoding. This could cause unexpected sorting issues due to ASCII standards. Make sure a locale is set in your database for the Asset Sorting Tool to work correctly.

Sorting by an Asset Field

To sort the assets by an asset field, select Asset Field in the Sort Type field and click Commit. The fields shown in the figure above will appear.

  • Parent: select which section of the system you want to sort the assets for. For example, if you want to sort the assets under your Site, select the Site asset in the Parent field.
  • Sort Field: select which field to sort the assets on. The fields that are available are the standard asset fields, which include Asset ID, Name, Short Name and Status.
  • Sort Direction: select which direction to sort the assets in. You can select either Ascending or Descending.

Sorting by an Asset Attribute Field

To sort a particular asset type by an attribute field, select Asset Attribute in the Sort Type field and click Commit. The fields shown in the figure below will appear.

5-0-0_sort-options-section-asset-attribute-sort-type.png
The Sort Options section for the Asset Attribute Sort Type

  • Parent: select which section of the system you want to sort the assets for. For example, if you want to sort the assets under your Site, select the Site asset in the Parent field.
  • Asset Type: select which asset type that you want to sort. For example, if you want to sort the MS Word Documents, select MS Word Document from the list provided. Once you have selected an asset type, click Commit. The list of available attribute fields will appear it the Sort Attribute field below.
  • Sort Attribute: by default, if you have not selected an asset type in the field above, the list of attributes will not appear. Once you have selected an asset type, select which attribute field to sort the asset on.
  • Sort Direction: select which direction to sort the assets in. You can select either Ascending or Descending.

Asset Sorting Example

A user needs to sort the assets under a Site by name.

  1. 5-0-0_sorted-site.png
    The sorted Site

    Click on the ToolsTools icon icon in the top right hand corner of the Administration Interface. Once the System Tools screen appears, click on the Asset Sorting Tool.
  2. The following details are changed on the Asset Sorting Tool screen:
    1. Parent: select the Site that will be sorted.
    2. Sort Type: select Asset Attribute. The Asset Type and Sort Attribute sections will appear.
    3. Asset Type: select Standard Page and click Commit. The Attribute list will appear in the Sort Attribute field.
    4. Sort Attribute: select name to sort the assets by their name. 
    5. Sort Direction:Ascending is selected from this field.

Once the necessary fields have been filled out, the Commit button is clicked. Squiz Matrix will then sort the assets under the Site.


Previous Chapter Next Chapter