hi all.
i'm attempting to grab up a swath of data based on some parameters that i'm
finding difficult to express in a query:
- i'd like to get all the data from a purchasing group (simple fq on
their ids)
- where items are grouped on one (or one of a few) unique identifiers
(grouping? complex faceting?)
- use either function fields or stats data to perform a calculation used
to order them.
- the specific data i'm looking for is the disparity in highest and
lowest pricing in any group members per item, ordered by highest
disparity
to lowest
- limit to 100 rows so i can show them their biggest offenders
those two middle points are the rub, of course. i'm hoping to use solr's
capabilities to cut out a middleman of server side processing to loop
through all the data of a given purchasing group, get results specific to
each purchase, and then determine what's what. i may be asking too much
from solr, though.
i certainly don't want a query for an answer here, not looking for a
handout, but would love to walk through towards a solution if it is indeed
possible to satisfy the above reqs.
thanks for any thoughts!
--
*John Blythe*
