Create a data point filter

Create a new data point filter in the Data Points and Filters tab by selecting the desired higher-order data point filter from the sidebar on the left and clicking Add Data Point Filter.

../_images/create-data-point-filter.png

Creating a new data point filter for energy data points

Name

Give the data point filter a meaningful name. This is not only displayed in the sidebar on the left, but also in the data point gallery on some widgets, especially the Chart and Schematic widgets.

Type

Here, select whether you want to filter data points according to their Data Type, System Name or Protocol. For advanced filter settings, select the option Advanced.

Filter Criteria

Define the value to be filtered for here. When filtering by Data Type or Protocol, you can select the desired filter value from the dropdown. For all other filter criteria, enter the value directly in the text field.

You can configure multiple filter criteria per data point filter to extend the filtering. To do so, click Add above to add another filter criterion. The data point filter filters for all data points that match at least one of the filter criteria.

Note

Note that data point filters are connected to each other in a hierarchical arrangement. Data point filters positioned under another data point filter only filter the data points which result from their predecessor. The deeper the tree structure, the fewer data points you will usually find at the lower levels.

Import and export data point filters

If you want to quickly create several data point filters at once, or if you want to copy data point filters from one client or system to another, you can easily export and import them.

  1. On the Data Points and Filters tab, select the data point filter you want to export in the sidebar on the left hand side.

  2. Click on More Export in the toolbar above the sidebar and download the exported file.

The export will contain the selected data point filter and all its child filters.

You can now import the exported file on another client or even on another system. Before you do, you can edit the file in Microsoft Excel to easily add or edit data point filters.

The Excel file contains the following columns:

Column A

The level of the data point filter. The first data point filter in the export file always has level 0. Child filters have an incrementing level of 1, 2, etc., depending on how deep they are in the hierarchy. Rows with the same number are data point filters on the same level.

Column B

Name of the data point filter.

Column C

The property that the data point filter is based on. Possible values are:

Value

Description

locationId

ID of the device. When you’re on the Device Configuration or Data Points and Filters view, this is the second number from the left that’s displayed in the address bar of your browser.

TYPE

The type of the bus protocol. See TYPE reference below.

systemName

System name fragment. You can use the wildcards ? for single characters and * for multiple characters.

alcedoType

Data type of the data point. See Data type reference below.

For advanced properties, please see the Advanced attributes reference below.

Column D

Column D contains the filter value.

If you want to filter for multiple values, provide the additional values in the subsequent columns (E, F, etc.).

If multiple values are provided, the filter will contain all data points that match any of those values.

To import the data point filters, select an existing data point filter in the sidebar on the left under which you want the imported filters to be inserted. Then click on More Import in the toolbar above and select the exported file.

The data point filters will be inserted under the selected data point filter.

Reference of filter values

TYPE

The type of the bus protocol is represented by a number from the following table.

Value

Protocol

0

BACnet

1

Modbus TCP

2

M-Bus

4

TABS

5

Modem

6

Modbus RTU

7

OPC UA

100

Custom

102

OZW

103

Email alarm

104

IoT

105

Weather data

106

WAGO MQTT BC

107

WAGO MQTT EDM

Data type

The property alcedoType represents the data type of the data point. The following values are supported:

Value

Data type

1

Acceleration

2

Angle

3

Angular momentum

4

Area

5

Boolean

6

Capacitance

7

Compressibility

8

Conductance

9

Conductivity

10

Cooling rate

11

Currency

12

Current

13

Current density

14

Data transfer speed

15

Data volume

16

Density

17

Distance

18

Double

19

Electric field strength

20

Energy

21

Entropy

22

Float

23

Force

24

Frequency

25

Illuminance

26

Inductance

27

Insolation

28

Integer

30

Long

34

Magnetic field strength

35

Magnetic flux

36

Magnetic flux density

37

Magnetic moment

38

Mass

39

Mass flow

