extract data

[marusla]

i have  an xml log that have a some line that starts with error. i want a extract that data, i dont know how to do it? i think maybe extract each in diferent columns but if some log have 2 and other 5 error line?

[dannemca]

I believe the best option would be to parse the XML and then extracting the data you need for filtering.

https://docs.dynatrace.com/docs/discover-dynatrace/platform/grail/dynatrace-pattern-language/dpl-xml

Could you provide some dummy example of the data so we can provide you some DQL example?

[marusla]

this is the data, i want to capture all the data that start with Error.Mensaje.Web

en System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage()
en System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke()
en Error.Mensaje.Web.InformacionService.IInformacionService.Consulta(String mid)
en Error.Mensaje.Web.Code.General.Comercio.compra en C:\Github\Code\General\ComercioCode.cs:línea 2561
en Error.Mensaje.Web.Controllers.General.InformacionController.ConsultarInformacionComercio(String mid) en Github\Code\General\ComercioCode.cs:línea 125

[marusla]

sorry its a  stack trace records

[dannemca]

Could you paste the full content from one line of your current dql query? This does not look like a XML.

We will need to take a look at the full content in order to suggest a DQL you can try.