× Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues

SQL Field Type to select article.

8 år 6 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:
<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"/>
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?

Be Logga in eller Skapa ett konto ansluta till konversationen.

8 år 6 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:
<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"/>
This seems to work but I'm not sure if it's correct.

Be Logga in eller Skapa ett konto ansluta till konversationen.

Sidan laddades på: 0.052 sekunder
Powered by Kunena Forum

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.