Filtering by Event XML

[Heku_]

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:

Any idea of how can I filter for this field?

@Manoj_Kumar_ @ParthaSarathy @Parvesh_Parmar @DavidKangni

Thank you in advance.

[Heku_ · Accepted solution]

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>')))