Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

IdentityMap

Avatar

Level 1

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

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

1 Accepted Solution

Avatar

Correct answer by
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

View solution in original post

3 Replies

Avatar

Level 4

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? 

 

Avatar

Correct answer by
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

Avatar

Level 3

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

Put Were condition and you should be fine.