User Field Template Variable

Hi All,

Can a template variable (list box or check box) be scripted to output the "Full Name" field of all users (either within a group or just all users). I would like one admin to be able to assign resources (articles) to selected users. I can do it statically via a check box or list box but if the client ever deletes or adds new users the TV would have to be edited as well.

I'm running Modx 2.2.6 (traditional) - PHP-5

Thanks,

R

I've never tried it, but this might work:



I'm not sure if the modx_ prefix should be there or not.

BobRay,

@SELECT id, username FROM modx_users, works! It pulls the user number which I can convert into the full name via a chunk.

as always, thanks.

R

I really didn't think it would work.

Thanks for reporting back.

If you want to create a drop down TV of all of your user's Full names use -

@SELECT fullname, fullname FROM modx_user_attributes

in Input Option Values.

Thanks all for the help.