[#14431] - ERROR IN DATASET AND QUERY DIALOG

Category:
Bug report
Priority:
High
Status:
New
Project: Severity:
Major
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:

IN DATASET AND QUERY DIALOG

In the test tab I have this query

SELECT
sga_persona."apellido1" || ' ' ||sga_persona."apellido2" || ' '|| sga_persona."nombres" AS sga_persona_estudiante,
sga_persona.cedula AS sga_persona_cedula,
sga_persona.pasaporte AS sga_persona_pasaporte,
carrera( sga_carrera."nombre") AS sga_carrera,
mencion( sga_carrera."nombre") AS sga_mencion,
sga_inscripcion.coordinacion_id AS sga_inscripcion_coordinacion_id,
sga_inscripcion.capel AS sga_inscripcion_capel
FROM sga_persona sga_persona
RIGHT OUTER JOIN sga_inscripcion sga_inscripcion ON
sga_persona.id = sga_inscripcion.persona_id
LEFT OUTER JOIN sga_carrera sga_carrera ON
sga_inscripcion.carrera_id = sga_carrera.id
WHERE
sga_inscripcion.id = $P{inscripcion}

And when passing from text to diagram and returning it deletes the concatenated data giving me the following result

SELECT ,
sga_persona.cedula AS sga_persona_cedula,
sga_persona.pasaporte AS sga_persona_pasaporte,
carrera( sga_carrera."nombre") AS sga_carrera,
mencion( sga_carrera."nombre") AS sga_mencion,
sga_inscripcion.coordinacion_id AS sga_inscripcion_coordinacion_id,
sga_inscripcion.capel AS sga_inscripcion_capel
FROM sga_persona sga_persona
RIGHT OUTER JOIN sga_inscripcion sga_inscripcion ON
sga_persona.id = sga_inscripcion.persona_id
LEFT OUTER JOIN sga_carrera sga_carrera ON
sga_inscripcion.carrera_id = sga_carrera.id
WHERE
sga_inscripcion.id = $P{inscripcion}

Delete the concatenated data, in the ireport this did not happen, in this case is simple but it can be that there are other much more complex queries

emelo's picture
2
Joined: Sep 26 2017 - 6:54am
Last seen: 2 months 6 days ago
Feedback
randomness