1

I’m trying to generate a report that shows the number of completed tasks for the logged-in user during a date range. For the sake of keeping this simple, I want to hard code that date range to be: 1-JAN 2017 to 22-AUG 2017.

I’ve been following the online example found here for adding a custom report:

https://activecollab.com/help-classic/books/developing-activecollab-module/new-report

The report I would like to add would display two columns:

  • Logged in User Name
  • Sum of Completed Tasks (for 1-JAN 2017 to 22-AUG 2017)

If I was writing a raw SQL query I know I would just do something like: select a count of all projects where employee name is so-and-so and complete is true; within this date range.

But when I looked at the sample PHP code from this online help (in the above link), it seems Active Collab is using some kind of ORM.

I’ve been looking through our Active Collab code (we're self hosted) to see if I could find a list of the objects that represent the tables; but I’m not used to this framework, and I can’t find them. Is there a certain folder to look at to see what model I should call?

Are there examples in the code of doing a similar request like this; that I could look at?

Thanks!

Joe
  • 8,251
  • 3
  • 18
  • 23
  • Down voter: please give reasons. – Joe Aug 22 '17 at 22:23
  • Are you using version 4 or version 5 of ActiveCollab? You can check the exact version on Administration or System Settings page. – Ilija Aug 24 '17 at 07:21
  • We're on 4.2.17 – Joe Aug 24 '17 at 16:12
  • IIija, I noticed in the heading of this online document, I referenced, that it reads the tutorial is about an "old version of Active Collab that’s not developed anymore". So does that mean this custom report feature is not supported anymore? Would it be the best next course of action to upgrade to AC 5 and try to use the API to accomplish my goal? – Joe Aug 25 '17 at 17:22

0 Answers0