dropdown dyanamic data

I need to populate a dropdown with data from a table. I created a ReadDb with "multi read" and "enable model id" YES.
In dropdown / dynamic data ?? I'm trying:
* Data path: the model ID of ReadDb
* Key value: "id"
* Text key: the field name of the table to display

But it does not work, wrong setting ??

Hi agostino87,

Is the primary key column in the table called 'id' ? I probably is but not always.

What do you have the in the Dynamic Data tab of the drop-down element?

What do you see in the Debugger output?

Bob

yes, the primary key is the "id" field

in the tab dynamic of dropdwn is:
Data path: "leg" (

tab in the "dynamic data" dropdown is:
* equal to the model of dbread
* Value key: id
* text key: "soluzione" (db field to edit)

debug

Array
(
    [0] => SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name` FROM `sat_chronoengine_extensions` AS `Extension` WHERE `Extension`.`enabled` = '1' ORDER BY `Extension`.`ordering` ASC
    [1] => SELECT `Connection`.`id` AS `Connection.id`, `Connection`.`title` AS `Connection.title`, `Connection`.`params` AS `Connection.params`, `Connection`.`extras` AS `Connection.extras`, `Connection`.`published` AS `Connection.published` FROM `sat_chronoengine_connections` AS `Connection` WHERE `Connection`.`title` = 'assistenza' AND `Connection`.`published` = '1'
    [2] => SELECT `gestione`.`id` AS `gestione.id`, `gestione`.`uniq_id` AS `gestione.uniq_id`, `gestione`.`user_id` AS `gestione.user_id`, `gestione`.`created` AS `gestione.created`, `gestione`.`modified` AS `gestione.modified`, `gestione`.`codiceutente` AS `gestione.codiceutente`, `gestione`.`mail` AS `gestione.mail`, `gestione`.`datapratica` AS `gestione.datapratica`, `gestione`.`contatto` AS `gestione.contatto`, `gestione`.`prodotto` AS `gestione.prodotto`, `gestione`.`descrizionedifetto` AS `gestione.descrizionedifetto`, `gestione`.`manifestazionedifetto` AS `gestione.manifestazionedifetto`, `gestione`.`datigaranzia` AS `gestione.datigaranzia`, `gestione`.`numeroddt` AS `gestione.numeroddt`, `gestione`.`dataddt` AS `gestione.dataddt`, `gestione`.`datascontrino` AS `gestione.datascontrino`, `gestione`.`scontrino` AS `gestione.scontrino`, `gestione`.`dichiarazione` AS `gestione.dichiarazione`, `gestione`.`garanzia` AS `gestione.garanzia`, `gestione`.`statolavorazione` AS `gestione.statolavorazione`, `gestione`.`ritiromerce` AS `gestione.ritiromerce`, `gestione`.`dettagliritiro` AS `gestione.dettagliritiro`, `gestione`.`soluzione` AS `gestione.soluzione`, `gestione`.`tipoassistenza` AS `gestione.tipoassistenza`, `gestione`.`costo` AS `gestione.costo`, `gestione`.`dataarrivo` AS `gestione.dataarrivo`, `gestione`.`manager` AS `gestione.manager`, `gestione`.`agente` AS `gestione.agente` FROM `sat_atala_assistenza` AS `gestione` WHERE `gestione`.`id` = '11'
    [3] => SELECT `Form`.`id` AS `Form.id`, `Form`.`title` AS `Form.title`, `Form`.`params` AS `Form.params`, `Form`.`extras` AS `Form.extras`, `Form`.`published` AS `Form.published`, `Form`.`app` AS `Form.app`, `Form`.`form_type` AS `Form.form_type`, `Form`.`content` AS `Form.content` FROM `sat_chronoengine_chronoforms` AS `Form` WHERE `Form`.`title` = 'assistenzamod' AND `Form`.`published` = '1'
    [4] => SELECT `leg`.`id` AS `leg.id`, `leg`.`user_id` AS `leg.user_id`, `leg`.`codiceutente` AS `leg.codiceutente`, `leg`.`mail` AS `leg.mail`, `leg`.`datapratica` AS `leg.datapratica`, `leg`.`contatto` AS `leg.contatto`, `leg`.`prodotto` AS `leg.prodotto`, `leg`.`descrizionedifetto` AS `leg.descrizionedifetto`, `leg`.`manifestazionedifetto` AS `leg.manifestazionedifetto`, `leg`.`datigaranzia` AS `leg.datigaranzia`, `leg`.`numeroddt` AS `leg.numeroddt`, `leg`.`dataddt` AS `leg.dataddt`, `leg`.`datascontrino` AS `leg.datascontrino`, `leg`.`scontrino` AS `leg.scontrino`, `leg`.`dichiarazione` AS `leg.dichiarazione`, `leg`.`garanzia` AS `leg.garanzia`, `leg`.`statolavorazione` AS `leg.statolavorazione`, `leg`.`ritiromerce` AS `leg.ritiromerce`, `leg`.`dettagliritiro` AS `leg.dettagliritiro`, `leg`.`soluzione` AS `leg.soluzione`, `leg`.`tipoassistenza` AS `leg.tipoassistenza`, `leg`.`costo` AS `leg.costo`, `leg`.`dataarrivo` AS `leg.dataarrivo`, `leg`.`manager` AS `leg.manager`, `leg`.`agente` AS `leg.agente` FROM `sat_atala_assistenza` AS `leg`
    [5] => SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`addon_id` AS `Extension.addon_id`, `Extension`.`name` AS `Extension.name`, `Extension`.`title` AS `Extension.title`, `Extension`.`enabled` AS `Extension.enabled`, `Extension`.`ordering` AS `Extension.ordering`, `Extension`.`settings` AS `Extension.settings` FROM `sat_chronoengine_extensions` AS `Extension` WHERE `Extension`.`name` = 'chronoforms'
)

Hi agostino87,

Sorry, I meant the ChronoForms Debugger, not the Joomla! one.

Bob

excuse me I do not understand. I have moved the CF 5 (the debug code form), is not the debud Joomla (that is off)

Hi agostino87,

Is this being called from ChronoConnectivity? That does not look like output from the CF debugger.

Bob

activating the "model ID" of the "db read" the form does not fill the database values, deactivating the form is filled with values. but the dropdown does not fill the correct values but only the existing list in the dropdown

this is data array

Array
(
    [option] => com_chronoconnectivity5
    [cont] => lists
    [ccname] => assistenza
    [act] => edit
    [Itemid] => 165
    [gcb] => 24
    [gestione] => Array
        (
            [id] => 24
            [uniq_id] => 8f6a751055e2fdda0a408a93f95e17c2dfad1c83
            [user_id] => 628
            [created] => 2016-11-03 14:47:32
            [modified] => 
            [codiceutente] => WebMaster
            [mail] => polizzano@atala.it
            [datapratica] => 19-10-2016
            [contatto] => 
            [prodotto] => 0114420348 - CITY28 UNDERGROUND 24V GRIG.54
            [descrizionedifetto] => gfsdgdsarhfdewGHAFGDHNSDNBBB
            [manifestazionedifetto] => rfgergvesagh
            [datigaranzia] => nuovo
            [numeroddt] => 1234.55555
            [dataddt] => 20/10/2016
            [datascontrino] => 04/10/2016
            [scontrino] => 
            [dichiarazione] => 1
            [garanzia] => 
            [statolavorazione] => 0
            [ritiromerce] => 
            [dettagliritiro] => 
            [soluzione] => 12
            [tipoassistenza] => 1
            [costo] => 
            [dataarrivo] => 
            [manager] => 
            [agente] => 0
        )

    [id] => 1
    [user_id] => 628
    [codiceutente] => WebMaster
    [mail] => polizzano@atala.it
    [datapratica] => 19-10-2016
    [contatto] => 
    [prodotto] => 0114420348 - CITY28 UNDERGROUND 24V GRIG.54
    [descrizionedifetto] => gfsdgdsarhfdewGHAFGDHNSDNBBB
    [manifestazionedifetto] => rfgergvesagh
    [datigaranzia] => nuovo
    [numeroddt] => 1234.55555
    [dataddt] => 20/10/2016
    [datascontrino] => 04/10/2016
    [scontrino] => 20161013183525_14502780_1384704921554796_7525320804386827115_n.jpg
    [dichiarazione] => 1
    [garanzia] => 
    [statolavorazione] => 0
    [ritiromerce] => 
    [dettagliritiro] => 
    [soluzione] => 01
    [tipoassistenza] => 1
    [costo] => 
    [dataarrivo] => 
    [manager] => 
    [agente] => 0
)

Array
(
)

this is debug info

Array
(
    [22] => Array
        (
            [DB Read] => Array
                (
                    [Queries] => Array
                        (
                            [0] => SELECT `Data`.`id` AS `Data.id`, `Data`.`user_id` AS `Data.user_id`, `Data`.`codiceutente` AS `Data.codiceutente`, `Data`.`mail` AS `Data.mail`, `Data`.`datapratica` AS `Data.datapratica`, `Data`.`contatto` AS `Data.contatto`, `Data`.`prodotto` AS `Data.prodotto`, `Data`.`descrizionedifetto` AS `Data.descrizionedifetto`, `Data`.`manifestazionedifetto` AS `Data.manifestazionedifetto`, `Data`.`datigaranzia` AS `Data.datigaranzia`, `Data`.`numeroddt` AS `Data.numeroddt`, `Data`.`dataddt` AS `Data.dataddt`, `Data`.`datascontrino` AS `Data.datascontrino`, `Data`.`scontrino` AS `Data.scontrino`, `Data`.`dichiarazione` AS `Data.dichiarazione`, `Data`.`garanzia` AS `Data.garanzia`, `Data`.`statolavorazione` AS `Data.statolavorazione`, `Data`.`ritiromerce` AS `Data.ritiromerce`, `Data`.`dettagliritiro` AS `Data.dettagliritiro`, `Data`.`soluzione` AS `Data.soluzione`, `Data`.`tipoassistenza` AS `Data.tipoassistenza`, `Data`.`costo` AS `Data.costo`, `Data`.`dataarrivo` AS `Data.dataarrivo`, `Data`.`manager` AS `Data.manager`, `Data`.`agente` AS `Data.agente` FROM `sat_atala_assistenza` AS `Data`
                        )

                )

        )

)

Hi agostino87,

I don't know what you are showing me here. This looks like something called from ChronoConnectivity but there is no evidence of any dynamic data being loaded for a drop-down.

Bob

I solved using chroonoconnectivity, in edit I inserted the code created by CF5 and modified in the name with "[modelID] namedropdown"

This solution is used to upload to CC data on dropdown and radio box and then modify them

hopefully it will be of help to many this solution

sorry, model title, not model id