[xwiki-users] 1.2rc1 - getting a list of users ("Firstname Lastname" format)

[Esbach, Brandon]

Hi all,

In most of my tools, a user selection dropdown is used to allow someone
to be picked as a "owner" of a task, or assignement, etc.  With a large
volume of users (often with same first names), I can't use either login
name (which is based on our network login); or the user's first name
alone.
Since 1.0, I've been making use of the following query (in a db list):
select firstname.value || ' ' || lastname.value from BaseObject obj,
StringProperty firstname, StringProperty lastname where
obj.className='XWiki.XWikiUsers' and firstname.id.id=obj.id and
lastname.id.id=obj.id and firstname.name='first_name' and
lastname.name='last_name' order by firstname.value

The "|| '' ||" option joins up firstname.value and lastname.value fairly
neatly, so people can select the correct person...

In 1.2rc1 it does not return users at all.  Is this something that's
been locked down on 1.2rc1?
Brandon Esbach
Software Engineer
Wireless Systems Segment 
Tyco Electronics 
4 Eastgate Road 
Eastgate 
Little Island 
Co. Cork 
Ireland 
Tel: +353-21-4808305 
Email: esbachb at tycoelectronics.com 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.xwiki.org/pipermail/users/attachments/20071218/aae932b4/attachment.htm