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
Blackbaud CRM / Attributes
Organization Name (Please enter full organization name) WPAOG
Reported Version 4.0
  • Attach files
  • Admin
    Nicola Cameron commented
    November 25, 2020 12:52

    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

    Attachments Open full size
  • Lindsay Gunnarsen commented
    November 24, 2020 13:53

    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.

    Attachments Open full size
  • Admin
    Nicola Cameron commented
    November 24, 2020 09:51

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

    Attachments Open full size

Related ideas