RE: How to find all Authors that have a specific al-a-carte permission.

Communities ContentBox CMS
1

BINGO!!! I got it!

team = arrayNew(1);

authorSvc = controller.getWireBox().getInstance(“AuthorService@cb”);

rows = authorSvc.executeQuery(query=“from cbAuthor as a INNER JOIN a.permissions as p where p.permission=‘HBG_TEAM’”,asQuery=false);

for(row in rows){

arrayAppend(team,row[1]);

}

Note that the loop of rows in rows.

The query returned an array which contained a sub array with two objects

–Array

–Array

–Author

–Permission

Thus I stored it in a new array called Team.

Hope this helps someone at some point J

2

Marco–

If you want a result similar to what you get from list(), you might try using a Criteria Builder query. Here is some untested code, but should show the general approach:

var c = **authorSvc.newCriteria();**
var permUsers = c.createAlias("permissions","perms", criteria.LEFT_JOIN )
     .eq("perms.permission","HBG_TEAM")
     .list();
3

And you make it look so easy! LOL … Muy Bein!

Thanks!

Marco G. Williams

Information Technology Manager

Global Electronic Technology

949.380.0345 x209

4

Btw – thanks this worked like a charm!

Marco G. Williams

Information Technology Manager

Global Electronic Technology

949.380.0345 x209

5

Sure thing, glad it was helpful!

6

Also, Brad did several performance tests on ORM and using for some reason ORMExecuteQuery was really really slow in comparison to Criteria Queries.

7

I was going to say where is your joins.

8

And I have done test to show that it is the other way around.

http://www.andyscott.id.au/blog/coldfusion-orm-and-things-one-should-consider-and-is-criteria-building-a-good-option

This test I have performed on 35 clients and all show the same results in production.

9

And if anyone wishes to test this with their ContentBox installation, login into their dashboard remotely from their production server. If the dashboard takes more than 1-2 secs to load then you suffer the same experience. There are other ways to tell with ContentBox from the actual user side as well.

So far every ContentBox installation people are using for their blogs have this issue. I have had System Administrator and DB administrators look into this issue for the last 2 years and the results are always the same.

10

If anyone wishes to see the tests live on a server.

http://www.andyscott.id.au/facebook