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

# Query basics

> Run small SQL queries against the reporting schema.

Qualify each view with `reporting`, as shown below.

## List shipments

```sql theme={null}
SELECT shipment_id, business_key, transport_mode,
       origin_code, destination_code, total_revenue
FROM reporting.shipments
ORDER BY business_key
LIMIT 25;
```

One row is one current shipment.

## List one-off quotes

```sql theme={null}
SELECT quote_id, business_key, is_approved,
       origin_code, destination_code, total_revenue
FROM reporting.one_off_quotes
ORDER BY business_key
LIMIT 25;
```

One row is one current one-off quote.

## Find a scalar XML field

Use `source_fields` when a business view does not contain the field you need.

```sql theme={null}
SELECT semantic_path, raw_value, owners
FROM reporting.source_fields
WHERE semantic_path ILIKE '%/RequestedField%'
LIMIT 25;
```

Use `raw_value` as source evidence. The typed columns, such as `numeric_value` and
`timestamp_value`, are available when Analytics can infer the value type.