How can I display in a select widget values that have some similarities?

The problem mentioned is that the select widget is returning an error due to duplicate values found for properties that must be unique. This is because there are employees with the same surname and name in the table. To solve this problem, we can use the user_id column, which is unique, as the value in the label-value pair, and the name and surname columns as the label.

For example, we can use the following code to map the data from the QueryName object and create an array of objects with the label and value properties:

{{QueryName.data.map((item) => {return { "label": item.name + ' ' + item.surname, "value": item["user_id"]}})}}

This code creates an array of objects, where each object contains a label and a value property. The label is the concatenation of the name and surname columns, and the value is the user_id column.

By using this approach, we can display a select where the options are unique, based on the user_id column, and still show the employee's name and surname as the label.