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 BUGS All bugs should be reported via email to L or via the web at L. 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