[rt-users] Custom field values from external DB

[Wes Young]

Do you need realtime updates? or can you use an action and the "rt-cron" 
tool to batch update the CF's.

I do something similar for syncing RT to ARS (Remedy).

The cron tool uses a custom search, run's the tickets through some 
conditions and then uses the "SyncARS.pm" action to pull down the new 
field values from ARS. Might be a better approach as to not put more 
connection load on the external databases.

Yitzchak Schaffer wrote:
> Greetings:
> 
> Has anyone added custom fields where the choices are taken from a query 
> against an outside database, perhaps by modifying the RT code?  I didn't 
> see anything about this in the docs, and it didn't seem like "Include 
> page" in the CF modification screen would be able to achieve this.  If 
> not, where should I look in the source code - 
> share/html/Elements/EditCustomField seems like a good starting spot.
> 
> Thank you very much,
> -- 
> Yitzchak Schaffer
> Systems Librarian
> Touro College Libraries
> 33 West 23rd Street
> New York, NY 10010
> Tel (212) 463-0400 x230
> Fax (212) 627-3197
> yitzchas at touro.edu
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> 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