<div>
This is a big question, depending a lot on your specific requirements. For the frontend, however, I can recommend <a href="https://github.com/wesnolte/jOrgChart" rel="ugc">this </a> library, which I have used with some success. <br />
<br />
Good luck!
</div>


This is a big question, depending a lot on your specific requirements. For the frontend, however, I can recommend this [https://github.com/wesnolte/jOrgChart] library, which I have used with some success.

Good luck!

<div>
Sorry about the delay... Thanks for the answer.<br />
Can you please help to understand how to achieve javascript to use data in sql as variables?<br />
What I mean is, if the selection is made from one column, e.g. Name of user, the rest should be taken from the columns of the same user?<br />
<br />
Thanks in advance!
</div>


Sorry about the delay... Thanks for the answer.
Can you please help to understand how to achieve javascript to use data in sql as variables?
What I mean is, if the selection is made from one column, e.g. Name of user, the rest should be taken from the columns of the same user?

Thanks in advance!

Ackles

<div>
<div class="content wysiwyg-content">
Hello,<br />
this is more advice than question...<br />
I have data in SQL (sort of Active Directory Dump) where I have user, his manager &amp;&nbsp;then Department<br />
What I am looking for is to use JavaScript to create Org Chart.<br />
<br />
The idea is to make changes in SQL &amp;&nbsp;the chart should reflect it, I want it to be dynamic, in a way users can collapse &amp;&nbsp;expand the branches &amp;&nbsp;stuff like that....<br />
<br />
Any guidance is highly appreciated.<br />
<br />
Regards,<br />
A
</div>
</div>


Hello,
this is more advice than question...
I have data in SQL (sort of Active Directory Dump) where I have user, his manager & then Department
What I am looking for is to use JavaScript to create Org Chart.

The idea is to make changes in SQL & the chart should reflect it, I want it to be dynamic, in a way users can collapse & expand the branches & stuff like that....

Any guidance is highly appreciated.

Regards,
A

Javascript for Organizational Chart from SQL

JavaScript is a dynamic, object-based language commonly used for client-side scripting in web browsers. Recently, server side JavaScript frameworks have also emerged. JavaScript runs on nearly every operating system and  in almost every mainstream web browser.

JavaScript

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.