Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Note: You must have the Data Dictionary Module Right selected, under Quick Links in the Data Center.
...
To view the properties of an element, click View in its row.
Adding and Editing Custom Elements
Note: You must have the Edit Data Dictionary Elements Module Right selected, under Actions in the Data Center.
You can create custom elements to be used in Task & Alert Rules and the Report Designer.
- To add a new element, select the table to which you want to add and then click .
- To edit an existing custom element, select its table and then click Edit in its row.
...
- Enter an Element Name.
- Select a Data Type.
- Enter an Expression to define the value:
- Click in the field; the formula editor appears.
Anchor formula formula
Note: The formula editor is case sensitive. For example, VoyageStatus=="commenced" is different from VoyageStatus=="Commenced" - Create a formula for the value, following the example formula. You can include:
- Other custom columns
- Selections from the Column, Color, and Font lists at the bottom of the formula box
The Column list includes the following functions, which must be in UPPERCASE:- ABS(FieldID)
- AVG(FieldID)
- COALESCE(FieldID1, FieldID2, ...)
- CONCAT(FieldID)
- CONTAINS(FieldID, SearchString)
- COUNT(FieldID)
- COUNTDISTINCT(FieldID)
- COUNTIF(FieldID, TestExpr)
- DATE(Year, Month, Day)
- DATERANGE(DateFieldID1, DateFieldID2)
- DATETIME(Year, Month, Day, Hours, Minutes, Seconds)
- DATETIME RANGE(DateFieldID1, DateFieldID2)
- DAY(DateFieldID)
- DISPLAYVALUE(EnumLiteral)
- ENDSWITH(FieldID, SearchString)
- HOUR(DateFieldID)
- IF(Condition, true, false)
- INDEX(FieldID, Num)
- INLIST(Value, Target1, Target2, ...)
- JOIN(“,”, FieldID)
- JOINDISTINCT(",", FieldID)
- LEN(FieldID)
- MAX(FieldID)
- MIN(FieldID)
- MINUTE(DateFieldID)
- MONTH(DateFieldID)
- NOW()
- NOWGMT()
- ROWOFFSET(n, ORDERBY(FieldA, FieldB)).FieldID
- SECOND(DateFieldID)
- SPLIT(FieldID, Delimiter, Index)
- SQRT(FieldID)
- STARTSWITH(FieldID, SearchString)
- SUBSTRING(FieldID, StartIndex, length(optional))
- SUM(FieldID)
- TIME(Hours (0-23), Minutes (0-59), Seconds (optional, 0-59), Milliseconds (optional, 0-999)))
- TODAY()
- TODAYGMT()
- TOINT(FieldID)
- TOLOCALESTRING(FieldID)
- TOSTRING(FieldID)
- YEAR(DateFieldID)
- Click in the field; the formula editor appears.
- Click Save.
List Functions
The Data Dictionary List is a standard IMOS list, so you can sort it, filter it, do a Quick Search, and create custom Views for it.