the 'Sort by Name' or 'Title' is not working in the ERDAS Apollo 2016 Core Console.
The log file contains entries like this:
2017-06-27 10:25:32:623 [139640258426624] ERROR com.erdas.iws.database - GetChildVirtualDatasets Query::prepare of query 'SELECT FullName, VirtualMosaicZIndex FROM Folder WHERE ParentFolderID=34 UNION SELECT FullName, VirtualMosaicZIndex FROM Dataset WHERE FolderID=34 ORDER BY CapabilitiesTitle DESC' failed. Details: ERROR: column "capabilitiestitle" does not exist
LINE 1: ...aicZIndex FROM Dataset WHERE FolderID=34 ORDER BY Capabiliti...
^
(42703) QPSQL: Unable to prepare statement
2017-06-27 10:25:45:080 [139640258426624] ERROR com.erdas.iws.database - GetChildVirtualDatasets Query::prepare of query 'SELECT FullName, VirtualMosaicZIndex FROM Folder WHERE ParentFolderID=34 UNION SELECT FullName, VirtualMosaicZIndex FROM Dataset WHERE FolderID=34 ORDER BY CapabilitiesName DESC' failed. Details: ERROR: column "capabilitiesname" does not exist
LINE 1: ...aicZIndex FROM Dataset WHERE FolderID=34 ORDER BY Capabiliti...
^
(42703) QPSQL: Unable to prepare statement
I tried to add capabilitiestitle and capabilitiesname columns with the values of capstitle and capsname to the dataset table but that ony resulted in warnings like:
2017-06-27 10:25:22:254 [139640258426624] WARN com.erdas.iws.database - Load Found unknown field 'capabilitiestitle'.
2017-06-27 10:25:22:254 [139640258426624] WARN com.erdas.iws.database - Load Found unknown field 'capabilitiesname'.
so to me it looks like com.erdas.iws.database needs to be updated with the current column names. Does anyone have a workaround for this?
