Page Comparison

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.

...

1. Enter an Element Name.
2. Select a Data Type.
3. Enter an Expression to define the value:
   1. 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"
   2. 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)
4. 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.