Question

Photo of Dillan Cagnetta

0

Defined Types in Database storage unusable

1

Hi

I noticed the values of the Defined Types are unusable i.e. stored as some hashed value

This makes returning these values useless in queries

thanks

  • Photo of David Leigh

    0

    Dillan,

    If you are creating a Data View, which entity type (Applies To) and field are you trying to access?
    Otherwise, how are you trying to access and display these values?

     

    • Dillan Cagnetta

      Dillan Cagnetta

      Hi David. not a Data View but a SQL code. e.g. Defined Type "Source of Visit" attributes value for "Website" is stored as 4a350000-0bcc-4fab-968b-b0c9fc6e76ff in the Database.


      so my question how do i access the human readable value?

      • David Leigh

        David Leigh

        You can find the Description of the Defined Value matching the stored Guid value as follows:
        SELECT [Value], [Description]
        FROM [DefinedValue]
        WHERE [Guid] = '4a350000-0bcc-4fab-968b-b0c9fc6e76ff'