Hi, I am trying to add another column in the dashboard which is to count distinct user.

I understand that I need to do something like this to get the number:
SELECT COUNT(uid) from ost_thread_event where uid_type='U';

When I go to the class.report.php, all I see is something like SqlAggregate::Count(SqlCase etc.:

I am not familiar to how the data is pulled from the database. Can anyone help how to achieve my goal or at least guide me how to understand the syntax being used. Regards

  • KevinTheJedi replied to this.
  • mulyana

    You are modifying the codebase. You are always on your own when modifying the codebase as you are deviating from core. You will proceed at your own risk. Good luck!

    Cheers.

    mulyana

    You are modifying the codebase. You are always on your own when modifying the codebase as you are deviating from core. You will proceed at your own risk. Good luck!

    Cheers.

    5 days later

    People can be cruel sometimes. I am just asking how to at least understand the SQL. Maybe a little guidance.

      mulyana

      Not trying to be cruel or anything it's just that we simply do not have any guides nor any kind of ORM documentation or anything so that means you are on your own (like everyone else). The code is open-source and publicly available for you to search to your heart's content.

      Cheers.

      Write a Reply...