Does Dependancyjobs always contain a single value from JobName column, or it's a list of some kind?

You will be building a tree if each job has a single parent job. I don't have Oracle DB to try this, but it should look like this:

var rect = new RectangleF(0, 0, 30, 20);
var parentLinks = new StringDictionary();

OracleCommand command = connection.CreateCommand();
command.CommandText = "select * from Jobs";

OracleDataReader reader = command.ExecuteReader();
while (reader.Read())
{
	var node = diagram.Factory.CreateShapeNode(rect);
	node.Id = (string)reader["JobID"];
	node.Text = (string)reader["JobName"];
	var parentId = (string) reader["Dependancyjobs"];
	parentLinks[(string)node.Id] = parentId;
}

foreach (var id in parentLinks.Keys)
{
	var node1 = diagram.FindNodeById(parentLinks[id]);
	var node2 = diagram.FindNodeById(id);
	diagram.Factory.CreateDiagramLink(node1, node2);
}

var layout = new TreeLayout();
layout.Arrange(diagram); 

The first loop creates all nodes and stores parent identifiers. It cannot create links immediately because the parent node might have not been created yet. Links are created in second loop from nodes identified by parentLinks values.

I hope that helps,
Stoyan

I don't think you can represent many-to-many relationships if you keep a single parentID field in the table. Instead you will need a separate table just for the dependencies, with parentID and childID fields in each record. The code should look similar to this then:

// ....
while (reader.Read())
{
	var node = diagram.Factory.CreateShapeNode(rect);
	node.Id = (string)reader["JobID"];
	node.Text = (string)reader["JobName"];
}

OracleCommand dependenciesCmd = connection.CreateCommand();
dependenciesCmd.CommandText = "select * from Dependencies";

OracleDataReader depReader = dependenciesCmd.ExecuteReader();
while (depReader.Read())
{
	string parentId = (string)depReader["ParentID"];
	string childId = (string)depReader["ChildID"];
	var parent = diagram.FindNodeById(parentId);
	var child = diagram.FindNodeById(childId);
	diagram.Factory.CreateDiagramLink(parent, child);
}

var layout = new LayeredLayout();
layout.Arrange(diagram);  

I hope that helps,
Stoyan

Are you using a separate table for many-to-many relationships as in second example? In such case check if the names from sample code match the names you've given to your table and fields: Dependencies table, ParentID and ChildID columns. Make sure ParentID/ChildID values point to existing JobID (and not JobName) in the primary table.

I hope that helps,
Stoyan

I can see some links created in the screenshot, but the graph hasn't been arranged. That probably means there was an exception thrown before the code reached layout.Arrange call. Try adding breakpoint inside your catch clause to see the exact exception type and message. If the Id columns contain integer values, try replacing the (string) cast with reader.GetInt32(...) call.

I hope that helps,
Stoyan

I suppose you have followed my "replace the (string) cast with reader.GetInt32(...)" suggestion too literally. You should call depReader.GetInt32(...) while iterating over AUTOSYS_DEPENDENCY result set.

I hope that helps,
Stoyan

Hello,

We were almost close to finishing the POC to create a flowchart (many-many relation) by fetching the values form DB. This product really works for our requirement.

The last thing, i would like to know is,
Lets say my table has all the jobs and its dependency.. But i dont want the entire graph to shown in the page. It might be huge data.

So I just need a graph starting from Job C to 5 stages below.


DEP_NAME      DEP_JID      PARENT_JID      JOB_TYPE
Job A            5677      6767      (null)
Job B            5677      6777      (null)
Job C            3454      5677      (null)
JOB D            7789      3454      (null)
JOB E            7789      2123      (null)
JOB F            3444      7789      (null


Is it possible for me to do that using MindFusion?