Skip to main content
askApr2014
New Member
August 17, 2022
Solved

IdentityMap

my identyMap contains something like this - [ECID -> "{(00217892182081596154117317023817799037,f)}"]

what i want to see is 00217892182081596154117317023817799037 , could someone help how to extract

    Danny-Miller
    Danny-MillerAccepted solution
    Adobe Employee
    August 17, 2022

    @askapr2014 If you are referring to how should your SQL look in Query Service, this is how you get the first element in the array:

    SELECT identitymap['ECID '][0].ID FROM dataset

    View in thread

    7 replies

    Anil_Umachigi
    Adobe Employee
    Anil_UmachigiAdobe Employee
    Adobe Employee
    August 17, 2022

    Where are you seeing this? i.e where do you want to extract it from? Could you elaborate on usecase. 

    Is it the dataset which contains web events? 

     

    Translate
    Danny-Miller
    Adobe Employee
    Danny-MillerAdobe EmployeeAccepted solution
    Adobe Employee
    August 17, 2022

    @askapr2014 If you are referring to how should your SQL look in Query Service, this is how you get the first element in the array:

    SELECT identitymap['ECID '][0].ID FROM dataset

    Translate
      KunalJa2
      May 28, 2024

      Thank you for your reply, do you know how to fetch identitymap emails?

       

      Translate
      navin_kumar0601
      Level 4
      August 19, 2022

      @askapr2014  seems your query has * , thus result is ("values inside by ,"). 

      Put Were condition and you should be fine.

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...