×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
SQL Field Type to select article.
Betton Design
Navegador Iniciado
Posts: 2
8 años 5 meses antes #1359
por Betton Design
SQL Field Type to select article. Publicado por 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?
Por favor, Identificarse o Crear cuenta para unirse a la conversación.
Betton Design
Navegador Iniciado
Posts: 2
8 años 5 meses antes #1360
por Betton Design
Respuesta de Betton Design sobre el tema 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"/>Por favor, Identificarse o Crear cuenta para unirse a la conversación.
Tiempo de carga de la página: 0.054 segundos