Uploaded image for project: 'PuppetDB'
  1. PuppetDB
  2. PDB-2527

support latest_report? as a query field on event-counts/aggregate-event-counts

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: PDB 4.1.0
    • Component/s: None
    • Labels:
      None
    • Template:
    • Story Points:
      3

      Description

      We document these endpoints as being queryable with the same fields as events, but latest_report? is not included. I'm not sure yet why it doesn't work, but Verne Lindner has an interest in this fix.

      To be concrete, this should work

      [wyatt@desktop puppetdb](master) $ curl -X GET http://localhost:8080/pdb/query/v4/event-counts -d 'distinct_start_time=2015-01-01' -d 'distinct_end_time=2016-10-10' -d 'distinct_resources=true' -d 'summarize_by=resource' -d 'query=["=", "latest_report?", true]'
      <html>
      <head>
      <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1"/>
      <title>Error 500 </title>
      </head>
      <body>
      <h2>HTTP ERROR: 500</h2>
      <p>Problem accessing /pdb/query/v4/event-counts. Reason:
      <pre>    org.postgresql.util.PSQLException: ERROR: column certnames.latest_report does not exist
        Hint: Perhaps you meant to reference the column "certnames.latest_report_id".
        Position: 2905</pre></p>
      <hr /><i><small>Powered by Jetty://</small></i>
      </body>
      </html>
      

        Attachments

          Activity

            jsd-sla-details-panel

              People

              • Assignee:
                Unassigned
                Reporter:
                wyatt Wyatt Alt
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: