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 Field Settings.

9. In Field settings dialog box, Go to Filter Setting section and Enable Filter checkbox.

10. In Filter on field dropdown select any field from dropdown and Go to condition dropdown and select ‘is’.

11. A value dropdown will be available. Click on the dropdown.

 

Result:-

You will observe that no values are present in dropdown.

 

Expected Result:-

Values should get displayed for Field selected in Filter on Field dropdown.

 

Observations:-

 

Behaviour in different ADS builds.	Behaviour of Condition dropdown in Filter Field section
	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.