Hi Bernd,
What is the status? Did you succeed? Do you need a hyperlink in a publication? Or in a project?
The plugin supports hyperlink columns. Usually these columns are formatted by the plugin. Since you are using a view, you need to take care of the formatting yourself.
(1) You first need to add a column to your view in which you dynamically build the url as Melody suggested. To display your column as a hyperlink in your publication or project, your column output needs be a valid JSON string in the following format:
{
"label" : "...",
"url" : "http://www.openstreetmap.org/?mlat=...",
"target" : "_blank"
}
(2) After that you need to tell the plugin to handle your hyperlink column as a hyperlink in publications and projects:
– Go to the Data Explorer
– Click on the Manage link of your view
– Click Settings
– Click Column Settings
– Select Column Type hyperlink for your hyperlink column
– Save
The challenge is in the first step. Here is an example:
create view authors_bernd as
select first_name,
concat('{"label":"',first_name,'","url":"http://wordpress.local/wp-admin/admin.php?page=wpda&table_name=authors&action=listtable&wpda_s=',first_name,'","target":""}') url
from authors;
The example is simpler than yours, but it contains everything you need in your view as well. Column url is defined as a hyperlink within the plugin. In the create view it is a concatenation of strings and the value of column first_name. The output of column url must be valid JSON in the format I mentioned above.
I hope this helps you to create a dynamic hyperlink. My advice: try to get it working with just one column first and add your other columns later.
Let me know if I can help!
@melody Thank you for contribution! 🙂 It is appreciated!
Best regards,
Peter
