HyperOsmar
Member
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:
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"
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
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"