Forum Discussion

keithkelly's avatar
keithkelly
Leader
2 years ago

Select messages where user *doesn't have* FooBar role?

Objective:  Create message list of messages posted by non-employees.  SELECT yada, yoda FROM messages WHERE depth = 0 ** AND USER DOESN'T HAVE EMPLOYEE ROLE ** ORDER BY conversation.last_post...
REST API v2 & LiQL
Roles & Permissions
Akenefick's avatar
Akenefick
Genius
2 years ago

Hi keithkelly. I tried to do something similar and was told it wasn't possible. Re: Can You Get Author Roles From A Messages Subqu... - Atlas (khoros.com)

I ended up using rank to exclude employees, because luckily you can get author.rank as a field for a message and we happen to have employee specific ranks. I still don't think you can use that as a constraint. Under constraints all I see are author.id and author.login. It might be worth a try though.