// Get the max id using the formula attribute (note, requires SQL, not HQL)
property name="LAST_LIVE_ACCR_KY" setter="false" formula="
select max(peac.accr_ky)
from JOU_V_REV_PEACC peac
where peac.status_doma_ky in (27,28)
and peac.pers_ky = PERS_KY
";
// Set up the property
property name="last_live_request" persistent="false" default="";
// Load the required Accreditation using a custom function
function getlast_live_request() {
return entityLoadByPK("Accreditation", this.attr('LAST_LIVE_ACCR_KY'));
}
Not so pretty, but effective.
--
You received this message because you are subscribed to the Google Groups "cf-orm-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cf-orm-dev+...@googlegroups.com.
To post to this group, send email to cf-or...@googlegroups.com.
Visit this group at https://groups.google.com/group/cf-orm-dev.
For more options, visit https://groups.google.com/d/optout.