# Plotting Issues dependencies

**URL:** https://forum.gitea.com/t/plotting-issues-dependencies/7472
**Category:** Ecosystem
**Created:** [June 24, 2023, 7:04am UTC](https://forum.gitea.com/t/plotting-issues-dependencies/7472 "2023-06-24T07:04:05Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![vasvir](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.gitea.com/vasvir/32/3503_2.png) [@vasvir](https://forum.gitea.com/u/vasvir)
#### Post date: [June 24, 2023, 7:04am UTC](https://forum.gitea.com/t/plotting-issues-dependencies/7472/1 "2023-06-24T07:04:05Z")

</div>

Hi everybody,

Looks like gitea doesn’t have a way to plot issue’s dependencies [Show graph for issue dependencies · Issue #20838 · go-gitea/gitea · GitHub](https://github.com/go-gitea/gitea/issues/20838) (and older 8794). This is a hackish way to get a plot of the issues dependencies in gitea.

> **[GitHub - vasvir/gitea-plot-issue-dependencies: Plots either all connected issues or a specific...](https://github.com/vasvir/gitea-plot-issue-dependencies)**
>
> Plots either all connected issues or a specific issues dependencies

From the README

## Gitea Plot Issue Dependencies

A quick and dirty way to **Plot either all connected issues or a specific issue dependencies**.

Requires:

1. GNU Make
2. AWK (probably GNU AWK)
3. Graphviz

### How it works

It uses make as a task runner.

It gets the data from a gitea installation. You may need to edit this target (gitea-issues.data) in order to make arrangements for your case. Currently it tries to reach the gitea MySQL database server through SSH. If you have local access or you are using the PostgreSQL database you need to configure accordingly.

After it downloads gitea-issues.data it tries to create the .dot file. There is a command line argument that governs if it will plot all connected issues or the tree of only a specific issue.

See attached screenshot below:

 ![all-connected-issues](https://us1.discourse-cdn.com/flex020/uploads/gitea/original/2X/7/761f38f8ef70faf2f9f7a7b6530b9a7b9a992783.png)

### Legend

- The red issues are blocking other issues.
- The green issues are the closed issues.
- The white issues are normal, non blocking issues.

### Usage

The Makefile accepts the following arguments

- HOST specify to which host to ssh in order to download the data.
- BASE\_URL the base\_url of your repository so the SVG can hold links. It should end on /issues
- ISSUE if present only the tree of that specific issue will be plotted.

#### Examples

To plot the tree of all issue dependencies:

```auto
make HOST=giteahost BASE_URL=https://giteahost.company.com/git/company/monorepo/issues

```

It results to file gitea-issues.svg

To plot the dependency tree of one specific issue:

```auto
make HOST=giteahost BASE_URL=https://giteahost.company.com/git/company/monorepo/issues ISSUE=1001

```

It results to file gitea-issue-1001.svg

The resulting SVG can be viewed by the browser by pointing to their direction.