Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
saved search depends on Date viewed
Hello,
I created items saved search that have the following criteria:
Date viewed is on Today.
and I add the following columns on results:
Display name
Date viewed
# Times viewed
The results include duplicate items
example:
It includes the following rows
Row 1:
Display name: Item1
Date viewed: 11/18/2008 3:36 am
# Times viewed: 1
Row 2:
Display name: Item1
Date viewed: 11/18/2008 10:29 am
# Times viewed: 3
Row 3:
Display name: Item1
Date viewed: 11/18/2008 9:15 pm
# Times viewed: 2
Row 4:
Display name: Item1
Date viewed: 11/18/2008 10:59 pm
# Times viewed: 3
and other items have more duplicate rows, Is there any way to display result without duplicate, and the # Times viewed is the sum of all the # Times viewed in the day, not only in a specific minute?
0