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

Reply via email to