[SOLVED] Order a list with a Query result

Hello,

I have a "query field" (webcam status), that gives the result:
- 0 (if webcam is off)
- 1 (if webcam is on)

Now I would like to make a userlist, that shows first, the users with "webcam on".

But I can not do it because the "query field", cant be used in lists.
Is it a possible solution for this?

You can't, it's a calculated field and no value actually exists in database for it to add to the userlist query.

:S

It is a big problem to me, because my community shows webcams.

You'll need to either have 2 userlists, 1 for cams on and 1 for cams off as you could add your query as a filter or you'll need to develop a plugin to alter the userlist query and add whatever sorting/filtering you need/want.

as you could add your query as a filter

How can I add a query as filter?

The field "cb_oncam" is not in the filter list...
I have try to make an advance filter:

`cb_oncam` IS NOT NULL

but it doesnt work.

You'll need to do an Advanced filter and adjust the query from there. Please search as several examples can be found on the forums as well as in your documentation; I don't know your database tables or anything of the sort so I can't help you in that regard.