Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Reports: Please add Function and Sort to Condition tab #7157

Open
evgu opened this issue Apr 7, 2019 · 0 comments
Open

Reports: Please add Function and Sort to Condition tab #7157

evgu opened this issue Apr 7, 2019 · 0 comments
Labels
Type:Suggestion Issue containing a suggestion of functionality, process or UI. Associated PRs are called enhancement

Comments

@evgu
Copy link

evgu commented Apr 7, 2019

The business problem: "What is the date of the last call and last email to every lead. Then, contact the oldest"

A really good report we would like to use is when we can sort hunderds of leads by the last touchpoints we have with them (call, voicemail, email).

Currently the SuiteCRM Reports module does not have the ability to sort and select min/max date values for nested queries - e.g. what is the date of the latest call date on a lead.

This can be easily resolved if 'function' and 'sort' fields are also added to the 'conditions' tab. See screenshots. In this way when filtering records we can filter by the value of the last call/email.

Screenshot 2019-04-08 at 00 34 38

Screenshot 2019-04-08 at 00 33 23

@willrennie willrennie added the Type:Suggestion Issue containing a suggestion of functionality, process or UI. Associated PRs are called enhancement label Apr 8, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Type:Suggestion Issue containing a suggestion of functionality, process or UI. Associated PRs are called enhancement
Projects
None yet
Development

No branches or pull requests

2 participants