Problem in Constructor Expressions

[Gowher Naik]

select NEW org.UserDto(distinct(orgreg.contactNumber)) from OrganisationRegistration orgreg

Hi
The above query throws runtime exception due to distinct keyword.

Is there any solution available.

Thanks

[James Sutherland]

DISTINCT only applies to the entire query (the only exception is its usage with an aggregate function).

Select distinct NEW org.UserDto(orgreg.contactNumber) from OrganisationRegistration orgreg