Make it easier to find where Attribute Categories are in use in query, export definitions, etc.

We cannot rename attributes in use. We cannot find where the attributes are in use. We cannot inactivate attribute categories. Once in place, we need more flexibility to change them.

  • Lindsay Gunnarsen
  • Nov 23 2020
  • Reviewed: Voting Open
Organization Name (Please enter full organization name) WPAOG
Reported Version 4.0
  • Attach files
  • Admin
    Nicola Cameron commented
    25 Nov, 2020 12:52pm

    Hi Lindsay, You can extract the GUIDs for all of your attributes using the following SQL query in SSMS:

    SELECT *

    FROM dbo.ATTRIBUTECATEGORY

    The ID column holds the GUID you can use.

    Thanks

  • Lindsay Gunnarsen commented
    24 Nov, 2020 01:53pm

    Thanks, Nicola, but that solution works if you have the actual attribute GUID, which I cannot find on the front end either. There is not an 'attribute' type query option and the attribute table does not contain that GUID when exported from the list.

  • Admin
    Nicola Cameron commented
    24 Nov, 2020 09:51am

    We have a Knowledgebase Solution that may assist with this. Please see KB Article 117613