Report on unique records

Discussion created by wcallman on Aug 25, 2018
Latest reply on Aug 27, 2018 by mikebeargie

I am using the following script:


Screen Shot 2018-08-25 at 9.08.42 PM.png

This brings back what I need with one exception it also brings back replicated records, which unfortunate.y is part of the design. I want to constrain the found set after this find to only the most recent record and name. I have a time stamp with date and time. I think it can be accomplished with a sql statement and I unfortunately am a "pre" novice to SQL. Can anyone point in the right direction, maybe with a starting point in SQL if that is the best way. Thanks.