> For the complete documentation index, see [llms.txt](https://docs.enate.net/whats-new/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.enate.net/whats-new/older-versions/changes-overview-older-versions/2023.3-changes-overview/views-page-enhancements-and-new-export-views-to-excel-feature.md).

# Views Page Enhancements & New Export Views to Excel Feature

We've made a number of enhancements to the Views feature. Firstly, we have renamed it to 'Advanced Search'.

We've also made some design improvements - items will now appear in their RAG colors and statuses will appear next to work items as well.

<figure><img src="/files/0BTezaARuoUaq2TtwrWx" alt=""><figcaption></figcaption></figure>

We've added more information that you can search with in the Advanced Search page. You can created searches with the following extra fields:

<table><thead><tr><th width="189">Field Name</th><th>Description of Field</th><th width="175">Type of condition that can be used</th><th>Value</th></tr></thead><tbody><tr><td>Has Been Reopened</td><td>This lets you search for work items that have been reopened from a Resolved state.</td><td>Equals</td><td><p>Select from: </p><p>Yes</p><p>No</p></td></tr><tr><td>Last Reopened By</td><td>This lets you search for who last reopened a work item from a Resolved state. </td><td><p>Begins With</p><p>Equals</p><p>Is Empty</p><p>Is Not Empty</p></td><td>If the condition you have selected is Begins With or Equals, enter the name of a worker</td></tr><tr><td>Last Reopened On</td><td>This lets you search for the last time when a work item was reopened from a Resolved state.</td><td><p>Equals</p><p>Is Empty</p><p>Is Not Empty</p><p>Not Equal </p><p>Greater Than</p><p>Greater Than Or Equals To</p><p>Less Than </p><p>Less Than Or Equals To </p><p>Between</p></td><td>Select a date</td></tr><tr><td>Initial Request On</td><td>If a further work item has been created from an original request (when a Sub Case is created, when a Ticket is converted into a Case, when a Case or Action gets reworked, when an Action is created via the 'Start Action' option or when a new linked work item is created), this data lets you search for the start date of the original request, allowing you to capture the entire length of time it has taken to complete a request, as opposed to just the length of time an individual work item has been being worked on.</td><td><p>Equals</p><p>Is Empty</p><p>Is Not Empty</p><p>Not Equal </p><p>Greater Than</p><p>Greater Than Or Equals To</p><p>Less Than </p><p>Less Than Or Equals To </p><p>Between</p></td><td>Select a date</td></tr><tr><td>Is Overdue</td><td>This lets you search for work items that are overdue.</td><td>Equals</td><td><p>Select from: </p><p>Yes</p><p>No</p></td></tr><tr><td>Overdue By Days</td><td>This shows how many days or working days (depending upon the due date configuration) a work item is overdue by.</td><td><p>Equals</p><p>Is Empty</p><p>Is Not Empty</p><p>Not Equal </p><p>Greater Than</p><p>Greater Than Or Equals To</p><p>Less Than </p><p>Less Than Or Equals To </p><p>Between</p></td><td>Enter the desired number of days.</td></tr></tbody></table>

## Exporting Advanced Search Views into Excel

You can export your views data from your Advances Searches into Excel. Watch this video to find out more:

{% embed url="<https://enate.cdn.spotlightr.com/watch/MTQwNzYzOQ==>" %}

To export your views data into an Excel spreadsheet, enter your search criteria in the Advanced Search page and then click to 'Switch to Export'.

<figure><img src="/files/iVE3XQLH6fvg17yzu6XF" alt=""><figcaption></figcaption></figure>

This will show you a list of all of your previously exported files, as well as when they were downloaded, the size of the file, the total number of rows in the file, when the file export was requested, when the export began and when it was completed.

<figure><img src="/files/BsfIgFEcpHm237CoD1b9" alt=""><figcaption></figcaption></figure>

Before you export your search, you can edit the name of the file it will be exported as.

<figure><img src="/files/mT6xwwYFAlCqjuqVV0gI" alt=""><figcaption></figcaption></figure>

You can also adjust which columns you would like to view in your excel export by clicking on 'Select columns'. The columns selected in your search will be automatically selected, but you can adjust your selection here too.

<figure><img src="/files/b7DHaLH1MKbU0gLQALIW" alt=""><figcaption></figcaption></figure>

Then click to 'Export'.

<figure><img src="/files/IRNa0njxsTiW3euvSacX" alt=""><figcaption></figcaption></figure>

Your file will appear as a new row in the Exported Files section with a 'queued' icon next to it. Click to refresh the grid.&#x20;

<figure><img src="/files/4YnbjzthznLrv5BrVzDw" alt=""><figcaption></figcaption></figure>

Once refreshed, the icon will change to a green single tick to show that the export is complete.&#x20;

<figure><img src="/files/cFH5OrpjUVFjGzuJEflb" alt=""><figcaption></figcaption></figure>

If there has been an error in exporting the file, a red warning icon will appear next to it.

<figure><img src="/files/nvfRNvu73Aa8IwCHveUn" alt=""><figcaption></figcaption></figure>

You can download the file by clicking on the file name.

<figure><img src="/files/g3n5dJY3WGT0AeJ6Rblp" alt=""><figcaption></figcaption></figure>

Once it has been downloaded, the icon will change to a green double tick to show that it has been downloaded.&#x20;

<figure><img src="/files/zQ1wIY044ZFSmHxENDzC" alt=""><figcaption></figcaption></figure>

The time and date that it was downloaded will then appear in the 'Downloaded On' column.

<figure><img src="/files/S1OhOa2Dt1nvXhBCGLLL" alt=""><figcaption></figcaption></figure>

The data from your Advanced Search will have been exported into a .xlsx file, including the column titles selected.

<figure><img src="/files/mTaDJGILO9tPkHGVBbAh" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
Please note that in this initial release, column titles will only appear in English. They will be localized in a future release.

Additionally, please note that you can export up to a maximum of one million rows.

Column names in the exported file are different to the names that are displayed in the UI in the Advanced Search page.
{% endhint %}

{% hint style="info" %}
Further Note: Access to this Excel Export feature is not switched on for standard Team Member and Team Leader Roles. To give users access to this feature, a Custom Role must be created via the User Management section of Builder, with the 'Can Export Advanced Search views to Excel' option switched on in the 'Advanced Search' feature access section.
{% endhint %}

#### &#x20;<a href="#e-copy-paste-into-excel" id="e-copy-paste-into-excel"></a>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.enate.net/whats-new/older-versions/changes-overview-older-versions/2023.3-changes-overview/views-page-enhancements-and-new-export-views-to-excel-feature.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.