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

Question

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

angelborroy · Accepted Answer

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.