DQL Query joining Logs on Spans not Returning Results

[GPtheSQL]

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.

[yanezza · Accepted solution]

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)