[rt-users] User custom fields .... pretty please and what sweat you wish on top

[Roy El-Hames]

Re submitting my query cause I really need help with this ..
How to get User custom fields visible from Preferences and Admin/Users
Roy
 
Roy El-Hames wrote:
> Hi;
> RT-3.6.1, Apache2,mod_perl
> Anyone using User custom fields and its working for them ?? I created 
> a user custom field and I can't see it from either 
> Configuration/Users/Username
> or from User/Prefs
> I applied Todd Chapman's patch 
> (http://rt3.fsck.com/Ticket/Display.html?id=7880) , but that just 
> given me the wigdet (Custom Fields), and nothing in it ..
>
> Looking at the sql generated :
> SELECT DISTINCT main.* FROM CustomFields main , ObjectCustomFields 
> ObjectCustomFields_1  WHERE ((ObjectCustomFields_1.ObjectId = '103') 
> OR (ObjectCustomFields_1.ObjectId = '0')) AND ((main.Disabled = '0')) 
> AND ((main.LookupType = 'RT::User')) AND ((main.id = 
> ObjectCustomFields_1.CustomField))  ORDER BY 
> ObjectCustomFields_1.ObjectId ASC, ObjectCustomFields_1.SortOrder ASC ;
>
> It fails because there nothing for main.id = 
> ObjectCustomFields_1.CustomField
> Is the bug when a custom field is created or is it on pulling the 
> custom fields?? or is there something screwed with my RT ??
> Thanks;
> Roy
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>