On Mon, 2014-08-11 at 09:44 +0200, Lisheng Zhang wrote: [...]
> But tough part is that we may need to sort files according to such flag, > for each user (I should have mentioned in last mail). My solution is to add > many fields to file document, like > > user1_status, user2_status, user3_status // value can be important or > unimportant > > then I can sort files according to each user's accessment. Flip assessment and user name: status:important_user1 status:unimportant_user2 status:customflag_user1 status:anothercustomflag_user2 That way sorting will work. Unfortunately there will be no re-use of the filter cache between users, so you might want to disable filter caching. If you also need to be able to filter on which documents a user has assessed, then add a second field for that assessed_by:user1 assessed_by:user2 > My concern is that with too many fields it would not scale well ? I have successfully experimented with 10.000 fields, but I doubt that it will work with millions. - Toke Eskildsen, State and University Library, Denmark