representation for Checked state doesn't work for boolean widgets

[qgib]

Author Name: Tudor Bărăscu (@tudorbarascu)
Original Redmine Issue: 14203
Affected QGIS version: 2.12.2
Redmine category:attribute_table

---

I'm trying to add a Postgis layer that has columns with boolean values and I want to display each of them using different values, e.g. Active - Inactive, Yes - No etc.

By making the settings in the "representation for check state" area, I noticed that they aren't propagated to the table and I only see 't' and 'f'.

There is however a time when the values I've setup appear.. when I click the value in the attribute table..

As a workaround I can setup a value map type of widget, but that messes up the custom ui's for those who use them (and I do).

I tested with master and 2.12.3 on Debian Stretch

[qgib]

Author Name: Tudor Bărăscu (@tudorbarascu)

---

• fixed_version_id was configured as Version 2.14

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

what is the datatype of the columns your are using for the boolean widget?

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Tudor Bărăscu (@tudorbarascu)

---

Hi Giovanni,

It's boolean (I already wrote that in the issue definition).
My expectations were/are: for a boolean field, I can setup whatever is displayed in the attribute table etc. for the True and for False values.
Am I having wrong expectations?

If so, what is the purpose for the "representation for Checked state" of the checkbox widget.

Tested on Windows also and QGIS 2.8.6.1

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Hi Tudor,

Am I having wrong expectations?

yes. If the datatype is boolean then the only thing you can write into the column is t/f. You can use other datatypes and the "boolean" edit widget to have the users write whatever you want using the checkbox in the qgis table of attributes.

---

• resolution was changed from to invalid
• status_id was changed from Feedback to Closed

[qgib]

Author Name: Tudor Bărăscu (@tudorbarascu)

---

Thanks for the info, it's clear now.

From my perspective, as the widget knows it has a boolean field, I could set it up to display anything I wanted as behind the scenes it would have saved 't' and 'f'.

It's a nice to have feature then.

All the best!

Tudor