Title: Cannot create URL link in SQL View
Last modified: February 15, 2023

---

# Cannot create URL link in SQL View

 *  Resolved [rc169](https://wordpress.org/support/users/rc169/)
 * (@rc169)
 * [3 years, 3 months ago](https://wordpress.org/support/topic/cannot-create-url-link-in-sql-view/)
 * 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 = ModalHyperlinks on modal = AlwaysShow icons =
   YesHowever, 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](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [3 years, 3 months ago](https://wordpress.org/support/topic/cannot-create-url-link-in-sql-view/#post-16476187)
 * 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:
 *     ```wp-block-code
       <a href="your url here">Link text</a>
       ```
   
 * Can you give that a try?
 * We’ll wait for your response. 🙂
 *  Thread Starter [rc169](https://wordpress.org/support/users/rc169/)
 * (@rc169)
 * [3 years, 3 months ago](https://wordpress.org/support/topic/cannot-create-url-link-in-sql-view/#post-16478450)
 * 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.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

## Tags

 * [hyperlink](https://wordpress.org/support/topic-tag/hyperlink/)

 * 3 replies
 * 2 participants
 * Last reply from: [rc169](https://wordpress.org/support/users/rc169/)
 * Last activity: [3 years, 3 months ago](https://wordpress.org/support/topic/cannot-create-url-link-in-sql-view/#post-16478450)
 * Status: resolved