[mapguide-users] Mix of selectfeature and selectaggregate query

[Jo Cook]

Dear All,

I have a layer of postcodes, which has more than one point per postcode (eg
all the houses with that postcode). I would like people to be able to do a
"fuzzy selection" to choose their postcode, eg "RM14" returns all the
postcodes with RM14 at the beginning. I would then like the results of this
to be grouped and listed, so that only one entry per postcode is given.
People should then be able to select that postcode, and zoom in to the total
spatial extent of all the points with that postcode. I hope that makes
sense!

I have implemented the initial selection using SelectFeature with the
appropriate queryoption, so the fuzzy search works and returns multiple
values. However, I can't figure out whether I can rewrite this using
SelectAggregate and the same queryoption as the documentation only seems to
talk about a groupingfilter and I'm not sure that's what I want.

I'm then wondering if I can either convert the results returned from the
SelectFeature query into a list of unique values directly in php, or whether
I can do a SelectAggregate query on the results, or if indeed there's a much
better way that I'm missing!

If someone could talk me through the basic steps, I'd be very grateful- it's
hard for me to copy code over as I'm working in a chain of windows remote
desktop servers that don't allow copy and paste.

Thanks

Jo
-- 
View this message in context: http://n2.nabble.com/Mix-of-selectfeature-and-selectaggregate-query-tp4176453p4176453.html
Sent from the MapGuide Users mailing list archive at Nabble.com.