Product: Aqua Data Studio

Version: 19.0.0-dev-7

Build #: 53703

Build Date: 2017-Mar-26 09:15:36 PM

 

Operating Environment: Linux (4.4.0-42-generic, amd64) / UTF-8 / en / US / Oracle Corporation 1.8.0_102-b14

Memory: Max=704,643,072; Total=362,283,008; Free=202,288,600; CPUs=8

 

Steps to Reproduce:-

1. Launch ADS

2. Connect SQL Server 2012

3. Expand Database tree node.

4. Right click on table node and Select Query Analyzer.

5. In Query Analyzer Execute below scripts.

 

CREATE TABLE [dbo].[Employees]  ( 
        [Id]            int NOT NULL,
        [Name]          varchar(25) NOT NULL,
        [Phone_no.]     int NOT NULL,
        [Location]      varchar(25) NOT NULL 
        )


INSERT INTO [dbo].[Employees]([Id], [Name], [Phone_no.], [Location]) 
   VALUES(1, 'Naresh', 97901, 'PUNE')
GO
INSERT INTO [dbo].[Employees]([Id], [Name], [Phone_no.], [Location]) 
   VALUES(3, 'Vaibhav', 23901, 'PUNE')
GO
INSERT INTO [dbo].[Employees]([Id], [Name], [Phone_no.], [Location]) 
   VALUES(5, 'Aditi', 297901, 'MUMBAI')
GO
INSERT INTO [dbo].[Employees]([Id], [Name], [Phone_no.], [Location]) 
   VALUES(4, 'Abhishek', 97141, 'BANGLORE')
GO
INSERT INTO [dbo].[Employees]([Id], [Name], [Phone_no.], [Location]) 
   VALUES(2, 'Pranita', 57901, 'CHENNAI')
GO
Select * from dbo.Employees
GO

 

6. Go to Pivot Grid tab.

7. From Field List Window,

- Drag name to Drag Row Field here section.

- Drag id to Drag Column field here section.

8. Right click on name in Drag Row field here section and Select Ascending or Descending option.

 

Result:-

Column Field values and Row Field values are not getting sorted.

 

Expected Result:- 

Column Field values and Row Field values should get sorted.

Observations:-

 

Behaviour in different ADS builds.	Behaviour of Ascending and Descending Sort.
	WINDOWS	UBUNTU	MAC
ADS 19 dev-7	Y	Y	Y
ADS v18	Y	Y	Y
ADS 17	Y	Y	Y
Y - Issue is Reproducible.
N - Issue is not reproducible.