#15104: Sort order and icons of the objects should match in Referenced by folder also.

narendravatsaraj(*) reported 2017-03-27T09:59:24Z · last modified 2017-03-31T04:31:03Z

Sort order and icons of the objects should match in Referenced by folder also.

Dev	ivangron
QA	tariqrahiman

Priority	Minor
Complexity	Unknown

Component	App - Schema Browser
Version	18.0

Version: 19.0.0-dev-5

Build #: 53676

Build Date: 2017-Mar-23 09:10:38 PM

Operating Environment: Windows 8.1 (6.3, amd64) / Cp1252 / en / IN / Oracle Corporation 1.8.0_121-b13

Memory: Max=704,643,072; Total=509,083,648; Free=283,954,904; CPUs=8

1.Launch ADS.
2. Connect to SQL Server 2014.
3.Execute below queries.

CREATE TABLE "dbo"."TrackingItem"  ( 
   "Id"       int IDENTITY(1,1) NOT NULL,
   "Issued"   date NOT NULL,
   "Category" int NOT NULL 
   )
GO

CREATE FUNCTION "dbo"."TrackingItemsModified"(@minId int)
RETURNS @trackingItems TABLE (
  Id       int      NOT NULL,
  Issued   date     NOT NULL,
  Category int      NOT NULL,
  Modified datetime NULL
)
AS
BEGIN
  INSERT INTO @trackingItems (Id, Issued, Category)
  SELECT ti.Id, ti.Issued, ti.Category
  FROM   TrackingItem ti
  WHERE  ti.Id >= @minId;
 
  UPDATE @trackingItems
  SET Category = Category + 1,
      Modified = GETDATE()
  WHERE Category%2 = 0;
  RETURN;
END
GO

CREATE NONCLUSTERED INDEX "X_TrackingItem_Issued"
   ON "dbo"."TrackingItem"("Issued")
GO

4.Table , Function and Index generated successfully.
5.Open Table Properties UI of created table, Observe Objects listed in Dependencies tab.
6.Now go to schema browser, expand tree node of created table, go up to Dependencies -> Referenced By folder, Observe Objects listed here.
7.If we compare Object list of Dependencies tab and Referenced By folder,

Actual Result :
1.Here we can see , Sort Order is not same in Referenced By folder.
2.Icons in Referenced By folder are also not identical, we should see same icons as we display in dependencies tab.

3 attachments

15067_icon.png

2017-03-27T10:01:59Z

63 KB
db2_icon.png

2017-03-27T12:50:17Z

49 KB
Verified_15104.png

2017-03-30T05:55:28Z

85 KB

All Comments (4) Change History

narendravatsaraj(*) 2017-03-27T12:50:04Z

Icons scenario is reproducible on DB2 LUW also.(refer: Db2_icon.png)

Compare icons in Referenced by folder and Dependencies tab of Table Properties UI.

CREATE TABLE "SampleTable"  ( 
   c1 VARCHAR(25) 
   )
GO

CREATE VIEW "SampleView"
AS 
SELECT * FROM "SampleTable"
GO


CREATE INDEX "SampleIndex"
   ON "SampleTable"(c1 ASC)
GO

Icons scenario is reproducible on DB2 LUW also.(refer: Db2_icon.png)

Compare icons in Referenced by folder and Dependencies tab of Table Properties UI.

CREATE TABLE "SampleTable"  ( 
   c1 VARCHAR(25) 
   )
GO

CREATE VIEW "SampleView"
AS 
SELECT * FROM "SampleTable"
GO


CREATE INDEX "SampleIndex"
   ON "SampleTable"(c1 ASC)
GO

ivangron 2017-03-29T14:10:28Z

I have made enhancements to the sql server dependencies and referenced by schema tree nodes to better determine the object type. The dependencies model in the object properties gui is not going to always match the icon of the object in the tree node. The sort order is also not going to be done in the same way.

Committed revision: 53755

@Tariq: If you need an explanation in order to communicate that the schema tree node icons and sort order will not always match the GUI icons and sort orders please schedule a hang out with me.

narendravatsaraj(*) 2017-03-30T05:58:49Z · (edited)

I checked in ADS 18.0.6-4 and ADS 19 dev 10 build.
Icons are same as dependencies tab and Referenced By folder(Scenario mentioned in main issue description).

Refer Verified_15104.png

tariqrahiman 2017-03-31T04:31:03Z

Verified in ADS v18.0.6-5 and 19.0.0-dev-11

Search Tips

Aqua Data Studio / nhilam

Sort order and icons of the objects should match in Referenced by folder also.

3 attachments

Issue #15104

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Sort order and icons of the objects should match in Referenced by folder also.

3 attachments

Issue #15104

Completion