Mercurial > roundup-cc > roundup-cc
annotate TODO.creole @ 18:325757454907
Add TODO.creole file, with keyword extension proposal.
| author | Bernhard Reiter <bernhard@intevation.de> |
|---|---|
| date | Mon, 09 Jul 2018 14:43:23 +0200 |
| parents | |
| children | 8ffd584065a4 |
| rev | line source |
|---|---|
|
18
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
1 == Allow tracking of issues per keyword(s) and status |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
2 |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
3 (20180709ber) |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
4 |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
5 It makes sense to be able to track the status of issues in combination |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
6 with keywords. For example if I'm using a keyword {{{version2}}} |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
7 of my software, I'd like to know how many issues are open, being worked on |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
8 or on testing. |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
9 |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
10 This would allow something like a burn down chart. |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
11 |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
12 === Technical ideas |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
13 Keywords can change over time for a tracker, so collecting them |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
14 should not depend on a fixed database schema. |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
15 |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
16 On idea is to save them as a JSON text in a {{{keywords}}} field. |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
17 This maybe be given almost directly to a webbased display system |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
18 based on javascript. |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
19 They drawback is that SQL cannot be used to query by keyword details, |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
20 but advanced database functions can be used for improving this situation |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
21 like [[https://www.sqlite.org/json1.html|SQlite' JSON1 extension]]. |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
22 |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
23 The same could be used for priorities and status values, as they |
|
325757454907
Add TODO.creole file, with keyword extension proposal.
Bernhard Reiter <bernhard@intevation.de>
parents:
diff
changeset
|
24 could also change. |