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

SQL Field Type to select article.

pred 8 rokmi 4 mesiacmi #1359 od Betton Design
SQL Field Type to select article. bolo vytvorené 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?

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

pred 8 rokmi 4 mesiacmi #1360 od Betton Design
Odpoveď od Betton Design na tému 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.

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

Čas vytvorenia stránky: 0.052 sekúnd
Funguje na Kunena fórum

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.