248 Posts
Giuse
7 years ago
2
Topic

Hi, I have an SQL field (pay plugin) in a content field of an article that calculates a reference to another article (precisely the referenced article is about the product that replaces current article/product): the text/name of the referenced article appears correctly, but the link not - actually Seblod does not put the link on the text even if the link is set to be shown: Link = View and in the popup configuration of the link Content = Field and field name = <name_of_current_SQL field>.

The SQL field is very easy and seems correct since the reference article is shown correctly:

SELECT ART.title AS text, ART.id AS value FROM #__content AS ART INNER JOIN #__cck_store_form_lpt_product AS PROD ON PROD.id=ART.id WHERE PROD.replaced_by = [pk]

Is there a bug in how the link works with SQL field?

thanks a lot

Giuse

Get a VIP membership
4229 Posts
Kadministrator
7 years ago
1
Level 1

sql field does not have text and value,  queries output is it's text and value at the same time.

But there is also a bug introduced after 3.11 that will prevent correct rendering of links on the field https://github.com/Octopoos/SEBLOD/issues/454

248 Posts
Giuse
7 years ago
0
Level 2

ok, thanks, waiting for the fix

Get a VIP membership