how to fire select query for specified column

[Nishant Chandrakar]

I have one domain class like employee(id, name,age,salary) and i want to get only name and salary.
If i tried with->

Employee.executeQuery(select e.name,e.salary from Employee e)
its giving error like property mismatch.

But if tried with->
Employee.executeQuery( from Employee e)
in this case Values are coming properly.

But my requirement is to get only few column not all column.
so please give me any solution for this problem

 

[prashant.kum]

try this
def lst=Employee.executeQuery("select new Map(e.name as name,e.salary as salary) from Employee e")
lst.each{
println it.name
}