FILTER.AREA - j5 - 30 - Administration & Configuration - Hexagon

j5 IndustraForm Designer Reference

Language
English
Product
j5
Search by Category
Administration & Configuration
j5 Version
30

Applies an area filter (filtering the $Form.Area column). It defaults to the context area filter if no area is supplied.

= FILTER.AREA(table[, area, ...])

  • table - The table to filter, or FilterInput if this is being used as a context filter.

  • area

    • An area identifier or label.

    • When there are multiple area labels / IDs, they are treated as a search path. For example, when there are areas with the same name, you'll need to define the specific area you want by defining its path.

    • The following separators can be used to indicate a relative path to the form location:

      • "." - Indicates the current area level of the form instance.

      • ".." - Indicates one level up from the current form instance. For example, if the form instance is in Area_A > Area_AA, you can access the sibling area by having a path like ["..", "Area_AB"].

      • "/" - Indicates the area level of the form design (where the form was created in the IndustraForm Designer). This is the highest area level the form instance can access.

      Refer to Related area filters for more information.