Search in Groups and People

[pdovhomilja]

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

[angelborroy]

Is Java API an option?

http://dev.alfresco.com/resource/AlfrescoOne/5.1/PublicAPI/org/alfresco/service/cmr/security/Authori...)

[pdovhomilja]

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

[angelborroy]

You can try then something like this:

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

[pdovhomilja]

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

[angelborroy · Accepted solution]

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.