× 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 years 5 months ago #1359 by Betton Design

SQL Field Type to select article. was created by 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?

Please Log in or Create an account to join the conversation.

Betton Design

New Member

Posts: 2

8 years 5 months ago #1360 by Betton Design

Replied by Betton Design on topic 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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.052 seconds