nkuebelbeck
VIP Member
I'm trying to accomplish this -> http://sqlfiddle.com/#!9/2444a/17
I've manage to use JDB_SetAggregate and JDB_SetGroupBy to successfully execute a select statement that works.
My question is how do I iterate over the results (sum included)?
normally i'd use JDE_Fetch, but all columns must be defined in a DS to access there values.
here is the best jde doc i can find E1: BSFN: How to Sum/Aggregate Quantity or Amount using JDE API (Doc ID 1082178.1), but this just give me the aggregate results and none of the other data related to the record
Thanks in advance!
I've manage to use JDB_SetAggregate and JDB_SetGroupBy to successfully execute a select statement that works.
My question is how do I iterate over the results (sum included)?
normally i'd use JDE_Fetch, but all columns must be defined in a DS to access there values.
here is the best jde doc i can find E1: BSFN: How to Sum/Aggregate Quantity or Amount using JDE API (Doc ID 1082178.1), but this just give me the aggregate results and none of the other data related to the record
Thanks in advance!