You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@openmeetings.apache.org by Daniel Baker <in...@collisiondetection.biz> on 2020/12/25 14:02:18 UTC

orderby - orderby clause

How can I use the  orderby  parameter ?



https://openmeetings.apache.org/openmeetings-webservice/apidocs/org/apache/openmeetings/webservice/GroupWebService.html#getUsers(java.lang.String,long,int,int,java.lang.String,boolean)





Parameters:
    |sid|- The SID from getSession
    |id|- the group id
    |start|- first record
    |max|- max records
    *|orderby|****- orderby clause*
    |asc|- asc or desc


Thanks,

Dan

Re: orderby - orderby clause

Posted by Daniel Baker <in...@collisiondetection.biz>.

Thanks  that  worked  great.


On 25-Dec-20 7:22 PM, seba.wagner@gmail.com wrote:
> Potentially
> "user.firstname" or any of the other user attributes conceited with 
> the "user." may work for this string.
>
> See: 
> https://github.com/apache/openmeetings/blob/79939f1886f5f80c6aab1d6cf01c1adb550d4ff0/openmeetings-db/src/main/java/org/apache/openmeetings/db/util/DaoHelper.java#L112 
> <https://github.com/apache/openmeetings/blob/79939f1886f5f80c6aab1d6cf01c1adb550d4ff0/openmeetings-db/src/main/java/org/apache/openmeetings/db/util/DaoHelper.java#L112>
>
> The object you fetching is GroupUser:
> https://github.com/apache/openmeetings/blob/79939f1886f5f80c6aab1d6cf01c1adb550d4ff0/openmeetings-db/src/main/java/org/apache/openmeetings/db/entity/user/GroupUser.java#L51 
> <https://github.com/apache/openmeetings/blob/79939f1886f5f80c6aab1d6cf01c1adb550d4ff0/openmeetings-db/src/main/java/org/apache/openmeetings/db/entity/user/GroupUser.java#L51>
>
> Thanks
> Seb
>
> Sebastian Wagner
> Director Arrakeen Solutions
> http://arrakeen-solutions.co.nz/ <http://arrakeen-solutions.co.nz/>
> <https://www.youracclaim.com/badges/da4e8828-743d-4968-af6f-49033f10d60a/public_url><https://www.youracclaim.com/badges/b7e709c6-aa87-4b02-9faf-099038475e36/public_url>
>
>
> On Sat, 26 Dec 2020 at 03:03, Daniel Baker 
> <info@collisiondetection.biz <ma...@collisiondetection.biz>> wrote:
>
>     How can I use the  orderby  parameter ?
>
>
>
>     https://openmeetings.apache.org/openmeetings-webservice/apidocs/org/apache/openmeetings/webservice/GroupWebService.html#getUsers(java.lang.String,long,int,int,java.lang.String,boolean)
>     <https://openmeetings.apache.org/openmeetings-webservice/apidocs/org/apache/openmeetings/webservice/GroupWebService.html#getUsers(java.lang.String,long,int,int,java.lang.String,boolean)>
>
>
>
>
>
>     Parameters:
>         |sid|- The SID from getSession
>         |id|- the group id
>         |start|- first record
>         |max|- max records
>         *|orderby|****- orderby clause*
>         |asc|- asc or desc
>
>
>     Thanks,
>
>     Dan
>

Re: orderby - orderby clause

Posted by "seba.wagner@gmail.com" <se...@gmail.com>.

Potentially
"user.firstname" or any of the other user attributes conceited with the
"user." may work for this string.

See:
https://github.com/apache/openmeetings/blob/79939f1886f5f80c6aab1d6cf01c1adb550d4ff0/openmeetings-db/src/main/java/org/apache/openmeetings/db/util/DaoHelper.java#L112

The object you fetching is GroupUser:
https://github.com/apache/openmeetings/blob/79939f1886f5f80c6aab1d6cf01c1adb550d4ff0/openmeetings-db/src/main/java/org/apache/openmeetings/db/entity/user/GroupUser.java#L51

Thanks
Seb

Sebastian Wagner
Director Arrakeen Solutions
http://arrakeen-solutions.co.nz/
<https://www.youracclaim.com/badges/da4e8828-743d-4968-af6f-49033f10d60a/public_url>
<https://www.youracclaim.com/badges/b7e709c6-aa87-4b02-9faf-099038475e36/public_url>


On Sat, 26 Dec 2020 at 03:03, Daniel Baker <in...@collisiondetection.biz>
wrote:

> How can I use the  orderby  parameter ?
>
>
>
>
> https://openmeetings.apache.org/openmeetings-webservice/apidocs/org/apache/openmeetings/webservice/GroupWebService.html#getUsers(java.lang.String,long,int,int,java.lang.String,boolean)
>
>
>
>
>
> Parameters:sid - The SID from getSessionid - the group idstart - first recordmax - max records*orderby* *- orderby clause*asc - asc or desc
>
>
> Thanks,
>
> Dan
>