This is an archived page of the former Sigmah website which is no longer maintained. Come on the new website!
Ceci est une page archivée de l'ancien site Sigmah qui n'est plus maintenu. Rendez-vous sur le nouveau site !
 

2.1.5. Personalising tables

Submitted by pbrunet on Mon, 06/06/2011 - 11:25

Column content can be reorganised in all Sigmah tables. To do this, move the cursor over the right hand side of the column title. A triangle pointing downwards will appear. Click on the triangle. This opens a drop-down list which includes the three following options:

When pages are opened, they are sorted in ascending order by default.

N.B.: A fourth option ("Filter") is available for the following columns (Code, Title, Active phase and Organisational Unit). See below.

 

Sort Ascending and Sort Descending

“Sort Ascending” and “Sort Descending” work for letters but also for numbers (0 to infinity):
 

 

How to use Columns

Place your cursor on Columns and another drop-down list will appear with options to be selected or deselected by ticking or unticking the boxes. These are the column headings available for the table that is being used:
-    a heading preceded by a box which is ticked means that the column is displayed,
-    a heading preceded by a box which is not ticked means that the column is hidden.

 

You can tick or untick a heading by simply clicking on the corresponding box:

 

It is also possible to increase or reduce the width of columns by placing the cursor over the right hand edge of each column heading. A symbol appears which consists of two arrows (one pointing left and the other pointing right) separated by two vertical lines. You can increase or reduce the width of the column by dragging the edge to the left or right.  

 

How to use Filters

 

For Code, Title, Active phase and Organisational Unit columns

For these 4 columns, when you place the cursor over the "Filters" title, a new field appears to be filled in with the letters/words of your choice (by default, the words 'enter text" appear in this field, and disappear when you place your cursor in the field).

The Filter function will automatically apply.

 

For the Budget columns (spent, recieved and planned)

By placing the cursor over "Filters", new numerical fields appear to be filled in preceded by mathematical symbols

  • the " < " symbol means you should enter a maximum amount
  • the " > " symbol means you should enter a minimum amount
  • the " = " symbol menas you should enter the exact amount you are looking for

 

For the “Time” column

This column has a filter for closed projects. The box is ticked by default, which excludes all closed projects from the dashboard. By placing the cursor over this Filter you will see a new drop-down list which gives you the following choice:

  • Exclude all closed projects
  • Include the last 6 months: to include projects closed within the last 6 months
  • Include the last 12 months: to include projects closed within the last 12 months
  • Choose a time limit: to include projects closed after the chosen time limit

For the “Category” column

Place your cursor over "Filters" and a new drop-down list opens with tick boxes. This list includes all the category labels available in your parameterisation of Sigmah in the form: label title (name of label category). 

These tickboxes allow you to filter projects as follows:

  • a label preceded by ticked box means that only projects with this value of category will be visible in the table,
  • a label preceded by an unticked box means that this value of category will not be used to  filter projects in the table.

You can tick or untick a heading by simply clicking on the corresponding box:

In order to unclick all the selected labels at once, untick the box located at the left of “Filters” field.