List topics

Lists the selected topics and their status in a ordered list.

There are a list of elements can be configured in the dashlet:

Height in canvas rows

Defines the height in number of rows given to the dashlet.

The height value will be between 1 and 4 where 4 will occupy 100% of the page.

Width in canvas columns

Sets the width that the item will occupy in the dashboard.

The maximum allowed value is 12 (100% width).

Autorefresh

Allows to make the dashlet more dinamic adding an automatic refresh (in minutes).

List of fields to view in grid

Allows to select specific fields to view. By default the dashlet will show the followin columns; ID, title, status, creator and creation date.

This columns can be modify, separating fields (columns) with ;.

A example to use this field could be: ID_fieldlet,column_name,type,width;

Where:

  • ID_fieldlet - Specify the ID_name of the fieldlet.
  • column_name - Name of the dashlet column.
  • type - Type of field to show. Can be text, number, checkbox or Resource.
  • width - Set the anchor of the column.

In addition, if we use a number type, we can personalize it setting up the number of decimals we want to show, to make it, just add the number of decimas in parenthesis after type.

Types

Text

Specify the value is a text.

Number

We can use other properties for numbers like total. With this property, users can see:

  • sum - Shows sum of all the values contains in the column.
  • max - Shows maximum value of all the values contains in the column.
  • min - Shows minium value of all the values contains in the column.
  • count - Shows number of rows.
  • currency - Indicates that we are showing currency, changes the way to show decimals, using US format (. for decimals) or standard format (, for decimals). This format is predefined by user preferences.
  • symbol - Show type of currency;€, $, etc...

Example: title,Title;created_by, Created By;incoming,My incoming,number(2),,sum,currency,$

In this example, users can see in the dashlet, a table with the following columns:

        Title  | Created by  | My incoming
        --------------------------------
        Title1 | 2016-02-02  | 23,25 $
Checkbox

If we have a checkbox fieldlet in the topic form, we can show an icon instead '1' or '0' to indicate if the checkbox is marked or not. It's a graphic improvement to show better the status of the fiedlet. To use, just configure a column like:

Example: title,Title;created_by, Created By;<check_box_ID>, <Column_name>, checkbox

CI

We can use this type of field if we want to show usernames. By default, Clarive show de ID of the user:

    Title  | Created by  | Owner
    --------------------------------
    Title1 | 2016-02-02  | 1108

. If we want to show the name of the user, just configure the type field to CI:

Example: title,Title;created_by, Created By;owner,Owner, ci

    Title  | Created by  |  Owner
   --------------------------------
    Title1 | 2016-02-02  | admin-1

Maximum number of topics to list

Set the maximun number of topics to show in the table. By default is set to 100.

If you want to show all topics, just set it to 0.

Sort by

Set an order by a determinated field (specified by the ID fieldlet). By default sorts by topic ID.

Sort order

Indicate ASC or DESC order.

Show totals row?

Include a last row showing total if we have a number type in the table.

Select topics in categories

Select one o more categories to show in the grid.

Select topics in statuses

Select one o more status to configure the table.

Exclude selected statuses?

Exclude selected classes in the previous combo and show the rest that no selected.

User assigned to topics

Allow to filter the topics by user assigned or by any user.

Advanced condition JSON/MongoDB

Allows to use a JSON format o MongoDB query to add a condition.

  {"labels":[],"categories":["*id*"],"statuses":[],"priorities":[],"start":0,"limit":25}

Where id is the unique key of the category which can be consulted through the REPL.