LVATTRIBUTE Function

Using the LVATTRIBUTE function, you can query Longview attribute data. You can use the LVATTRIBUTE function in the following ways:

• Type the function syntax into a worksheet cell.
• Complete the function parameters in the Function Arguments dialog.

LVATTRIBUTE syntax

In the worksheet cell, type:

=LVATTRIBUTE("Attribute_class", "Attribute_name", ["object"])

where:

• Attribute_class is the attribute class. Specify one of the following values:

  Value	Description
  SYSTEM	Describes the entire Longview system at the highest level. Attributes of this class specify system-wide characteristics. There is only one object in the SYSTEM attribute class — the Longview application itself.
  USER	Describes the attributes of a particular user. Each user is an object in the USER attribute class.
  SYMBOL	Describes the characteristics of individual symbols. Each symbol is an object in the SYMBOL attribute class.

• Attribute_name is the name of the attribute. To find a list of attribute names in your data server repository, see Querying attribute information.
• object is the object whose attribute value you want to query. The object is dependent on the value specified for Attribute_class.
  • If you specified SYSTEM for Attribute_class, specify DBDEFAULT for object, or leave the parameter blank.
  • If you specified USER for Attribute_class, specify a username for object.
  • If you specified SYMBOL for Attribute_class, specify a symbol name for object.

For example:

=LVATTRIBUTE("SYMBOL","ZGPNativeCurrency","Toronto")

Querying attribute data using the Function Arguments dialog

You can query attribute data by completing the function parameters in the Function Arguments dialog.

To query attribute data:

1. Click the Longview tab.
2. In the Formulas group, click Longview Functions, and click LVATTRIBUTE. The Function Arguments dialog opens.
3. Complete the following fields:

   Field	Description
   Attribute_class	Specify the attribute class.
   Attribute_name	Specify the name of the attribute.
   <object>	Optionally, specify the object whose attribute value you want to query.

4. Click OK. The query data appears in the worksheet.