<query name="getAllUsers">
select id, firstName, lastName from User where active = true order by lastName, firstName
</query>
<query name="getAllUsers">
select id, firstName, lastName from User where active = true order by lastName, firstName
</query>