Red Gate forums :: View topic - Can I exclude hidden objects from dependency list export?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

Can I exclude hidden objects from dependency list export?

Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
isme



Joined: 12 Jun 2012
Posts: 78
Location: Edinburgh

PostPosted: Tue Nov 13, 2012 4:33 pm    Post subject: Can I exclude hidden objects from dependency list export? Reply with quote

My dependency tracker version is 2.7.4.1.

How do I export a dependency list for only the visible objects in the project?

The dependency export feature seems only to export a dependency list for all the objects in the project, visible or hidden.

The exported document contains a message like this:

Quote:
This report include visible dependencies for all objects in the project.
Objects and dependencies that are not visible are not included.


Based on the behavior of the export function, it would appear 'visible' in this context means 'added to the project' rather than 'not hidden from view'.

Is this the intended behavior?

How to reproduce

Create an example database on your development instance using the following script:

Code:
CREATE DATABASE DependencyTracker_isme_20121113;
GO

USE DependencyTracker_isme_20121113;
GO

CREATE TABLE a (
  b INT PRIMARY KEY,
  c INT
);

CREATE TABLE d (
  e INT PRIMARY KEY FOREIGN KEY REFERENCES a(b),
  f INT
);

CREATE TABLE g (
  h INT PRIMARY KEY FOREIGN KEY REFERENCES d(e),
  i INT
);
GO


Create a new project in SQL Dependency tracker. Add all the tables from database DependencyTracker_isme_20121113 but nothing else.

The main view of SQL Dependency Tracker looks like this:



Export a PDF dependency list.

The PDF should look like this:



The export contains all the same information as the Dependency Tracker main view. So far, so good.

Hide table g.

The main view looks like this:



Export the PDF dependency list again.

The dependency list looks exactly the same:



The table g is not visible in the Dependency Tracker main view, so I would expect to see no reference to it in the exported dependency list.
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Wed Nov 14, 2012 6:59 pm    Post subject: Reply with quote

Sorry you are experiencing this.
This appears to be a known issue under the internal reference number of DT-514
Unfortunaltely I do not have an ETA for a fix.
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group