Data Retrieval & Project Statistics Updates Today
What developments have taken place today?
Two commits have been made to improve data retrieval and project statistics reporting. The first commit adjusted the sorting order within a data retrieval function to prioritize rows where visible is true. It now sorts by week_year, lines_added, and then id. Adding gps.total_commit_count elevates rows with more commits, enhancing relevance in prioritized results.
The second commit modified a database query for project statistics, shifting the primary sorting criteria to whether a project has a visible website (visible DESC). Subsequent sorting is now based on week_year, lines_added, and id, ensuring consistent and detailed reporting within visibility groups.
These changes are important because they optimize data presentation by prioritizing relevant information—first by visibility status, then by key metrics like commit count and project statistics – leading to more insightful and actionable results for users.
data retrieval project statistics commits sorting database query