Chloggen should generate links for PRs

[lmolkova]

Changelog contains PR numbers which are not automatically recognized as links when they are committed to the repo.

semantic-conventions/CHANGELOG.md

Line 15 in 07293ed

- `database`: Add new `db.response.status_code` attribute, deprecate `db.cosmos.status_code`. (#1424)

It'd be great to make chloggen produce links for them.

[joaopgrassi]

There could be a way of doing it today, with a custom template https://github.com/open-telemetry/opentelemetry-go-build-tools/blob/main/chloggen/internal/chlog/testdata/custom.tmpl#L5 the only problem is that it's not possible to distinguish between a issue or a PR, since the field today can hold numbers for both.

To really make it work, we would need in chloggen another field for the PR number.

I've sent a proposal, let's see 🤞. In the PR there's an example on how we can generate the PR links in the markdown file.

[joaopgrassi]

Alright, I was unaware that GitHub automatically redirects correctly PRs/Issues, so we don't need changes in the tool. Just a custom template.

Because pull requests are issues, issue and pull request numbers do not overlap in a repository. For example, if you open your first issue in a repository, the number will be 1. If you then open a pull request, the number will be 2

Source: https://docs.github.com/en/rest/using-the-rest-api/issue-event-types?apiVersion=2022-11-28

thanks @mowies !