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

PQL : Order By Value returns Unrecognized column 'value'

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: PDB 5.2.6
    • Fix Version/s: None
    • Component/s: PuppetDB
    • Labels:
      None
    • Environment:

      ubuntu 16.04

      puppetserver version: 5.3.6

      postgresql-10 10.6-1.pgdg16.04+1

    • Template:
    • Method Found:
      Needs Assessment
    • QA Risk Assessment:
      Needs Assessment

      Description

      When attempting to order a puppetdb query by the fact value an error is returned saying that the column is unrecognized.

       curl -X GET http://localhost:8080/pdb/query/v4 --data-urlencode 'query=fact_contents[certname,name,path,value ] { path ~> ["apt_installed","whois","version"] and !(value = "undefined") order by value}'
      Unrecognized column 'value' specified in :order_by; Supported columns are 'certname', 'environment', 'path', 'name'
      

      As per the documentation : https://puppet.com/docs/puppetdb/6.2/api/query/v4/facts.html#paging

      querying facts_content should support order by value

      curl -X GET http://localhost:8080/pdb/query/v4 --data-urlencode 'query=fact_contents[certname,name,value]{ name ~ "fqdn" order by value}'
      Unrecognized column 'value' specified in :order_by; Supported columns are 'certname', 'environment', 'path', 'name'
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            jason.grammenos.agilitypr Jason Grammenos
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Zendesk Support