• 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


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:


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.



Legendary Poster
I think you need a second query

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


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