After editing an issue and selecting a value in the Connect field, the selected value is displayed several times in the issue view, as shown on the following screenshot:
Let's take the example of a MySQL database containing the following table:
Let's say we only want to display the user firstname. So here is the configuration of the Connect field that has been set up:
The problem of duplicates occurs because the key chosen in the Connect field is not unique.
In our example, the user firstname is defined as the Connect field key:
As we can see, the user_firstname column is not unique because it contains several times the same value: "Simon"
The Connect field key must be absolutely unique. It's therefore necessary to use another column which will be used as the key.
Taking back our example, the user_id column is the most appropriate column to be the key:
Once the modification is made, the problem of duplicates is solved.