Cannot create URL link in SQL View

  • Resolved rc169

    (@rc169)


    1 year, 8 months ago

    Hello,

    I have created two database tables using WP Data Access, and an SQL View to display the combined data from the two tables.

    Now that the SQL view has been created, an issue has arisen with the use of the view on a WordPress page. In WP Data Access, I have setup Data Tables, and in the data tables, I have some columns which are URLs of files located on the website. In “Table Builder” – “Data Tables”, “Publication type”, I have set these up with the following settings:-

    Type = Modal

    Hyperlinks on modal = Always

    Show icons = Yes

    However, with these settings on the SQL View, the URLs are shown as plain text, and do not open the corresponding page. In “Data Explorer”, I have set the columns as Column Type “Hyperlink”, and the save of the settings functions correctly. However, the setting seems to become “lost” subsequently, so that the hyperlinks do not work in the browser. This problem does not arise with the actual data tables, only with the views.

    Can you help with this issue?

    Thanks in advance for your help.

    Nigel (rc169)

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    Hi Nigel,

    Thanks for creating a new post for this issue. ??

    The hyperlink column type only works properly on regular tables as they are updateable, unlike a view.

    For your view, on their original tables, you might need to wrap your links with <a> tags so that they will output as a link on your data table. The column type can be longtext .

    Something like:

    <a href="your url here">Link text</a>

    Can you give that a try?

    We’ll wait for your response. ??

    Thread Starter rc169

    (@rc169)

    Hi Kim,

    Thanks – that works perfectly!

    Nigel (rc169)

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Cannot create URL link in SQL View’ is closed to new replies.

Tags