Re: [Puppet Users] PQL questions

2017-08-10 Thread R.I.Pienaar
On Thu, Aug 10, 2017, at 18:32, R.I.Pienaar wrote: > I want to do dot based fact queries in PQL, basic example: > >inventory[certname] {facts.os.distro.release.major = "7"} > > Great, no problems so far that works, but I cannot figure out how to say > != "7" > > in the fact endpoint I can

[Puppet Users] PQL questions

2017-08-10 Thread R.I.Pienaar
I want to do dot based fact queries in PQL, basic example: inventory[certname] {facts.os.distro.release.major = "7"} Great, no problems so far that works, but I cannot figure out how to say != "7" in the fact endpoint I can do: facts {name = "%s" and !(value = "%s")} However this does no

Re: [Puppet Users] PQL Questions

2016-07-10 Thread R.I.Pienaar
> On 11 Jul 2016, at 00:39, Wyatt Alt wrote: > > > > >> On 07/10/2016 01:32 PM, R.I.Pienaar wrote: >> hey, >> >> Been playing with the PQL language and it's quite nice, have 2 questions. >> >> I want to do a regex case insensitive match, docs mention you can do whatever >> Postgres supports

Re: [Puppet Users] PQL Questions

2016-07-10 Thread Wyatt Alt
On 07/10/2016 01:32 PM, R.I.Pienaar wrote: hey, Been playing with the PQL language and it's quite nice, have 2 questions. I want to do a regex case insensitive match, docs mention you can do whatever Postgres supports but I can't figure out how to do case insensitive matches with PQL? Postg

[Puppet Users] PQL Questions

2016-07-10 Thread R.I.Pienaar
hey, Been playing with the PQL language and it's quite nice, have 2 questions. I want to do a regex case insensitive match, docs mention you can do whatever Postgres supports but I can't figure out how to do case insensitive matches with PQL? Postgres supports ~ and ~* operators but PQL only sup