NAME
RT-Extension-AssetSQL - SQL search builder for Assets
INSTALLATION
RT-Extension-AssetSQL requires version RT 4.4.0 or later. Note that
AssetSQL is incompatible with RT 4.2 running RT::Extension::Assets.
perl Makefile.PL
make
make install
This step may require root permissions.
Patch your RT
AssetSQL requires a patch for your RT instance. The specific patch
to apply depends on which version of RT you're running.
If you're on RT 4.4.0, use rt-4.4.0.patch:
patch -d /opt/rt4 -p1 < patches/rt-4.4.0.patch
If you're on RT 4.4.1, use rt-4.4.1.patch:
patch -d /opt/rt4 -p1 < patches/rt-4.4.1.patch
If you're on RT 4.4.2 or later, use rt-4.4.2-later.patch:
patch -d /opt/rt4 -p1 < patches/rt-4.4.2-later.patch
Edit your /opt/rt4/etc/RT_SiteConfig.pm
Add this line:
Plugin( "RT::Extension::AssetSQL" );
If you wish to hide the legacy Asset Simple Search, add the
following line as well:
Set($AssetSQL_HideSimpleSearch, 1);
Clear your mason cache
rm -rf /opt/rt4/var/mason_data/obj
Restart your webserver
METHODS
ProcessAssetSearchFormatConfig
Process the $AssetSearchFormat configuration value.
AssetSQL uses the search formats defined via $AssetSearchFormat to
format search results. This option accepts one format to use for all
assets or a hashref with formats defined per catalog. This function
processes the configuration option and returns the appropriate format.
For the hashref version, AssetSQL looks only for the key
AssetSearchFormat for the default search format. To customize the format
of the search results for individual searches, use the Advanced tab in
the Query Builder.
See RT's documentation for $AssetSearchFormat in RT_Config.pm for
details on setting the search format.
Returns: string with a search format
AUTHOR
Best Practical Solutions, LLC <modules@bestpractical.com>
BUGS
All bugs should be reported via email to
L<bug-RT-Extension-AssetSQL@rt.cpan.org|mailto:bug-RT-Extension-AssetSQL@rt.cpan.org>
or via the web at
L<rt.cpan.org|http://rt.cpan.org/Public/Dist/Display.html?Name=RT-Extension-AssetSQL>.
COPYRIGHT
This extension is Copyright (C) 2016 Best Practical Solutions, LLC.
This is free software, licensed under:
The GNU General Public License, Version 2, June 1991