Delta column (no) inside the webform_submitted_data table is of the wrong type [#2449381]

Hey there,

The no column in the webform_submitted_data table is currently of the type varchar. This means that ordering by that column (which actually happens when loading a submission) doesn't work.

For example, if you have a select list with more than 10 options and you select them all, the order in which they come back from the table is 1, 10, 11, 12, 2, 3, 4, etc.

Comments

Comment #1

Upchuk CreditAttribution: Upchuk commented 10 March 2015 at 10:38

Status:

Active

» Closed (duplicate)

Somehow the issue got submitted twice...

Original is #2449383: Select list component display incorrectly orders items; should match component order

Comment #2

DanChadwick CreditAttribution: DanChadwick commented 10 March 2015 at 10:46

Category:	Bug report	» Support request
Status:	Closed (duplicate)	» Closed (works as designed)

The keys are strings and often contain string values. Unlike core, all data is stored in the same table. There is no guarantee that views will order them in their no order.