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.

To read in attributes from Lucanet to MS Excel, the formula must be set up as follows:

    
  

The parameter Attribute specifies either the key of an attribute or the name of an object.

AttributeDefinition
KeyKey of the attribute in Lucanet
NameReturns the element name of the specified 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.

ObjectDefinition
Element nameReturns the attribute of the object with the specified element name
lucanet://oid=XXXReturns the attribute of the object using the URL lucanet://oid=XXX