Forum — Increase length of MEASUREMENT_TYPE description

Re: Increase length of MEASUREMENT_TYPE description

null@example.com (charliebarnes) — Fri, 03 Jan 2020 11:09:19 +0000

Ah, I see! I can live without validation (and I suspect it's not used a great deal by others?).

Re: Increase length of MEASUREMENT_TYPE description

null@example.com (MikeWeideli) — Fri, 03 Jan 2020 10:33:22 +0000

The same description box is used by all the Term list inputs. The description box would need to be told the length applicable to each Term list. This means either holding the lengths in the code, which could result in maintenance issues or holding them in a table. I suspect the way it was done originally was to avoid this complication.

Changing the length can be done in a few minutes. Adding the validation is more like a day with testing.

Re: Increase length of MEASUREMENT_TYPE description

null@example.com (charliebarnes) — Fri, 03 Jan 2020 08:56:36 +0000

Thanks Mike. Is it not possible to just limit the number of characters that can be entered into the text box (à la survey name)? Or can that only be done with one line inputs?

Re: Increase length of MEASUREMENT_TYPE description

null@example.com (MikeWeideli) — Thu, 02 Jan 2020 22:19:56 +0000

I suggest it is changed to 200. Descriptions on the term list are generally TEXT or set at 200. At the moment the field truncates without warning to the length in the table. Validation on this will be a bit tricky and I wonder if it is necessary if the field length is increased.

Increase length of MEASUREMENT_TYPE description

null@example.com (charliebarnes) — Thu, 02 Jan 2020 16:53:11 +0000

Can the length of the description field in the MEASUREMENT_TYPE table be increased? VARCHAR(50) is too short to write a useful description. TEXT seems overkill, but is in-line with other descriptions.

Limiting the ui text box to the same length would also be helpful so as not to truncate text entered (which is how I found out about the low length!).