[rt-users] How to use RT::CustomFieldValues::External

[Ruslan Zakirov]

Hi,

Start from CustomFieldValuesSources config option. Read docs in
lib/RT/CustomFieldValues/External.pm and use
lib/RT/CustomFieldValues/External/Groups.pm as example. However
connecting to MS SQL server on *nix is kinda tricky, so I would
recommend you to use something in between, for example a file where
you dump values and then read it from RT. Or just write a script that
will keep values at sync and run it periodically and don't use CFs
with external source at all.

The latter is preferred in terms of performance. The only reason is to
use external source is if external source changed very often and you
can not allow it to be out of sync even for a minute.

On Tue, Oct 19, 2010 at 10:16 PM, Ahmed, Mohammed Naweed (LNG-BCT)
<naweedmohammed.ahmed at lexisnexis.com> wrote:
> I have a list of values in a external data (SQL Server) and I want to
> display them in a custom field as a drop down.
>
>
>
> I was searching for the solution and found that
> RT::CustomFieldValues::External can be used for it. But not sure where to
> specify the data source. Can somebody please send me an example of how to
> use this extention?
>
>
>
> Thanks
>
> Naweed
>
>
>
> ________________________________
>
> The information contained in this e-mail message is intended only for the
> personal and confidential use of the recipient(s) named above. This message
> may be an attorney-client communication and/or work product and as such is
> privileged and confidential. If the reader of this message is not the
> intended recipient or an agent responsible for delivering it to the intended
> recipient, you are hereby notified that you have received this document in
> error and that any review, dissemination, distribution, or copying of this
> message is strictly prohibited. If you have received this communication in
> error, please notify us immediately by e-mail, and delete the original
> message.



-- 
Best regards, Ruslan.