The plain old javascript way to do it is to set keys on an object:
==== BEGIN JS ====
// supposing <jobs> is an array of objcts:
var functions = {};
for(var i=0; i<jobs.length; i++) {
functions[jobs[i].function]=1;
}
for (var f in functions) {
// will iterate only once for each distinct value
}
==== END JS ====
You can also do it server-side with DovetailDB's map/reduce:
==== BEGIN SERVER-SIDE JS ====
function getJobFunction(job) {
var functions={};
functions[job.function] = 1;
return functions;
}
function mergeFunctions(functions1, functions2) {
for(var k2 in functions2) {
functions1[k1] = 1;
}
return functions1;
}
==== END SERVER-SIDE JS ====
And calling on the client side like so:
==== BEGIN JS ====
dovetail.query('people', {}, {map:'getJobFunction',
reduce:'mergeFunctions'}, function(functions) {
for(var f in functions) {
// will iterate only once for each distinct value
}
});
==== END JS ====
Hope this helps!
Phil
On Jun 2, 12:56 pm, Peter De Keer <peter.de.k...@gmail.com> wrote:
> I know I'm asking questions not only needed for dovetail, but how
> could I do this?
> SQL SELECT DISTINCT function FROM Jobs
