Report filter not working properly

Follow
Wayne Osteen

I know this should work, but it's not. Any ideas?

I want to know machines where *both* applications are installed. Either filters properly, both does not.

 

 

Thanks!

Wayne

1

Comments

2 comments

Date Votes
  • Luke Nichols

    Wayne,

    Interesting find, I don't know why this isn't working. I tried every permutation I could think of with the group filters and I couldn't get it to work. I also tried several different types of SQL reports and couldn't get it.

    The weird thing is that these exact same filters work for a collection, but not for a report. As I see it, you have a few options:

    • Create a collection with those same filters and then run a report with no filters against that collection
    • Try to figure out a SQL report to do this. I tried (and failed) to construct a SQL report with an outer query for application #1 and then a subquery for application #2 since I couldn't figure out how to do it all in one query, but if you're better at SQL than me then you can probably make this work.

    I would open a support case with PDQ as well-- this is probably a bug, given that it works for a collection but not for a report. For reference, my PDQ Inventory version is 17.1.0.0 Enterprise Mode and I was able to reproduce your issue.

    2
    Comment actions Permalink
  • Wayne Osteen

    Thanks for the second set of eyes Luke! I created a collection and it did indeed work.

    I'm opening a ticket right now with support. Cheers!

    1
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post