Hi,
I'm looking for a tricky solution of a common problem. I have to handle
a lot of items and each could be member of several groups.
- "OK, just add a field called 'member_of'"
No that's not enough, because each group is sorted and each member has a
sortstring for this group.
- "OK, still easy add a dynamic field 'sortinfo_for_*' and fill this for
each group membership."
Yes, this works, but there are thousands of different groups, that much
dynamic fields are probably a serious performance issue.
- "Well ..."
I'm looking for a smart way to answer to the question "Find the members
of group X and sort them by the the sortstring for this group".
One idea I had was to fill the 'member_of' field with composed entrys
(groupname + "_" + sortstring). Finding the members is easy with
wildcards but there seems to be no way to use the sortstring as a
boostfactor
Has anybody solved this problem?
Any hints are welcome.
Uwe