40

Momentum

41

None

42

Null

43

Ratio

44

Power

45

Power level

46

Pressure

47

Relative humidity

48

Resistance

49

Resistivity

50

Specific energy

51

Specific heat

52

String

53

Surface tension

54

Temperature

55

Temperature departure

56

Temperature difference

57

Thermal conductivity

58

Thermal transmittance

59

Thomson coefficient

60

Time

61

Timespan

62

Unsigned integer

63

Unsigned long

64

Velocity

65

Voltage

66

Volume

67

Volume current

68

Absolute humidity

69

Alarm analysis

70

Decibel

71

Voltage level

72

Radiation activity

73

Radiation absorbed dose

74

Radiation equivalent dose

75

Radiation equivalent dose rate

76

A weighting

77

Turbidity

78

Acidity

79

Area density

80

Heating rate

81

Electric charge

82

Auxiliary energy 1

83

Auxiliary energy 2

84

Viscosity

86

Energy density

87

Emission coefficient

88

Byte

Advanced attributes

Attribute

Description

Type

activeText

The active text of the BACnet object

String

affectsManualMode

Whether the data point is taken into account for the calculation of the manual mode.

Boolean¹

alarmEnabled

Whether an alarm is enabled for the data point.

Boolean¹

alarmState

The current alarm state of the data point.

Integer

alarmSuppression

Whether alarm suppression is enabled for the data point.

Boolean¹

bacnetDevice

The ID of the BACnet devices.

Integer

bacnetInstance

The instance number of the BACnet object.

Integer

bacnetObject

The BACnet object type.

Integer

customUnit

The custom unit of the data point.

String

decimals

The number of decimals of the data point.

Integer

displayDecimals

The number of displayed decimals of the data point.

Integer

displayUnit

The display unit of the data point.

Integer

exposedToIoTApp

Whether the data point is visible in the Avelon IoT <avelon-iot> app.

Boolean¹

exposedToMetersApp

Whether the data point is visible in the Avelon Meters <avelon-meters-ios> app.

Boolean¹

externalErpId

The external ERP ID of the data point.

String

guid

The GUID of the data point.

String

i18n

The label of the data point. Contains values for all available languages.

String

id

The ID of the data point.

Integer

inactiveText

The inactive text of the BACnet object.

String

ioInstance

The instance number of the I/O data point.

Integer

ioObjectType

The object type of the I/O data point.

Integer

manualMode

The manual mode of the data point.

Integer

mbusAddress

The M-Bus address of the data point.

Integer

mbusInstance

The instance number of the M-Bus data point.

Integer

mbusSecondaryAddress

The secondary address of the M-Bus data point.

Integer

mediumType

The medium type of the data point.

Integer

modbusAddress

The Modbus address of the data point.

Integer

modbusBitIndex

The bit index of the Modbus data point.

Integer

modbusIP

The IP address of the Modbus data point.

Integer

modbusObjectType

The object type of the Modbus data point.

Integer

modbusPort

The port of the Modbus data point.

Integer

modbusSerial

The serial interface of the Modbus data point.

String

modbusSlaveId

The slave ID of the Modbus data point.

Integer

modemInstance

The instance number of the modem data point.

Integer

priorityArrayAvailable

Whether the BACnet priority array is available for the data point.

Boolean¹

recordingType

The recording type of the data point.

Integer

tabsInstance

The instance number of the TABS data point.

Integer

tabsType

The type of the TABS data point.

Integer

tagId

The ID of the data point tag assigned to this data point.

Integer

unit

The unit of the data point.

Integer

visible

Whether the data point is visible in the data point sidebar (e.g. on widgets).

Boolean¹

wagoCollectionId

The ID of the WAGO collection.

Integer

wagoCollectionName

The name of the WAGO collection.

String

writable

Whether the data point is writable.

Boolean¹

¹ For boolean attributes, use 0 for false and 1 for true.