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.
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@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.