Jira (PUP-5081) CapabilityFinder needs to look up capabilities by code_id

[Kenneth Barber (JIRA)]

Title: Message Title

Kenneth Barber commented on PUP-5081   Re: CapabilityFinder needs to look up capabilities by code_id Note: So this only works against the puppetdb stable branch, which will be shipped as 3.2.0 soon. There is no shipped version that includes this yet. So the query would be against: /pdb/query/v4/resources ... ["in", "certname", ["extract", "certname", ["select_catalogs", ["=", "code_id", "abcdefg"]]] Obviously you can combined this subquery ^^ with other queries: ["and", ["=","type","Package"], ["=","title","foo"], ["in", "certname", ["extract", "certname", ["select_catalogs", ["=", "code_id", "abcdefg"]]]] In the future, we'll want to use `hash` as the join column when historical catalogs come, but this doesn't exist yet in resources, although I presume when that day comes we'll ask you to switch to the implicit subquery system (https://github.com/puppetlabs/puppetdb/pull/1684) which means the join columns become optional (ie. we fill this in for you, with knowledge that we have about the best way to do it - this will save you every having to think about it again). Add Comment   This message was sent by Atlassian JIRA (v6.4.11#64026-sha1:78f6ec4) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.