hibernate, criteria query, "could not resolve property"

Communities ColdBox HMVC
1

Here’s a CFC

component
entityname = “AccreMailTemplate”
persistent = “true”

table = “T_ACCRE_MAILTEMPLATE”
readonly = “false”
cachename = “userCache”
cacheuse = “transactional”
output = “false”
{
property name=“ACMA_KY” column=“ACMA_KY” type=“numeric” ormtype=“integer” fieldtype=“id” generator=“sequence” params="{sequence=‘T_ACCRE_MAILTEMPLATE_SEQ’}";
property name=“MAIL_TEMPLATE_DS” column=“MAIL_TEMPLATE_DS” type=“string” ormtype=“string”;
property name=“ACMA_SUBJECT_LB” column=“ACMA_SUBJECT_LB” type=“string” ormtype=“string”;
property name=“TITLE_LB” column=“TITLE_LB” type=“string” ormtype=“string”;

property name=“ACCR_DOMA_KY” fieldtype=“many-to-one” cfc=“Domain” fkcolumn=“ACCR_DOMA_KY”;

// Constructor
function init( ACMA_KY=0, ACCR_DOMA_KY=entitynew(‘Domain’), MAIL_TEMPLATE_DS=""){

if (arguments.ACMA_KY gt 0) {
setACMA_KY(arguments.ACMA_KY);
}else{
setACMA_KY(javacast(‘NULL’, ‘’));
}
setACCR_DOMA_KY(arguments.ACCR_DOMA_KY);
setMAIL_TEMPLATE_DS(arguments.MAIL_TEMPLATE_DS);

return this;
}
}

And here’s some code:

var c2 = AccreMailTemplateService.newCriteria();

prc.arrTemplates = c2
.withProjections(property = ‘ACMA_KY, TITLE_LB’)
.order(‘ACMA_KY’,‘asc’,true)
.list();

Why do I get this error?

could not resolve property: TITLE_LB of: AccreMailTemplate.

(And I get the same error if I try to get ANY of the fields apart from ACMA_KY).

2

Solved.

I removed the space between the two fields!

.withProjections(property = ‘ACMA_KY,TITLE_LB’)

Who would have thought it…