Revision dfdfb88c
Von Tamino Steinert vor 6 Monaten hinzugefügt
- ID dfdfb88c555d5b4f0be25b551e4bc2aa709b111b
- Vorgänger 6aa91d87
| SL/DB/Manager/EmailJournal.pm | ||
|---|---|---|
|
)
|
||
|
)} => \'TRUE';
|
||
|
},
|
||
|
unprocessed_attachment_names => sub {
|
||
|
my ($key, $value, $prefix) = @_;
|
||
|
return (
|
||
|
and => [
|
||
|
'attachments.name' => $value,
|
||
|
'attachments.processed' => 0,
|
||
|
],
|
||
|
'attachments'
|
||
|
)
|
||
|
},
|
||
|
has_unprocessed_attachments => sub {
|
||
|
my ($key, $value, $prefix) = @_;
|
||
|
|
||
| ... | ... | |
|
AND record_links.to_id = email_journal.id
|
||
|
)
|
||
|
)},
|
||
|
attachment => qq{(
|
||
|
attachment_names => qq{(
|
||
|
SELECT STRING_AGG(
|
||
|
email_journal_attachments.name,
|
||
|
', '
|
||
|
ORDER BY email_journal_attachments.position ASC
|
||
|
)
|
||
|
FROM email_journal_attachments
|
||
|
WHERE
|
||
|
email_journal_attachments.email_journal_id = email_journal.id
|
||
|
)},
|
||
|
unprocessed_attachment_names => qq{(
|
||
|
SELECT STRING_AGG(
|
||
|
email_journal_attachments.name,
|
||
|
', '
|
||
| ... | ... | |
|
FROM email_journal_attachments
|
||
|
WHERE
|
||
|
email_journal_attachments.email_journal_id = email_journal.id
|
||
|
AND email_journal_attachments.processed = FALSE
|
||
|
)},
|
||
|
has_unprocessed_attachments => qq{(
|
||
|
SELECT count(*)
|
||
Auch abrufbar als: Unified diff
EmailJournal: Komplexer Bericht mit komplexen Filter