In the same page where you created Datasource, click on "Fields" tab to switch to the Fields list.
Add/Update Field
- To create a new field, click on "Add a new custom field".
- Or click the button "Pensil" in the list of fields to update one.
- Fill in all the necessary inputs in the popup, according to your configuration.
- Then click on ''Test'' to check the query.
- Finally, click on "Save" button.
Before saving, the plugin automatically tests the validity of the connection and SQL request. If there is a problem, the field cannot be saved.
For the inputs, here are their descriptions:
- Name: Your field name where you will display "Main Column" data.
- Description: Set description of your field.
- DataSource: You will be able to select a datasource based on datasource's list that you have already added in the previous step (See Datasource Documentation).
Query: This concerns sql query that will be executed to retrive data main column. Main column must be a part of the query. For example: select first_name from actor so "first_name" column is the main column and we will display the data for this column.
You can limit the number of results of the query using limit key.
You can use order by to order the data on a conditional basis.
SQL Query
Insert your SQL query without ";" at the end
Main Column: Add main column to retrive data.
You can’t add aleas after mainColumn but you can add them after the other columns.
- Type: there are 5 types of fields (Select, Autocomplete, Table, Checkbox, Radio) and we will treat each of them separately in the next section in order to understand their functionnalities.
- Read Only: Define if the field is read/write or just in read mode.
Read Only Option
If "Read Only" is marked as false, you can save selected valeu in issue view.
- Associated Project: In order to link the field to a specific project, we must add project key. We can add multiple project.
Associated Issue Type: In order to link the field to a specific issue type. In this section, we can see How to get the Type Issue ID or read officiel Atlassian documentation Finding the Issue Type ID in Jira Cloud.
To validate project key in Associated project input, press Enter ou Espace button.
To validate issue type id in Associated issue type, press Enter ou Espace button.
Visibility Field
You can control the visibility of Field in an issue with the "Associated Project" and "Associated Issue Type" parameters.
- Child Fields: Child fields to display in user view. You can add many separating by coma ",".
We have to remember that we can add child fields if field types are Select or Autocomplete only.
Delete Field
You can delete a field by click the button "Trash" in the list of fields.
A popup appears to confirm the operation by "Yes" or "Cancel".