For support issues please visit https://jira.deiser.com/support

Page tree
Skip to end of metadata
Go to start of metadata

List fields are used to create a list of values. The values can be added manually or imported from an external data source.

 

 

 

PropertyDescription

Name

The name is shown as the field label. It is limited to 100 characters.

Description

Field description. This description will be shown next to the field in the project.

JavaScript

Profields lets you associate JavaScript with any field type. The code inserted here will, when edited by a user, be executed when exiting the field.

View Role

Used to select the role that can view the field being created.

Edit Role

Used to select the role that can edit the field being created.

Custom FieldAllows to have a custom field associated to this project field.

Multiselect

This check box indicates that more than one value can be selected from the list.

 

Data Source

This option is used to decide how the field’s values will be obtained. There are two options: Internal or External.

Internal

Select the Internal option to add values from the list one by one or to import them from a database. When Internal is selected, the following screen is shown:

Parent Field

Used to select a Parent Field to associate the values of the list with the value of this field. This option can be used to have the values shown in the list field depend on the value selected in the Parent Field.

Ex. We will create a list field called ‘Cities’, whose values will depend on the value selected in the ‘Country’ field. To do this, first select ‘Country’ (this field was created previously and already has values) from the ‘Parent Field’ list.

A list appears showing the values in the ‘Province’ parent field.

Next, by selecting each value in the ‘Province’ field, you can create specific values for each, in this case ‘Municipalities’.

Once this is done, the values shown in the ‘Municipalities’ list field will depend on the value of the ‘Province’ parent field.

 

Values

In the Values section you can select how values will be added to the list field. You can choose between:

 

    • Import data from database. If you want to avoid having to enter the values manually, this option can be used to connect to a database and execute a query to import the values from a table to the list field. Once imported, these values do not continue to mirror those in the database.

 

The data imported using this option are not tied to the database. Any changes to the values in the data source will not be reflected in the values of the list. This action deletes the values stored in the list.

 

    • Manually. Select this option to add the list values one by one. This is done by entering each value’s name and its associated ID (optional):

The values can also be deleted once entered. Optionally, they can also be disabled individually without having to be deleted so they are not shown on the list.

External

Select the option External to have the List field connect to a database to obtain its values.

When the External option is selected, the following window appears:

Parent Field. 
Select a Parent Field to associate the values in the list to the value of that field. This option can be used to have the values shown in the list field depend on the value selected in the Parent Field.
Connection. 
Select a connection from the list to choose the database containing the values to be used. 


These connections are configured and stored in: 'JIRA Admin' > 'Plugins' > 'Profields' > 'Connecting to Data Sources' .

 

Query "SELECT" *. 
Once the corresponding connection is selected, enter the SQL query in this field needed to obtain the desired values.

The Preview button shows a window with the data obtained from the resulting query.

The values of the list field obtained using the External option are associated with the data source selected. This data source will be connected whenever the field for obtaining the values is shown on the screen.
  • No labels