Enable "Link values to URL" and "Text formatting" about custom_field_sql

[apsmir]

A good idea. I will think about implementation

[jankokert]

Great! Thanks!

I took a deeper look at your source code. I have no experience with Ruby, but I seems that you derive the sql field from the StringFormat and from List (lib/custom_field_sql/custom_fields/formats/sql.rb line 5 and 11).

To make the value "clickable", there is already a mechanism in Redmine, called "Link values to URL" which is applicable to boolean, date, list, integer and text format fields.
See here: https://www.redmine.org/projects/redmine/wiki/RedmineCustomFields#Link-values-to-URL

So the only thing you need to do is to provide that input field (Link values to URL)
and then pass it to the original field and let Redmine to the rest.

I think you need to add the input field here, don't you?
app/views/custom_fields/formats/_sql.html.erb

Furthermore, you could also pass the "Text formatting" input field to the base class in the same manner.

[jankokert]

I checked the Redmine database and the field for "Link values to URL" is stored in the column format_store of the table custom_fields.
The field contains multiple lines:

--- 
!ruby/hash:ActiveSupport::HashWithIndifferentAccess
text_formatting: ''
url_pattern: ''

The line with the key url_pattern is relevant for linking the values to an URL.

Hope this helps to implement this. Cheers.

[jankokert]

Unfortunately, I cannot see any activity on this issue. Are you working on it?
It would be a tremendous benefit for my installation! Thanks in advance!
Also, can you please answer my question in #1 ?