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


Reply via email to