topic Re: Search in Groups and People in Alfresco Forum

Search in Groups and People

pdovhomilja — Mon, 06 Apr 2020 11:34:21 GMT

Hello,

i would like to know, how can i search in groups an people at once? I need to search in groups and people and sort them alphabetically.

Thanks

Re: Search in Groups and People

angelborroy — Mon, 06 Apr 2020 11:56:59 GMT

Is Java API an option?

http://dev.alfresco.com/resource/AlfrescoOne/5.1/PublicAPI/org/alfresco/service/cmr/security/AuthorityService.html#findAuthorities(org.alfresco.service.cmr.security.AuthorityType,%20java.lang.String,%20boolean,%20java.lang.String,%20java.lang.String)

Re: Search in Groups and People

pdovhomilja — Mon, 06 Apr 2020 12:29:09 GMT

I don't think so, we are using only Rest API by own backend writen in .NET Core and frontend writen in ReactJS.

Re: Search in Groups and People

angelborroy — Mon, 06 Apr 2020 12:40:03 GMT

You can try then something like this:

{
  "query": {
    "query": "select * from cm:authority",
    "language": "cmis"
  }
}

Re: Search in Groups and People

pdovhomilja — Mon, 06 Apr 2020 13:27:51 GMT

This is working and can you please help me with WHERE condition? How can i search all groups and users starting with "ma"? Thank you

Re: Search in Groups and People

angelborroy — Mon, 06 Apr 2020 14:15:20 GMT

I guess you can't do this in a single REST invocation.

You need to filter groups in the first step...

{
  "query": {
    "query": "SELECT * FROM cm:authorityContainer WHERE cm:authorityName like 'GROUP_ma%'",
    "language": "cmis"
  },
  "include": "properties"
}

... and to filter users later.

{
  "query": {
    "query": "SELECT * FROM cm:person WHERE cm:userName like 'ma%'",
    "language": "cmis"
  },
  "include": "properties"
}

So you can merge the lists in your UI.