IdentityMap

[askApr2014]

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

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

[Anil_Umachigi]

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? 

[Danny-Miller · Accepted solution]

@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

[KunalJa2]

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

[navink386520]

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

Put Were condition and you should be fine.