Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
In version 17 and below the dependency node would also sometimes show objects that referenced the parent object. In version 18 we removed the referencing objects from the dependency node and so only actual dependencies would be listed. The referencing object extraction queries are already done in the extract dependencies class. We should enhance the schema tree node by adding a "Referenced By" folder for schema objects under the dependency node so that users could quickly access this information without having to open the object properties windows.
Oracle:
A new "Referenced By" folder has been created that will live under the "Dependencies" folder. This folder will contain the objects that reference this node object. Committed revision: 53584 & 53586
This has currently only been done for Oracle. I am checking this code in so we can build and test a to get the fix to customer. I will continue to work on this issue and add this same feature to SQL Server, Sybase ASE & DB2.
Committed revision: 53603, 53604. Build#: ADS 18.0.5-5
SQL Server: Complete : Committed revision : 53613 -- Build#: ADS 18.0.5-6
Sybase ASE : Complete : Committed revision: 53626 -- Build#: ADS 18.0.5-6
DB2 : Complete : Committed revision: 53644 -- Build#: ADS 18.0.5-7
Ivan: for Oracle, there is a mismatch in the number of objects being displayed in the Schema Tree node and in Table Properties. See attached screenshot. Also see the difference between ADS v17 and ADS v18
Ivan: for Oracle, there is a mismatch in the number of objects being displayed in the Schema Tree node and in Table Properties. See attached screenshot. Also see the difference between ADS v17 and ADS v18
In your screenshot, you will notice that there is an empty record line in the Dependencies model for the table properties. The model was not able to understand the package body object. I have added the package body object type to the model so that it will now correctly show. This affects all databases, though not all databases can create package body objects.
Committed revision: 53603, 53604. Build#: ADS 18.0.5-5
In your screenshot, you will notice that there is an empty record line in the Dependencies model for the table properties. The model was not able to understand the package body object. I have added the package body object type to the model so that it will now correctly show. This affects all databases, though not all databases can create package body objects.
Committed revision: 53603, 53604. Build#: ADS 18.0.5-5
This is now working in Oracle. The Dependencies node in schema tree is now back in ADS v18.0.5-5. See attached screenshot.
This is now working in Oracle. The Dependencies node in schema tree is now back in ADS v18.0.5-5. See attached screenshot.
Oracle, SQL Server, Sybase ASE & DB2 now have a "Referenced By" folder under the "Dependencies" folder that will show the user the objects that reference the parent object.
Oracle, SQL Server, Sybase ASE & DB2 now have a "Referenced By" folder under the "Dependencies" folder that will show the user the objects that reference the parent object.
@ivan: Open ADS v18 and navigate to IBM DB2 v10.5 and ADMINISTRATOR schema and expand table ACT and Dependencies node.
Comparing with ADS v17, we did not display the same table as referenced to itself. For e.g in ACT table is shown again with Dependencies ACT. See attached screenshot. Comparing to ADS v17, there is a mismatch in the number of items that are displayed in the Schema Tree node.
@ivan: Open ADS v18 and navigate to IBM DB2 v10.5 and ADMINISTRATOR schema and expand table ACT and Dependencies node.
Comparing with ADS v17, we did not display the same table as referenced to itself. For e.g in ACT table is shown again with Dependencies ACT. See attached screenshot. Comparing to ADS v17, there is a mismatch in the number of items that are displayed in the Schema Tree node.
Objects that reference themselves will not show up in the reference node.
Committed revision: 53662
Objects that reference themselves will not show up in the reference node.
Committed revision: 53662
Verified in ADS v18.0.5-11in ORacle, Db2 , SQL Server and Sybase all versions
Verified in ADS v18.0.5-11in ORacle, Db2 , SQL Server and Sybase all versions
Issue #15067 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build v19.0.0-dev-5, v18.0.5-9 |
| No time estimate |
2 issue links |
is a duplicate of #15086
Issue #15086Oracle Table Properties -> Blank object is displayed in Dependencies |
relates to #15096
Issue #15096IBM DB2 : Schema Tree -> new node for "Referencing Objects" gives exception |
Oracle:
A new "Referenced By" folder has been created that will live under the "Dependencies" folder. This folder will contain the objects that reference this node object. Committed revision: 53584 & 53586
This has currently only been done for Oracle. I am checking this code in so we can build and test a to get the fix to customer. I will continue to work on this issue and add this same feature to SQL Server, Sybase ASE & DB2.
Committed revision: 53603, 53604. Build#: ADS 18.0.5-5
SQL Server: Complete : Committed revision : 53613 -- Build#: ADS 18.0.5-6
Sybase ASE : Complete : Committed revision: 53626 -- Build#: ADS 18.0.5-6
DB2 : Complete : Committed revision: 53644 -- Build#: ADS 18.0.5-7