Skip to content

GitLab

  • Menu
Projects Groups Snippets
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
  • Sign in
  • A ace
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
    • Locked Files
  • Issues 36
    • Issues 36
    • List
    • Boards
    • Service Desk
    • Milestones
    • Iterations
    • Requirements
  • Merge requests 0
    • Merge requests 0
  • Deployments
    • Deployments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • Code review
    • Insights
    • Issue
    • Repository
  • Wiki
    • Wiki
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • adapt
  • ace
  • Issues
  • #39

Closed
Open
Created Mar 30, 2017 by Michael Ritter@shakeContributor

Stats query doesn't work if a collection has no group

When executing the query for the statistics page, an exception is thrown when a collection with no group exists in ace

Exception Description: The column result [colgroup] was not found in the results of the query.
Query: ResultSetMappingQuery(sql="SELECT l1.date, c.name, c.colgroup, m.count, m.size FROM logevent l1 JOIN (   SELECT collection_id, min(date) AS date   FROM logevent   WHERE logtype = 20 GROUP BY collection_id) AS l2 ON l1.collection_id = l2.collection_id AND l1.date = l2.date AND l1.logtype = 20 JOIN (  SELECT id, name, colgroup FROM collection ) AS c ON l1.collection_id = c.id JOIN (   SELECT count(id) AS count, sum(size) AS size, parentcollection_id   FROM monitored_item   GROUP BY parentcollection_id) AS m   ON m.parentcollection_id = c.id ")
Assignee
Assign to
Time tracking