Hello,

I have a product database (FMSA 11 + Lasso 9.x). I have a few ideas on how
to proceed, but am looking for guidance on the most efficient approach to
doing the following.

Query returns product information.
Using records_array I have created an array and distilled to unique elements
(manufactures) and sorted

I end up with:

Mfg A
Mfg B
Mfg C

which will end up being links to refine the query

I want to be able to quantify each... ie Mfg A (2), Mfg B(8), Mfg C (3) so
the the browser has and idea of the breakdown of the original dataset.

Seems to me, that if I was able to sort that original records_array by the
particular field on the table (I know I could do this in the inline, but
want that sort to be by relevance) I would do less looping of the dataset.

Is the approach to use records /records to create the one-dimensional array
from the records_array, sort the array, loop through the array to quantify
and make a unique element array?

I want to do this for a few other subcategories of the records_array as well
and so looking for the most efficient approach.

Any other approaches database/client-side would be appreciated.

Tom






--
View this message in context: http://lasso.2283332.n4.nabble.com/Post-processing-database-query-distill-quantify-subcategories-tp4635347.html
Sent from the Lasso - Talk mailing list archive at Nabble.com.
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso
Lasso@lists.lassosoft.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>