AnsweredAssumed Answered

Portal Filtering - SQL

Question asked by ponderosa on Sep 19, 2018
Latest reply on Sep 19, 2018 by philmodjunk

I'm trying to filter records out of a portal, and the general consensus is to use SQL. Unfortunately, I don't understand it very well.

 

I have a bunch of product orders in a customer portal with a database ID that repeats itself (_pkProductID), What I'm trying to do is filter out every instance of duplicate product EXCEPT the newest ones.

Screen Shot 2018-09-19 at 9.33.25 AM.jpg

Any help is appreciated.

Outcomes