Querying Attributes
Last updated on 2025-04-29
Overview
You can use querying of attributes from Lucanet, among other things, to export element names in Lucanet via the OID of elements. The OID of an element is always unique while its name does not have to be unique. If an element exists with the same name at several points in Lucanet, a query leads to an error message, while a query with the OID returns the correct result.
This article contains the following sections:
Structure of the LUCANET Formulas
To read in attributes from Lucanet to MS Excel, the formula must be set up as follows:
=LN.ATTRIBUTE("Attribute","Object")
Attribute
The parameter Attribute specifies either the key of an attribute or the name of an object.
Attribute
Definition
Key
Key of the attribute in Lucanet
Name
Returns the element name of the specified object
Object
The Object parameter specifies either the element name or the OID of the object whose attribute is to be read in to MS Excel.
Object
Definition
Element name
Returns the attribute of the object with the specified element name
lucanet://oid=XXX
Returns the attribute of the object using the URL lucanet://oid=XXX