Looking for object with specific attribute name

Hello, is it possible to find objects in AVEVA IDE that have an attribute with a specific name, by searching for that attribute name?

  • Hi Jakub. Unfortunately there is no native way to do this.

    And you have to be a little bit creative depending on what you are trying to achieve.

    There are some alternatives,

    If you are looking for attributes created on an instance you might solve it by exporting the objects as csv. searching in the csv file. but that's no fun!

    The galaxy database hides some information that could match what you want to do, but the last resort is to use GRAccess to extract configuration data from your galaxy, a scenario could be that you want to look fort a specific text in a script, then GRAccess is your only option.

    But in the later versions of system platform there is a table that might contain the thing you need.
    The table dynamic_attribute seems to contain attribute names and this could be linked to the gobject table to get name of the object.

    I must admit that I'm not fully aware of what the purpose of this table is so i can not guarantee that it contains all atributes in your galaxy.

    But it seems to contain attributes created on both templates and instances. (it will not list derived objects).  

    Try the following Query against your galaxy:

    SELECT
    dynamic_attribute.attribute_name,
    dynamic_attribute.mx_data_type,
    gobject.tag_name as OnjectName
    FROM dynamic_attribute INNER JOIN
    gobject ON dynamic_attribute.gobject_id = gobject.gobject_id
    WHERE (dynamic_attribute.attribute_name LIKE '%waldo%')

     

    Better extraction of configuration-data from a galaxy has always been high up on my Wishlist, but if you get fluent in GRAccess then you can extract and import information as you please.

    I hope it helps.

    Richard