Problem Note 62976: The search results sorting order by newest or oldest in SASĀ® Visual Investigator is incorrect
The _createtime field is not indexed for a search in SAS Visual Investigator. This field is used to create the data for the search result option Date created (newest first).
Because the field is ignored, all external entities, no matter which creation date they have, appear at the end of the search results.
The issue occurs only in a search result that contains a mixture of internal and external entities. It does not occur when you view a search result that contains only external entities.
To work around this problem, take these actions:
- Switch the search results view to the Table view.
- Filter the search to show only Alerts.
- In the Sort results drop-down menu, choose Date created (newest first).
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Verify That the Update Is Installed
To verify that the fix is installed, run the following rpm command:
rpm -qa | grep sas-svi-visual-investigator-7.1.56
To complete this process, make sure that the package version that is shown in the rpm output either matches or is newer than 7.1.56 with the following command:
rpm -qi sas-svi-visual-investigator
Additional Assistance
If you need additional assistance, contact SAS Technical Support.
Operating System and Release Information
SAS System | SAS Visual Investigator | Linux for x64 | 10.4 | 10.5 | Viya | Viya |
*
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 |
Date Modified: | 2019-07-23 12:53:14 |
Date Created: | 2018-09-24 13:00:38 |