• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Get Query Record Count

nkuebelbeck

VIP Member
After executing JDB_SelectKeyed, is there an API to get the count of records returned?

[update 1]
just found JDB_SelectKeyedGetCount, we'll see if that works

[update 2]
JDB_SelectKeyedGetCount is not working.

Some background, I've opened the table, did some some Aggregate and Groupby...do these effect JDB_SelectKeyedGetCount?

[update 3]
I'm looking for a count of the groupby query
 
Last edited:

craig_welton

Legendary Poster
JDB_SelectKeyedGetCount is not an aggregation API, just use it with a key or select struct to get the count.

To get a count with aggregation set the nFunction to JDB_AGGRGFUNC_COUNT in the aggregation DS.

Craig
 

craig_welton

Legendary Poster
I think you need a second query

select count(distinct detail.order) from detail where detail.shipment = "10429";
 

nkuebelbeck

VIP Member
Yeah, that's what i'm messing with now. Can't count over multiple columns (sales order head key)

thanks for all the help
 
Top