topic How to search for all not disabled users with a CMIS query in Alfresco Forum

How to search for all not disabled users with a CMIS query

idebonis — Wed, 08 Dec 2021 01:03:14 GMT

Today I come again to ask for help.

I need to filter out all the disabled users. So far I got this CMIS query to get the ID from every user:

"SELECT cmis:objectId FROM cm:person WHERE cm:homeFolderProvider = 'userHomesHomeFolderProvider' "

Then, I got this query to get the ID from every disabled user:

"SELECT cmis:objectId FROM cm:personDisabled"

So, to filter out all the disabled users, I query:

"SELECT cmis:objectId FROM cm:person WHERE cmis:objectID NOT IN (SELECT cmis:objectId FROM cm:personDisabled)"

But the software runs into an error. I'm testing this with cmislib3 for python, the node browser inside alfresco and want to develop a javascript webscript to send mails to every active user.

I hope you can help me with this question.

Best regards,

Ignacio

Re: How to search for all not disabled users with a CMIS query

angelborroy — Mon, 13 Dec 2021 09:53:39 GMT

I guess you need some code at this point, since the information can't be retrieved using a single SQL Query.

You need to perform 2 queries and filter out the disabled users.

Re: How to search for all not disabled users with a CMIS query

idebonis — Tue, 14 Dec 2021 04:37:01 GMT

Thanks, I had already resigned myself to this solution. I guess it is out of the CMIS boundaries.