Available in v30 update 11 and later.
Applies an area filter for multiple areas (filtering the $Form.Area column). It defaults to the context area filter if no areas are supplied.
= FILTER.AREAS(table[, area_paths_table])
-
table - The table to filter, or FilterInput if this is being used as a context filter.
-
area_paths_table
-
The area identifiers or labels. The areas are treated as a search path. It is defined as a table {...} where each area identifier is a column separated by a comma "," and each row is an area path separated by a semicolon ";".
-
A maximum of 10 areas paths can be used in this filter.
-
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.
-
-
Example
=FILTER.AREAS(IMPORT.LOG("general_logbook", "start_time,logtype.DisplayValue,message,status,priority,$Form.Area"), {"Area_A", "Area_AA"; "Area_B"})
This filters for Area_A > Area_AA and Area_B.
For the area_paths_table, any IMPORT function can be used that will return the data in this format.