...
What types of custom field are supported?
- Text Field (< 255 characters)
- User Picker
- User Group Picker - this custom field is developed for User Group Picker plugin. Note that the value of the custom field must first be saved on the issue.
- URL Field - Note that the value of the custom field must first be saved on the issue.
Risk - this is a custom field developed for Kontinuum plugin. Note that the value of the custom field must first be saved on the issue. For the example in the image, the value from the database must be of the form: HIGH|MODERATE|description|60|1|ACCEPTED|solution .
- Free Text Field (unlimited text)
- Database Child Information
- Database Information
- Number
| Note | ||
|---|---|---|
Dynamic query using numeric values for dependents Normally in the WHERE clause we can have only columns of text type in combination with dynamic custom fields. If in the WHERE clause a numeric column (or some other type different from text) is used, the query does not work. For instance if the column id is numeric in the table testTable, the following query:
does not work, because the value of the customfield_10300 is a string. The solution is to use functions available for the database chosen, to transform from string to the type of the column in the SQL query. For instance, for PostgreSQL: SELECT id, col2, col3, col4 FROM testTable WHERE id = to_number({customfield_10300}, '999'); |
...