Hi all, With a saved search for transactions (type: sales order), I’m trying to get different line items from system information with specific values for field column. But I get multiple duplicate rows for same sales order. I have removed main line and tax line from the criteria. Does anyone know here how do I filter more to get unique rows for a record? thanks

can you post some criteria and result values you are using? (hard to know what to suggest without seeing what you are already)

This is the criteria I have

You have asked it for every occurrence of Ship Date changing. And that’s what it’s given you. What do you want it to show you? Which date is the one you want to see and how would we programmatically work it out?

it’s not the ship date I’m worried about.. it’s the value in the column

NEW VALUE

that repeats for 18 times.. which I’m not able to show all of them here in the screenshot

Does your order have multiple lines? You'll need to filter your results to just mainline

use a mainline filter in combination with the System Note join

I had

main line

set to false. I thought that’s how I get the line items. Well with

main line

set to true, I’m getting less lines.. Thanks so much guys

With mainline set to false - you get the item/expense lines

got it

It gets even worse if you do a secondary join - such as to a related record that has multiple lines

thanks for that explanation