Database formatting

[soif]

Some columns (ie Yes/No columns) may also content :

• "-" (dash) content
• "" (empty) content

Figure what it means :

• Not set?
• Unknown?
• something else?

then we'd take appropropriate action to :

• clean the values in the formatter
• ensure filters use them correctly
• ensure they are sorted correctly

[richb-hanover]

This is a hard problem. The rules for setting database columns are underspecified (see the text in a Dataentry/text entry page like https://openwrt.org/toh/hwdata/gl.inet/gl.inet_gl-mt6000#data_entry).

We are are going to have to guess what the original person who created the Dataentry was thinking.

It's easy enough for me to query my database to collect info about some of the most troublesome columns: do you have any suggestions? Thanks