Forums

Hi!

I have a form with some fields, one of them is a checkboxes with multiple choises. This save the values to a table.
I want to create an another form, to edit this values, so I need to read all data from the database. Only with this checkboxes have I problem.
The read data debug (sorry, this is for hungarian people):

[read_data_19] => Array
        (
            [result] => Data read successfully!
            [log] => Array
                (
                    [0] => SELECT `Model19`.`aid` AS `Model19.aid`, `Model19`.`userid` AS `Model19.userid`, `Model19`.`fizets_tartalmat_tltene_fel` AS `Model19.fizets_tartalmat_tltene_fel`, `Model19`.`linkeket_kvn_hozzadni` AS `Model19.linkeket_kvn_hozzadni`, `Model19`.`kpet_kvn_hozzadni_az_zletrl` AS `Model19.kpet_kvn_hozzadni_az_zletrl`, `Model19`.`cg` AS `Model19.cg`, `Model19`.`zlet_neve` AS `Model19.zlet_neve`, `Model19`.`zlet_cme` AS `Model19.zlet_cme`, `Model19`.`zlet_telefonszma` AS `Model19.zlet_telefonszma`, `Model19`.`zlet_email_cme` AS `Model19.zlet_email_cme`, `Model19`.`sajt_oldalra_mutat_link` AS `Model19.sajt_oldalra_mutat_link`, `Model19`.`tevkenysgi_krk` AS `Model19.tevkenysgi_krk`, `Model19`.`fnykp_az_zletrl` AS `Model19.fnykp_az_zletrl`, `Model19`.`specialitsok` AS `Model19.specialitsok`, `Model19`.`jelmondat` AS `Model19.jelmondat`, `Model19`.`facebook_oldal` AS `Model19.facebook_oldal`, `Model19`.`instagram_oldal` AS `Model19.instagram_oldal`, `Model19`.`linkedin_oldal` AS `Model19.linkedin_oldal`, `Model19`.`megjelenhet` AS `Model19.megjelenhet`, `Model19`.`created` AS `Model19.created`, `Model19`.`expiration` AS `Model19.expiration` FROM `jm5nkj_uzletek` AS `Model19` WHERE `Model19`.`aid` = '1';
                )

            [var] => Array
                (
                    [Model19] => Array
                        (
                            [aid] => 1
                            [userid] => 941
                            [fizets_tartalmat_tltene_fel] => 1
                            [linkeket_kvn_hozzadni] => 1
                            [kpet_kvn_hozzadni_az_zletrl] => 1
                            [cg] => Teszt10
                            [zlet_neve] => teszt10
                            [zlet_cme] => teszt újraírva
                            [zlet_telefonszma] => 
                            [zlet_email_cme] => balazs.nyeste@gmail.com
                            [sajt_oldalra_mutat_link] => https://xxxx.eu
                            [fnykp_az_zletrl] => 20221205113246_black-headed-gulls-gd6bff1a7a-1920.jpg
                            [specialitsok] => ["Szemészorvos","Távcső"]
                            [jelmondat] => dadwqfqwfew
                            [facebook_oldal] => https://www.facebook.com/xxx
                            [instagram_oldal] => https://www.facebook.com/xxx
                            [linkedin_oldal] => https://www.facebook.com/xxx
                            [megjelenhet] => 0
                            [created] => 2022-12-05 10:36:44
                            [expiration] => 2023-01-09
                        )

                )

        )

The field settings:

In read data I use Special Fields to decode json on this field.

What is wrong? In frontend cannot see, what field are checked before...

Thanks!

Any idea?

Ok, I found the solution:

{var.jsonde:read_data_19.Model19.specialitsok}

Thanks for posting the solution!