Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Visible fields (1) page allows the user to preset the displayed fields. The user can search for any fields from the Jira project, decide which fields should be visible and which hide should be hidden (e.g. Fix version (2)), set the column display order, save field and column settings and quick and easy access to saved schema.

...

Section Field Schema (1) allows to save (2) a custom user column order and selected needed/used fields. For more information on custom field schema configuration, visit our step-by-step guide Visible Fields Schema.

...

Search field

Info

Enter the name of the field you are looking for to filter all fields.

In anther section you have a search box (1) which can help you in finding needed field. Notice it searches through field names (not field IDs) while you type, it will narrow down the list of visible fields.

...

Fields

...

With the update to v2.10.0 , the search field bar was moved to the Field section, retaining its existing functionality.

...

Fields

With the implementation of the new Field Schema feature in update v2.7.0 the "Default”button turned into a “Restore” button. Restores the saved settings of the currently selected schema.

For more check https://psc-software.atlassian.net/wiki/spaces/ECSD365/pages/2709487617/Visible+Fields+Schema#Save-%2F-Edit-Field-Schema

Here you can see the list of available fields and decide which fields you want to Show/Hide as data columns.

By clicking "Default" button you will restore visible fields (up to v2.6.2) .

You can change order of the columns by clicking ,,Reorder" button.

Field ID can be displayed to verify fields with same name and Prefix is used in Templating feature.

Info

Enter the name of the field you are looking for to filter all fields.

In another section you have a search box (1) which can help you in finding needed field. Please notice that it searches through field names (not field IDs) while you type, it will narrow down the list of visible fields.

...

Show / Hide

Field section display list of all available fields. Next to each field there is a Show (1) / Hide (2) button, when clicked, the field immediately appears/hides from the worksheet. Use search box to quickly narrow down the list.

...

  • Default (1) - restores default set of visible fields,

  • Reorder (2) - opens a dialog with the option to change the order of fields (columns in Excel). Just drag & drop fields to place it in your desired order.,

  • Sort field list - change alphabetical order of fields (3), it changes the order of the list (not the visible columns).

...

After clicking the Reorder button (2), you can select the order of the columns using the drag-and-drop mechanism by moving the fields up and down according to the required order, to save the changes, press the Save button.

Info

Changes to the order will be applied the next time you click Import/Refresh Issues.

...

Checkboxes: Field ID, Prefix, Column

Additionally to the list of fields there are 2 3 checkboxes, which affect the view of the list:

  • Field ID (1) - showing unique Jira ID of particular field. It might be helpful for solving issues, if there is no data visible, but you are sure this is the correct name → maybe it is the field from another project (field scheme) with same name but different ID. Field IDs are also used in: Templating

  • Prefix (2) - adds the value set in Templating feature to field ID, making it easier to copy and use in template. When you start using templates, being able to copy the exact field ID with prefix will save you a lot of time, learn more about: Templating

...

  • Column (3) - this allows you to acquire the location of particular fields in your spreadsheet, given with exact indexes of the columns. Such a piece of data can be found for every field for which Show button was pushed. Hidden fields have no such information (because - in fact - they don’t exist in your spreadsheet, thus it’s obvious they have no column assigned), so in order to make it appear, you need to push Show button for them as well. Furthermore, by clicking aforementioned indexes we are navigated straight to where these columns actually are in your spreadsheet. For example, if we click G within Assignee box, the name of G column will be selected, exposing its exact location.

...

Info

The entire Column feature denoted by (3) is available from v2.10.0 of Excel 365 Connector onwards.