AnsweredAssumed Answered

Report only the most recent note for each account

Question asked by HAZOTTE HAZOTTE on Apr 8, 2015
Hi everyone,

I would like to know if there is a convenient way to report for each account only the latest modified (or created) Note.

On Sugar 7.5 Pro version, I created a workflow and created a hidden field named latest_note_date that gets its date updated after a new note is created or modified. It works flawlessly.

However, I don't see how to get only the most recent date using such field with the Report module and using filters. I thought that this extra field would help but I get stuck at this point.

Please note also that I don't have access to source code (this is a hosted version).

Thank you,
Cyril

Outcomes