Problem Note 39808: Searching returns no results if SAS Folders is the starting location in SAS® Web Report Studio
SAS Web Report Studio enables you to search by the name, description, and keywords for a report or folder in the Open Report dialog box or Manage Files window. However, when SAS Folders is selected as both the Search where value and the Location, then searching fails with the following message:
Search is complete. There are no results to display.
You can search SAS Folders by leaving the Search where value as SAS Folders, but changing the Location to any folder other than SAS Folders. However, this workaround only returns results once. If you click Search again, no results are returned. In addition, if you have, for example, thousands of reports in your SAS Folders tree, then your metadata server might stop responding.
As a best practice, do not select SAS Folders as the Search where value.
Click the Hot Fix tab in this note to access the hot fix for this issue. After the hot fix is applied, matching results—if any exist— are returned even when SAS Folders is selected as both the Search where value and the Location.
Note: The starting point for the search is based on the Search where value. So, if your Search where value is a higher level than the Location, your results might include matches outside of the specified location. As a best practice, your Location should match your Search where value.
Operating System and Release Information
| SAS System | SAS Web Report Studio | z/OS | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Microsoft® Windows® for x64 | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Standard Edition | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Microsoft Windows Server 2003 for x64 | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Microsoft Windows Server 2008 | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Microsoft Windows Server 2008 for x64 | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Microsoft Windows XP Professional | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows 7 Enterprise 32 bit | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows 7 Enterprise x64 | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows 7 Home Premium 32 bit | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows 7 Home Premium x64 | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows 7 Professional 32 bit | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows 7 Professional x64 | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows 7 Ultimate 32 bit | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows 7 Ultimate x64 | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows Vista | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Windows Vista for x64 | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| 64-bit Enabled AIX | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| 64-bit Enabled Solaris | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| HP-UX IPF | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Linux for x64 | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
| Solaris for x64 | 4.2_M2 | 4.31_M2 | 9.2 TS2M3 | 9.3 TS1M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Query and Reporting
|
| Date Modified: | 2010-06-07 14:52:45 |
| Date Created: | 2010-05-27 13:15:46 |
