Summary: | Kexi erased some criteria of a query once a new field is added to the query | ||
---|---|---|---|
Product: | [Applications] KEXI | Reporter: | Begonia <saavedra.ibarra> |
Component: | Queries | Assignee: | Kexi Bugs <kexi-bugs> |
Status: | CLOSED DUPLICATE | ||
Severity: | normal | CC: | adam, inksi, staniek |
Priority: | NOR | ||
Version: | 2.9.7 | ||
Target Milestone: | --- | ||
Platform: | Ubuntu | ||
OS: | Linux | ||
Latest Commit: | Version Fixed In: | ||
Sentry Crash Report: | |||
Bug Depends on: | |||
Bug Blocks: | 377579 | ||
Attachments: | step by step description of actions where search criteria was erased |
Thanks. Templarary workaround: for certain more complex queries like this use only the SQL view. *** This bug has been marked as a duplicate of bug 377579 *** #377579 is newer but more general and fixed now for 3.0.2. So resolving this one too. Thanks. |
Created attachment 101961 [details] step by step description of actions where search criteria was erased Application: kexi (2.9.7) KDE Platform Version: 4.14.16 Qt Version: 4.8.7 Operating System: Linux 4.4.0-45-generic x86_64 Distribution: Ubuntu 16.04.1 LTS -- Information about the crash: <When a new field is added to a query, any criteria after the second AND is erased (even if the query was previously saved.> Initial query criteria: SELECT nometudiant, prenometudiant, fkmateria, FROM tbl_curso, tblcursoanomater, tblestudante WHERE tbl_curso.refgroupe = tblcursoanomater.fkcurso AND tbl_curso.refgroupe = tblestudante.fkgroupe AND (((tblcursoanomater.fkanocurso)=1)) One field, "libellegroupe", was added [using design screen], and then the last criteria is erased. SELECT nometudiant, prenometudiant, fkmateria, libellegroupe, FROM tbl_curso, tblcursoanomater, tblestudante WHERE tbl_curso.refgroupe = tblcursoanomater.fkcurso AND tbl_curso.refgroupe = tblestudante.fkgroupe see attachement for the rest of the description.