# Data preview & download

## Field properties configuration

You, as an editor, can configure the field's properties in menu action when click on column header:

<figure><img src="https://786945529-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FFTrGKWnjusKCQj11CkuL%2Fuploads%2Fbyl0SGVADm47MDCOBWmg%2FScreenshot%202025-02-26%20at%2017.32.54.png?alt=media&#x26;token=9641e6ee-c777-468f-b623-7c6078a1065b" alt=""><figcaption></figcaption></figure>

* **Edit description:** Add/ edit description to provide context or notes to the field (optional).

<figure><img src="https://786945529-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FFTrGKWnjusKCQj11CkuL%2Fuploads%2FAXR3W91AtSTwgN7swCJ2%2FScreenshot%202025-02-27%20at%2011.09.09.png?alt=media&#x26;token=70486a67-fda2-4284-a0ec-b286855060e1" alt=""><figcaption></figcaption></figure>

Description can be viewed by hovering tip icon next to field name.

* **Edit field alias:** Add/ edit alias to the field (optional). If no alias is added, header (field name) will be shown as-is (extracted from query).

<figure><img src="https://786945529-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FFTrGKWnjusKCQj11CkuL%2Fuploads%2FrclNcG2xdNV5PjFnqTLj%2FScreenshot%202025-02-27%20at%2011.06.36.png?alt=media&#x26;token=83ec8db7-ca5b-43a0-9e18-961dd730b595" alt=""><figcaption></figcaption></figure>

Click the **X** icon on the right side of the text to revert to the original field name.

## Filters & sorting

You can filter and sort data in the Data Service preview to conduct analysis, focus on specific details, or refine your data view.

### Set filter conditions

1. Click **Filter** at the top of the preview table.
2. You can add multiple filter conditions.
   * Select a field (e.g., *Customer, OrderID, Revenue, Date*).
   * Choose an operator, available options based on data type of the field (see table below).
   * Enter the filter value.

<table><thead><tr><th width="167">Operator</th><th width="126" align="center">STRING</th><th width="118" align="center">INT</th><th width="113" align="center">FLOAT</th><th width="118" align="center">DATETIME</th><th align="center">BOOLEAN</th></tr></thead><tbody><tr><td><ul><li>Equal</li><li>Not equal</li></ul></td><td align="center">✓</td><td align="center">✓</td><td align="center">✓</td><td align="center"></td><td align="center">✓</td></tr><tr><td><ul><li>Greater than</li><li>Greater than or equal to</li><li>Less than</li><li>Less than or equal to</li></ul></td><td align="center">✓</td><td align="center">✓</td><td align="center">✓</td><td align="center"></td><td align="center"></td></tr><tr><td><ul><li>Contains</li><li>Not contains</li></ul></td><td align="center">✓</td><td align="center"></td><td align="center"></td><td align="center"></td><td align="center"></td></tr><tr><td><ul><li>Time range</li></ul></td><td align="center">✓</td><td align="center"></td><td align="center"></td><td align="center">✓</td><td align="center"></td></tr></tbody></table>

Click the **X** icon on the right side of the filter condition to delete it.

3. You can choose whether **Any** or **All** needs to be met.
4. Click **Confirm** to apply filter conditions.

<figure><img src="https://786945529-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FFTrGKWnjusKCQj11CkuL%2Fuploads%2FetxdrDCgb7xPOgulCeax%2F1.0%20Open%20filter%20popover.png?alt=media&#x26;token=f6c708b0-e933-425e-abec-af27d0d157c8" alt=""><figcaption></figcaption></figure>

### Set sort conditions

1. Click **Filter** at the top of the preview table.
2. You can add multiple sort conditions.
   1. Select a field to sort.
   2. Choose the sort method (**Ascending** or **Descending**).

Click the **X** icon on the right side of the sort condition to delete it.

3. Click **Confirm** to apply sort conditions.

<figure><img src="https://786945529-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FFTrGKWnjusKCQj11CkuL%2Fuploads%2F9WK9cra9wNIPihkV0Vbh%2F2.0%20Open%20sort%20popover.png?alt=media&#x26;token=c56a8d48-57ff-43b5-9434-34368e354ce7" alt=""><figcaption></figcaption></figure>

## Refresh to get latest data

You can click **Refresh** at the top right corner of the data preview table to extract latest data.

<figure><img src="https://786945529-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FFTrGKWnjusKCQj11CkuL%2Fuploads%2FsOjfU5Ioz6MhVsMGtXcJ%2FScreenshot%202025-02-27%20at%2010.55.28.png?alt=media&#x26;token=91c0b31f-a3f0-4e7a-86cf-ffb01475eb6b" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
Clicking the **Refresh** button triggers to get the **latest** data based on current sort/ filter conditions that being applied, but takes no effect on reset or changing those configurations.
{% endhint %}

## Download data

1. Click the **Download** button at the top of the data preview table.
2. You can rename the download file (optional). By default, file name is the Data Service's name.
3. Select file format (**Excel** or **CSV**).

<figure><img src="https://786945529-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FFTrGKWnjusKCQj11CkuL%2Fuploads%2FRfpMndnrww3OP8FcYdz9%2FScreenshot%202025-02-27%20at%2011.31.08.png?alt=media&#x26;token=8ad02142-bf62-446d-a97e-dbb8a6031b48" alt=""><figcaption></figcaption></figure>

4. Click **Download.**
5. Check download task in your browser.

**Note**:

* Field alias, filter and sort conditions will take effect on your download file.
* Total row number of your download file should not exceed 500,000 rows.
