Syncing back from QField does not update boolean attributes

[hurlon]

Hello, I am using QField to digitize points in the field and then sync the data with QGIS and the office database. The original "office" data is packed in a single Geopackage and my point table has following structure:

CREATE TABLE pts (
    fid         INTEGER   PRIMARY KEY AUTOINCREMENT
                          NOT NULL,
    geometry    POINT,
    com         MEDIUMINT,
    pla         MEDIUMINT,
    numero      MEDIUMINT,
    nature      MEDIUMINT,
    double_leve BOOLEAN,
    commentaire TEXT,
    uuid        TEXT,
    Piquete     BOOLEAN,
    Materialise BOOLEAN,
    ctime       DATETIME  NOT NULL,
    mtime       DATETIME
);

The syncing works well except for one problem: the 3 attributes with BOOLEAN type are not updated when they are modified in the field.

The version I used for these tests are:

• QGIS 3.24.2
• QField 2.1.4
• QFieldSync 4.1.1

Below is a screenshot of the QGIS attributes Form configuration for one of the boolean attributes (Piquete). The 2 others are configured in the same way

Is this behavior a feature (boolean are not supported and should be replaced by integers) or a bug?

Best regards

[ahellers]

Hi,

I just experienced teh same issue when trying to synchronize data from my mobile device (Android, with QField 2.6.3) to my desktop project (QGIS 3.22.5) using QFieldSync (4.4.7). All data fields are synchronized except the bool fields.

Dear QField developers, please elaborate on this issue!

Cheers, Andreas