> ## Documentation Index
> Fetch the complete documentation index at: https://braintrust.dev/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# BTQL Filter Not Applied to All Results: Understanding traces vs spans in project_logs Queries

export const plans_0 = "Starter, Pro, Enterprise"

export const deployments_0 = "Braintrust-hosted, Self-hosted"

export const data_plane_version_0 = undefined

export const use_case_0 = "Use case - BTQL queries on project_logs with span-level filtering"

<Note>
  **Applies to:**

  * Plan - {plans_0}
  * Deployment - {deployments_0}
  * {data_plane_version_0}
  * {use_case_0}
</Note>

## Summary

**Issue:** BTQL query using `traces` returns spans that don't match the filter conditions specified in the `filter` clause.

**Cause:** The `traces` keyword returns all spans within any trace that contains at least one span matching the filter, not just the matching spans.

**Resolution:** Use `spans` instead of `traces` in the `from` clause to filter individual span records.

## Resolution Steps

### If you want to filter individual spans

#### Step 1: Replace `traces` with `spans`

Change the `from` clause to use `spans` instead of `traces`.

```text theme={"theme":{"light":"github-light","dark":"github-dark-dimmed"}}
from: project_logs('<PROJECT_ID>') spans
| filter: created >= day('XXX') AND created < day('XXX')
and span_attributes.name = "XXX"
select: *
limit: 10

```

#### Step 2: Verify results

Results will now only include spans that match all filter conditions.

### If you want complete trace context

#### Keep `traces` in the query - the `traces` keyword is working as designed and returns all spans in traces where at least one span matches your filter.

## Technical Details

### Behavior difference: `traces` vs `spans`

#### `traces`

* Returns complete traces (all spans within a trace)
* Filter conditions select which traces to include
* If any span in a trace matches the filter, all spans in that trace are returned

#### `spans`

* Returns individual span records
* Filter conditions select which spans to include
* Only spans matching all filter conditions are returned