For support issues please visit https://jira.deiser.com/support
List fields are used to create a list of values. The values can be added manually or imported from an external data source.
The name is shown as the field label. It is limited to 100 characters.
Field description. This description will be shown next to the field in the project.
Used to select the role that can view the field being created.
Used to select the role that can edit the field being created.
|Custom Field||Allows to have a custom field associated to this project field.|
This check box indicates that more than one value can be selected from the list.
This option is used to decide how the field’s values will be obtained. There are two options: Internal or External.
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:
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.
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.
- 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.
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:
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.
Select a connection from the list to choose the database containing the values to be used.
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.