How-to: Filter & Manage Columns

1.0 Objective

This guide will show you how to filter your agreements and modify the columns in your view.

2.0 Table of Contents

Expand for Table of Contents

• 1.0 Objective
• 2.0 Table of Contents
• 3.0 Intended Audience
• 4.0 Prerequisites
• 5.0 Instructions
  • 5.1 Quick Search
  • 4.1 - Filter Data
  • 4.2 - Export
  • 4.3 - Add/Remove Columns
  • 4.4 - Pin Columns

3.0 Intended Audience

Any Publisher or Company Admin of Agreement Express.

4.0 Prerequisites

• Publisher access and above

5.0 Instructions

5.1 Quick Search

Follow these steps to perform a free-text search for your Agreements.

1. Navigate to the Quick Search bar at the top right of the screen.

   

2. Begin typing your search criteria. The Quick Search feature will automatically search across all fields in the grid.

3. As you start typing, the grid will automatically update with your results.

4.1 - Filter Data

Follow these steps to filter the data in the Workspace.

1. Hover over a column to reveal the column's Menu button.

   

2. Click the Funnel icon

   

3. Enter filter criteria

   

4. Click out of the menu panel or Enter on your keyboard

5. The data in the Grid is now filtered by the criteria provided

4.2 - Export

Follow these steps to export the data in your view in X-Ray to CSV or Excel.

1. Right click anywhere in the Grid

2. Select Export CSV or Export Excel

3. Once the download is complete a file should now be available on your computer containing data from the Grid. (ie, export.xlsx)
   

   

Note: To provide the fastest experience possible with large amounts of data, we only load a select number of agreements at a time. In the event that your view contains a large volume of agreements, the Export feature will only export the data that has been currently loaded. If you scroll down the screen more data will be loaded and included in the export.
We anticipate providing an option to download the full data in the near future!

4.3 - Add/Remove Columns

Follow these steps to add or remove columns from your view.

1. Hover over a column to reveal the column's Menu button. Click it to open the Column Menu.

   

2. Click the Waffle icon to display a list of all columns (field properties) available

   

3. Check/uncheck columns as desired
   Additional tips:

   1. You can search for columns using the search bar within the menu

   2. Show or hide columns all by clicking the checkbox at the top of the menu beside the Search bar

   3. Looking for a data field that isn’t in this list? Contact a member of the Agreement Express team to add it!

4.4 - Pin Columns

Follow these steps to pin a column to your view.

1. Hover over a column to reveal the column's Menu button.

   

2. Click the first tab within the Menu

   

3. Navigate to Pin Column

   

4. Select your desired pin style