Distinct from GlideQuery

[TT3]

Can someone please help to give any reference on how to use distinct for GlideQuery. My GlideQuery returns values, but I need to loop for only distinct values for one of the column. Here is an example:

new GlideQuery(Constants.My_Table)
                .where('inventory_id', current.u_inventory_id)
                .select('wo_number')
                .forEach(function (orderItem) {
                  // This is looping for all ther wo_number, however, I just want distinct wo_number
                }

[Prasad Pagar]

Hi TT,

Check this

https://servicenowguru.com/scripting/gliderecord-distinct-query/

Thank you
Prasad

[TT3]

That is for GlideRecord, I need GlideQuery.

[-O- · Accepted solution]

new GlideQuery(Constants.My_Table)
	.where('inventory_id', current.u_inventory_id)
	.whereNotNull('wo_number')
	.aggregate('count')
	.groupBy('wo_number')
	.select()
	.forEach(function (record) {
		gs.debug(record.group.wo_number);
	});