×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
SQL Field Type to select article.
Betton Design
New Member
Posts: 2
8 år 3 månader sedan #1359
av Betton Design
SQL Field Type to select article. skapades av Betton Design
Hi all
I have used Component Creator to create a very simple image organiser. One the the form fields is a standard SQL field with a query to select articles. the resulting xml code is:This works with no issue.
I have also selected that this should be searchable, it is here that I have the problem. Currently the article title is shown in the list view but when I search via article title then there are no results. Instead if I search via article id then the correct item appears.
Does anyone know what I need to do in order to make the article title searchable rather than the article id?
I have used Component Creator to create a very simple image organiser. One the the form fields is a standard SQL field with a query to select articles. the resulting xml code is:
<field
name="article"
type="sql"
query="SELECT id, title FROM #__content"
key_field="id"
value_field="title"
label="COM_BD_MEDIAMANAGER_FORM_LBL_ITEM_ARTICLE"
description="COM_BD_MEDIAMANAGER_FORM_DESC_ITEM_ARTICLE"
hint="COM_BD_MEDIAMANAGER_FORM_LBL_ITEM_ARTICLE"/>I have also selected that this should be searchable, it is here that I have the problem. Currently the article title is shown in the list view but when I search via article title then there are no results. Instead if I search via article id then the correct item appears.
Does anyone know what I need to do in order to make the article title searchable rather than the article id?
Be Logga in eller Skapa ett konto ansluta till konversationen.
Betton Design
New Member
Posts: 2
8 år 3 månader sedan #1360
av Betton Design
Svar från Betton Design i ämnet SQL Field Type to select article.
OK, I have modified my XML file as below:This seems to work but I'm not sure if it's correct.
<field
name="article"
type="sql"
query="SELECT title FROM #__content"
key_field="title"
value_field="title"
label="COM_BD_MEDIAMANAGER_FORM_LBL_ITEM_ARTICLE"
description="COM_BD_MEDIAMANAGER_FORM_DESC_ITEM_ARTICLE"
hint="COM_BD_MEDIAMANAGER_FORM_LBL_ITEM_ARTICLE"/>Be Logga in eller Skapa ett konto ansluta till konversationen.
Sidan laddades på: 0.065 sekunder