duanemoody posted at 4:31PM Sat, 25 June 2016 - #4273627

KristiS posted at 3:23PM Fri, 24 June 2016 - #4273583

I just know there is an easier way to tell if it is a Daz, Poser, or Daz and Poser product and it will be implemented in the near future as they are working on it.

Help me figure out what I'm missing here:

What's new: Poser

What's new: DAZ Studio

Doesn't this already work?

Well, it would work if the SQL query didn't concatenate all checkmark categories as ANDs, Duane. But because it does, it only matches products where the developer checked all the same software titles the user's query did… which won't be possible with older products where newer backwards compatible versions didn't exist yet.

Whoops.

Let's assume Rendo's database is storing a product's compatible software titles in a single column (e.g. comma delimited), because that's less hairy to maintain than continually adding new columns for new products that only contain a boolean value. Where what we as users want gets more complicated is because the SQL query sent to the backend now not only has to split off all software-related checkbox values from the main query statement and make it its own WHERE clause, but you're now having to match a set of values against a column containing a set of values where at least one of the query's set has to be in the column's set. And SQL wasn't designed to match sets.

Fortunately someone else has already had to deal with this problem and solved it, rather elegantly:

http://stackoverflow.com/a/26195280/1574945

Granted, the software title values replacing val1, val2… should be character-escaped to not foul up the regex, but there's already a function for that in PHP.

Again, I'm assuming the database doesn't have ten separate columns corresponding to each checkmark. If it actually does have individual columns for each product, then just write a WHERE clause chaining ten separate productname-to-column matches using OR.

Apologies for meddling.

@Male_M3dia @shvrdavid If I can interrupt here I think the OP wimvdb was asking for a Poser filter and it wasn't a call out for the resumes and qualifications of interested parties. It is a genuine request and neither one of you guys are helping by fighting because it puts other members off commenting and showing support, hardly fair to the OP. I have asked once already to get the thread back on track, Kristi has asked and for the record both of you are derailing a thread arguing about who is derailing a thread.

Kristi has stated that this original suggestion has already been discussed and something will be implemented so unless it is on topic with suggestion/ideas please refrain from posting.

how about malemedia and shvrdavid take it elsewhere? preferably somewhere a long long way from the rest of us who have no interest at all in their "who's got the biggest penis contest"