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

# Filters and Columns

> Start an export of tasks or data source records, choose what it covers and which columns the file holds.

Click **New** on the [Export](https://docsy3.mile.app/pages/export-import/export.md) page. The **New export** dialog asks first what to export, then shows only the options that apply.

> [!NOTE]
>
> Required permission:
>
> * View Data Export
> * Export task, to export tasks
> * Export Data Source, to export data source records
> * View custom export template, to pick a saved column set

![Choose what to export](https://mintcdn.com/mile-app/PeReiScL9I1UXMJO/images/v4/export-import/export-new.png?fit=max\&auto=format\&n=PeReiScL9I1UXMJO\&q=85\&s=ced7ed7a54427666cb05dd5360c2ab69)

Under **Choose what to export**, pick **Tasks** or **Data source**.

## Export tasks

![Task export options](https://mintcdn.com/mile-app/PeReiScL9I1UXMJO/images/v4/export-import/export-new-task.png?fit=max\&auto=format\&n=PeReiScL9I1UXMJO\&q=85\&s=0728a752d9c2c82f56218204430b1805)

1. **Tasks**: what is exported.
2. **Hub**: the hubs to export from. Pick at least one, or use **Select all hubs**. The rest of the dialog appears once a hub is chosen.
3. **Date range**: tasks within this range are exported. Both a start and an end date are required; it starts at the last 30 days.
4. **Columns**: how the columns are chosen:
   * **Every column**: every column of the chosen flows, narrowed by the switches under **Detail data columns**.
   * **A saved column set**: the columns, and their order, from a [column set](https://docsy3.mile.app/pages/export-import/column-sets.md).
5. **Manage column sets** (pencil): opens the [Column sets](https://docsy3.mile.app/pages/export-import/column-sets.md) dialog without leaving the export.
6. **Flow**: the flows to export, or **Select all flows**. Besides your flows, the list offers **Trip Activity**.
7. **Status**: the task statuses to include: **Unassigned**, **Ongoing** and **Done**.
8. **Detail data columns**: each switch adds or removes one group of columns from the file. Keep at least one on. Your choice is remembered for the next export.
   * **Task information**: title, content, label, flow, status, assignee, who created, assigned, updated and finished the task, and when.
   * **Route**: ETA, ETD, planned route order, waiting time, distance, distance from hub, split details, assigned vehicle and visit group.
   * **Media**: photo, signature, video and other file columns.
   * **Field**: the answers your field team entered in the flow's components.
   * **Other**: task id, hub, flow id, coordinates, durations, geo lock settings, reference id and other system columns.

Times in the file use the Jakarta time zone (WIB/GMT+7). Click **Start export**. The export appears at the top of the list with the status **Exporting**, and its file follows when it is **Ready**.

### Trip Activity

**Trip Activity** is offered as a source next to your flows. Its columns are **Username**, **Start Trip**, **Start Trip Coordinate**, **End Trip**, **End Trip Coordinate**, **Total Distance (km)** and **Total Duration (minutes)**, and they appear on their own sheet in the file.

> [!NOTE]
>
> * **Select all flows** also selects Trip Activity.
> * If you choose specific flows without Trip Activity, only those flows are exported.

### Export with a saved column set

Choose **A saved column set** under **Columns**, then pick the set.

![Export with a saved column set](https://mintcdn.com/mile-app/PeReiScL9I1UXMJO/images/v4/export-import/export-saved-set.png?fit=max\&auto=format\&n=PeReiScL9I1UXMJO\&q=85\&s=e499260ef1835568d145be2a6a85db2b)

The flows and columns come from the set, so the **Flow** picker and the **Detail data columns** switches are hidden. Choose the **Status** and click **Start export**. In the list, the export shows as **Custom:** followed by the set's name.

If you have no set yet, click **Add a column set** to build one. See [Column sets](https://docsy3.mile.app/pages/export-import/column-sets.md).

## Export data source records

Pick **Data source** under **Choose what to export**.

![Data source export options](https://mintcdn.com/mile-app/PeReiScL9I1UXMJO/images/v4/export-import/export-data-source.png?fit=max\&auto=format\&n=PeReiScL9I1UXMJO\&q=85\&s=9d6a54547dd203633d8d37357bb9ce9d)

1. **Data type**: the data type to export. Every column of this data type is exported. Types marked **All hubs** have **Scope Data by Hub** off, so their records are shared by every hub.
2. **Hub**: the hubs whose records are exported. It only appears for a data type with **Scope Data by Hub** on.

In the file, a **Relation** column holds the Title of the linked record, or the Titles separated by commas when it links many. A **Multi option** column holds the chosen options separated by commas. This is the same format [Import](https://docsy3.mile.app/pages/export-import/import.md) reads.

Click **Start export**.

> [!TIP]
>
> To export just the tasks on screen, with the filters you already set, use **Export** on the [Task](https://docsy3.mile.app/pages/activities/task/introduction.md) page.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.