Expand my Community achievements bar.

Join us for Adobe Campaign Community Q&A Coffee Break on Thursday, March 7th at 8am PT with Eric Perrin, Gael Mouello, Chakravarthy Kalva, Bruce Swann and Sandra Hausmann.
SOLVED

Filtering by Event XML

Avatar

Level 4

Hello, i want to filter by the "Event XML" (ctx) field for the events coming, it contains data like <ctx> <age>50</age> <ctx>. I want to create a filter for the age in that field, but the field "ctx" doesn't appear in the filter, I think because it's declared with xml="true".

I can list for it but not filter:

Heku__0-1703663501104.png

Heku__1-1703663526088.png

Any idea of how can I filter for this field?

@Manoj_Kumar_ @ParthaSarathy @Parvesh_Parmar @DavidKangni

Thank you in advance.

 

1 Accepted Solution

Avatar

Correct answer by
Level 4

I've found a way, by parsing the xml with this filter I could get de value so i can filter with the equals to, greater than... operators.

Substring(ToString(data) , Charindex(data , '<var1>') + Length('<var1>') , Charindex(data , '</var1>') - (Charindex(data , '<var1>') + Length('<var1>')))

View solution in original post

1 Reply

Avatar

Correct answer by
Level 4

I've found a way, by parsing the xml with this filter I could get de value so i can filter with the equals to, greater than... operators.

Substring(ToString(data) , Charindex(data , '<var1>') + Length('<var1>') , Charindex(data , '</var1>') - (Charindex(data , '<var1>') + Length('<var1>')))