DataBaseJoin: 500 - filter query error... - SOLVED

[HyperOsmar]

Dear colleagues,

I have a simple Form that searches for values in two more tables through the DataBaseJoin element, it works perfectly.

But in List is not working properly. When I try to open it, the following message appears:

500
filter query error: name_ie Column 'id' in where clause is ambiguous​

This message only occurs when the elements nome_ie and/or level_curso are published.

I can't find the error. I've checked several times item by item and nothing.

Can someone help me???...


Below are the table data:

cod_ie (databasejoin)
Value: id
Label: nome_iec
AJAX Update "Yes"

nome_ie (databasejoin)
Value: nome_ie
Label: nome_ie
WHERE id = '{cad_cursos_pactuados___cod_ie_raw}'
AJAX Update "Yes"

sigla_ie (databasejoin)
Value: sigla_ie
Label: sigla_ie
WHERE id = '{cad_cursos_pactuados___cod_ie_raw}'
AJAX Update "Yes"

tipo_ie (databasejoin)
Value: tipo
Label: tipo
WHERE id = '{cad_cursos_pactuados___cod_ie_raw}'
AJAX Update "Yes"

nivel_ie (databasejoin)
Value: nivel
Label: nivel
WHERE id = '{cad_cursos_pactuados___cod_ie_raw}'
AJAX Update "Yes"

cod_curso (databasejoin)
Value: id
Label: curso
AJAX Update "Yes"

nome_curso (databasejoin)
Value: curso
Label: curso
WHERE id = '{cad_cursos_pactuados___cod_curso_raw}'
AJAX Update "Yes"

nivel_curso (databasejoin)
Value: nivel
Label: nivel
WHERE id = '{cad_cursos_pactuados___cod_curso_raw}'
AJAX Update "Yes"

 

[troester]

If you have more than one dbjoin pointing to the same database table you must use {thistable}.some-column in Data-where and Concat etc., Fabrik will replace with table aliases.
http://fabrikar.com/forums/index.php?wiki/database-join-element/#data-where

It doesn't hurt to use {thistable} always.

 

[HyperOsmar]

Sorry @troester but I'm lost.
I read and reread your message and I couldn't get it...
I need two fields, one with the code (value) and another with the name (label). I accept suggestions...

 

[troester]

In all your Data-wheres do e.g

nivel_ie (databasejoin)
Value: nivel
Label: nivel
WHERE {thistable}.id = '{cad_cursos_pactuados___cod_ie_raw}'
AJAX Update "Yes"

 

[HyperOsmar]

O M G!!!...
So simple and I breaking my head...
Thanks @troester ...