Hi.

Its greate to use the autocompletion in the assigne fields.
But somtetimes its bit hard to figure out, what user-id is the right user.

we use our company-user-ids as logins.
so for the autocompletion i will type "ad" => and it will display a list of all users of the department "ad".
e.g. "ad#1234", "ad#1235", "ad#1236"

But we dont know each user-id of each member. so it would be create to see something like this in autocompletion:
"ad#1234 - John Doe [uid:1]"

is this possible? :D
thx for the support

Comments

AlexisWilke’s picture

AlexisWilke commented
Title: Show the User-Name in autocompletion » Show the User-Name in auto-completion

Hi Ragesoft,

Where would you get the "John Doe" from?! At this time we do show the "users.name" field which... is expected to be "John Doe".

Thank you.
Alexis

ragesoft’s picture

ragesoft commented

i know!

but we use the "user name" field for our intern used user-numbers.
this is better for login, cuz each of our systems use this number!

i've added additional input-fields to the user-details:
given name
name
department
location

if you tell me, how to change the select, so that given-name and name are returned, i can fix it local for me ;)

the autocomplet musst search for both entries: user-name and given-name, name. so that if i type:

ad => it gives: ad#1234 John Doe

and if i type:
Joh => it gives: ad#1234 John Doe

:D
dono if this is possible and easy to make, but would be a great feature ;)

AlexisWilke’s picture

AlexisWilke commented

Did you use the Core Profile module to do that? If so, then the info is in that table. The SELECT will end up being specific to your naming of the "given name" entry.

profile_values will include the name and profile_fields the definition of the fields. If you hard code the fid, then you don't need to check profile_fields at all which makes it easier to write the SELECT.

Thank you.
Alexis Wilke

ragesoft’s picture

ragesoft commented

i used the core modul.

the fields look like "profile_givenname" and "profile_name"

:D
how to do this now with the select?

AlexisWilke’s picture

AlexisWilke commented

ragesoft,

First check the 'profile_fields' table and determine the 'fid' (a number).

Then you can get the data from 'profile_values' using that number. Something like this:

db_query("SELECT value FROM fid = 123 AND uid = %d", $uid);

You'll have to adapt the SELECT to your exact situation though. The uid will be the same as the users.uid field and that one we save in the To do list as well.

Thank you.
Alexis Wilke