DataView Filter Question: Retrieve Unique JobItem from SLJobTrans IDO

Kurt Wireman

Hello, would anyone know what the syntax is for filtering for unique values in a dataview? Here's the IDO collections I'm using in my dataview to help give a clearer idea of what's going on. Essentially, this dataview works but it's retrieving multiple records for all items, but for my purposes I only need unique values. Thanks so much, I appreciate it!

dylan-klima

I don't think there is a unique option, but would be interested to hear other people if so. You need to change how you build it I think so the cause of the duplicate records is eliminated. Would need more info to say with 100% certainty, but I think you may be able to reach the desired results by filtering the SLJobTrans by using an exists function in the filter to only returned the most recent SLJobTrans record in your time range for each JobItem, which would result in no duplicate JobItems from that IDO.