Lists

Introduction to Lists

A List is a set of data rows with a set of capabilities. Comflow Lists have a set of generic features, which can be used when working in Comflow. The featurs are descibed in this document.

Filter

On top of the table you find an ad-hoc filter function (if it is enbled for the table). It is a row on top of the data and all fields that are input can be used to filter the table. The filter field acts for the actual column and filters the list for rows that meet the filter field's value. You activate the filter by pressing enter or the Filter button.

By entering a filter string into the filter field, like 'comflow', you will filter out alla rows that have the value 'comflow' in that field. If the field is a numeric field, you can as an exampel filter out all rows that have the value '2'. For date or time columns you filter out by setting a date or time string. The date or time picker helps you to set the correct format of that string.

You can filter on multiple columns at the same time. So you can in one column filter on 'comflow' and in another '2'. The result will be a list with were all rows contains 'comflow' in the first column and '2' in the second.

Blank value

You filter out blank value by ''.

Combo boxes

When the column is defined to have a set of valid values, it can be viewed as a combobox of that list of valid values. By selecting one value in the combo-list in the filter field, that value will be used as

Plus and Minus (+ -)

If you want to filter out values that are greater or less than a specific value, you can add plus ('+') behind to filter greater values or minus ('-') before to filter less. This works for alfanumeric, integer, decimal, date and time values.

Wildcard %

For character fields you can use "%" as a wildcard. That means that you can use the string "com%" to find rows in the list that starts with "com" and is followed by any characters, like "comflow" or "comfortable". You can also use the wild card in the beginning of the string, like "%flow" and thereby filter our "comflow" or "workflow".

Automatic end wildcard

Comflow can be configured to automatically add a wildcard to a string column. That means that if you write 'com' in the filter field, the column is filtered by 'com%'.

Not (!)

You can also filter out not values with "!". By using !'' you get non-blank values.

Sorting

All lista have a default sorting. You can though change the sorting of the rows in the list by clicking on the column header. The first time it will sort descending and the second time ascending. Note that no new data is retrieved from the data source when doing this sorting.

Row (Left) click

By left clicking on a row you genereally change view to a detailed view of the row data. There might be exceptions to this for certain applications.

Row Right click

By right clicking on a row you generally get an option menu for the current row data. There might be exception to this for certain applications.

Paging

At the bottom left of the List, there are a set of buttons to control paging of the list. All paging buttons reset the sorting to defualt sorting.

• Refresh - Refreshes the list by reading the data source and applying the current filter
• First - Takes you to the initial data set from the data source with current filter
• Previoius - Takes you to the previous data set from the data source with current filter
• Next - Takes you to the next data set from the data source with current filter
• Last - Takes you to the last data set from the data source with current filter
• All - Shows all rows with the current filter. If larger than the list size, it will show a scrollbar to the right.

Scroll

If the number of rows are more than the list frame are set to show, you get a scoll-bar to the right of the list. By moving that scroll, you can see all rows in the list.

Excel export and import

Changing column width