IdentityMap

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

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

Best answer by Danny-Miller

@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

New Participant

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

Put Were condition and you should be fine.

Danny-MillerAccepted solution

Employee

@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

New Participant

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

Employee

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?

Sign up