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.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)