---
title: Example Queries
sidebar:
  order: 52
---
See below for a selection of example queries across different entity types.

Note: using the `msgpaths` syntax requires log files to have been ingested by a corresponding action. You can find ingestion actions for common log formats in the [Action Hub](https://app.roboto.ai/hub) (e.g. ROS, PX4 etc.). If you're using a custom log file format, [get in touch](mailto:support@roboto.ai) and we can help you with ingestion.

## Datasets

Find the 5 most recently created datasets

```
* SORT BY created DESC LIMIT 5
```

Find datasets from May 2024 collected on vehicle `sn_1234`

```
created >= "2024-05-01" AND
created < "2024-05-31" AND
metadata.vehicle_id = "sn_1234"
```

Find datasets containing a large ROS bag (`>20GB`) and a video with a filename like `takeoff.mp4`

```
(files[0].size > 2000000000 AND files[0].path CONTAINS ".bag") AND
files[1].path CONTAINS "takeoff.mp4"
```

Find datasets tagged with `Night` where any file had a topic named `cpuload` with average load `>80%`

```
topics[0].msgpaths[cpuload.load].mean > 0.8 AND
tags CONTAINS "Night"
```

## Files

Find the 10 largest files I have stored in Roboto

```
* SORT BY size DESC LIMIT 10
```

Find `.ulg` files which belong to a dataset tagged with `Rainy`

```
dataset.tags CONTAINS "Rainy" AND
path CONTAINS ".ulg"
```

Find `.ulg` files where the mean CPU load was low and the max altitude is high

```
topics[0].msgpaths[vehicle_air_data.baro_alt_meter].max > 1000 AND
topics[1].msgpaths[cpuload.load].mean < 0.4
```

Find files recorded on software release `2.4.0`. Metadata keys are addressed with a dotted path — `metadata["release"]` is not valid RoboQL. Note that files carry their own metadata, separate from their dataset's; use `dataset.metadata.<key>` to filter on the containing dataset's instead.

```
metadata.release = "2.4.0"
```

## Topics

Find vehicle angular velocity topics from between 11AM and 12PM PDT on April 28, 2024

```
name = "vehicle_angular_velocity" AND
created >= "2024-04-28T11:00-07:00" AND
created < "2024-04-28T12:00-07:00"
```

Find noisy topics (10k+ messages) in small files (`<10MB`)

```
file.size < 10000000 AND
message_count > 10000
```

Find battery status topics where the battery was both connected and disconnected

```
msgpaths[battery_status.connected].false_count > 0 AND
msgpaths[battery_status.connected].true_count > 0
```

Find camera topics recorded on software version `3.14`

```
dataset.metadata.softwareVersion = "3.14" AND
name CONTAINS "camera"
```

## Message Paths

Find message paths with data type `uint8[]` created after September 25, 2024

```
data_type = "uint8[]" AND created > "2024-09-25"
```

Find message paths from topics called `/camera/front/image` in files tagged with `crash`

```
topic.name = "/camera/front/image" AND file.tags CONTAINS "crash"
```

## Events

Find events with the word `spike` that started after September 09, 2024 4\:38 PM PDT

```
name CONTAINS "spike" AND start_time > "2024-09-09T16:38:26.941-07:00"
```

Find events called `Lane Change` with a tag `London`

```
name = "Lane Change" AND tags CONTAINS "London"
```