iam trying to convert my saved search to sql i wa...
# suiteqls
Sim Greenbaum
07/13/2023, 7:39 PMiam trying to convert my saved search to sql i want to start one step at a time
Copy code
DECODE({item.memberitem},NULL,{item},{item.memberitem}) group by item name DECODE({item.memberquantity},NULL,{quantity},{quantity}*{item.memberquantity}) qty item soldc
Clay Roper
07/13/2023, 8:04 PMWhat kind of help do you need?
s
Sim Greenbaum
07/13/2023, 8:28 PMim trying to switch this to sql
Sim Greenbaum
07/13/2023, 8:29 PMwe have kits / assembly /inv tiem we would like to get the qty sold of the member item
k
Kushington
07/17/2023, 1:20 PMWhat have you tried so far?
3 Views