Topics started by davidgjelsten

1 Topic

D
Do Gooder (Customer)
davidgjelstenDo Gooder (Customer)
asked in Buying (Procurement, Demand Planner, ASC, SRM)

Advanced SQL Search - List of UNIQUE values?

IFS 8 SP1 Page: Purchase Order Receipt Category: Advanced Search Function - SQL   Hi all, This is my first post on these forums, so please guide me if I’m posting at the wrong area.   Lets say I’m search all deliveries received in >2020. This is thousands of results.  Is there a way to get a list with UNIQUE PART_NO values, where only the first delivery (ACTUAL_DELIVERY_DATE) of the unique part numbers are listed?   I’ve tried:  ARRIVAL_DATE > to_date( '20200101000000', 'YYYYMMDDHH24:MI:SS' ) and UNIQUE (PART_NO) Based on: https://www.w3schools.com/sql/sql_unique.asp

11
D
Do Gooder (Customer)
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings