← Back to team overview

dhis2-devs team mailing list archive

[Bug 1441131] [NEW] Discrepancy in Attribute VALUE column length

 

Public bug reported:

The "value" column in the "attributevalue" table is, for unknown
reasons, defined as "character varying(255)" and not "text" as you would
expect for a table used to store a wide variety of attributes.

At the same time, the User Interface has been designed to only accept
230 characters for attribute values, so the current design is not
consistent.

HISP-SA is using the attribute values extensively, and around 20-30% of
the text values we need to store are longer than 255 characters.

SUGGESTED SOLUTION: 
1. Change the attributevalue->value column to data type TEXT
2. Eliminate the 230 character limit in the UI

and if possible

3. Add an attribute definition parameter enabling users to specify the
HEIGHT of the text box used for an attribute value.

** Affects: dhis2
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1441131

Title:
  Discrepancy in Attribute VALUE column length

Status in DHIS 2:
  New

Bug description:
  The "value" column in the "attributevalue" table is, for unknown
  reasons, defined as "character varying(255)" and not "text" as you
  would expect for a table used to store a wide variety of attributes.

  At the same time, the User Interface has been designed to only accept
  230 characters for attribute values, so the current design is not
  consistent.

  HISP-SA is using the attribute values extensively, and around 20-30%
  of the text values we need to store are longer than 255 characters.

  SUGGESTED SOLUTION: 
  1. Change the attributevalue->value column to data type TEXT
  2. Eliminate the 230 character limit in the UI

  and if possible

  3. Add an attribute definition parameter enabling users to specify the
  HEIGHT of the text box used for an attribute value.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1441131/+subscriptions


Follow ups

References