STACK.EXPANDTAGVALUERANGE

Introduction

The STACK.EXPANDTAGVALUERANGE function returns sorted names of tag values used within a given tag, within a given project, matching the search criterion.

Syntax

CODE

=STACK.EXPANDTAGVALUERANGE(ConnectionName, Project, Tag, Filter)

Parameters

Parameter	Required/Optional	Description
`ConnectionName`	Required	The name of the connection, as specified in the Connection Manager
`Project`	Required	Project name. Use the STACK.EXPANDPROJECTRANGE function to retrieve the list of STACK projects.
`Tag`	Required	Tag name. Use the STACK.EXPANDTAGRANGE function to retrieve the list of STACK tags.
`Filter`	Optional	A search expression for filtering tag values, uses Velixo filtering techniques. If not specified, returns all tag values.

Example

=STACK.EXPANDTAGVALUERANGE("Stack", "Second Project", A1)

Description: Returns all tag values used in the tag contained in cell A1 in the Second Project project for the connection named Stack.