https://bugs.documentfoundation.org/show_bug.cgi?id=103519
Bug ID: 103519
Summary: No User Prompt in nested SQL Query
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
The goal is to list the most recent calls from each contact in a particular
period. Basically the tables are:
contact: id, first, last
call: id, c_id, date --- where c_id is the link to the contact
The following query should do the job. However it runs without prompts and
error message. If I replace the prompts by date strings, then everything works
as expected.
SELECT T.first, T.name, T.id, last_call FROM
(
SELECT DISTINCT contact.first, contact.name, contact.id, last_call
FROM contact
INNER JOIN (select MAX(call.date) last_call, call.c_id from call GROUP
BY call.c_id) call_list
ON ( contact.id = call.c_id )
) T
WHERE (last_call between :from_date AND :to_date) ORDER BY T.name
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
