DQL Query joining Logs on Spans not Returning Results

GPtheSQL — Tue, 15 Apr 2025 06:48:26 GMT

I am trying to find all logs for traces with a certain name using DQL. I discovered in notebooks that spans has the name I am looking for in a column called endpoint.name as such, I believed the below query would work:

fetch logs |join [ fetch spans |filter contains(endpoint.name, "INSERT_TRACE_NAME_HERE") ], on: { left[trace_id] == right[trace.id] }

Unfortunately, this query returns no results. I confirmed the subquery returns results for my desired endpoint name and the super query returns the logs I am looking for if I filter for one of the trace id's returned in the subquery. Anyone know what I'm doing wrong here? Please let me know if you need any more information.

Re: DQL Query joining Logs on Spans not Returning Results

yanezza — Thu, 17 Apr 2025 10:49:50 GMT

Hi!
the trace.id is a UID and the trace_id is a string, you need to convert it (or the trace_id to UID or the trace.id to String)

topic DQL Query joining Logs on Spans not Returning Results in DQL

DQL Query joining Logs on Spans not Returning Results

Re: DQL Query joining Logs on Spans not Returning Results