Skip to content

populating select from database : particular schema #4

@casa10

Description

@casa10

Hye,
I have this problem :
1rst table : agenda with columns (id, start_date, end_date, text)
2nd table : agenda_civilite with columns (idac, id, idcivilite)
3rd table : civilite with columns (idcivilite, code, libelle)
I need to populating my view with the good 'idcivilite' and i used CrossOptionConnector because OptionsConnector needs that a column must be present on my first table. But me i have another table like 'agenda_civilite' and this, is one of my problem. I want to have 'select' and not 'multiselect' (Cf. infra)

In the view, with, my code is :
scheduler.config.lightbox.sections =
[
{ name: "idcivilitefrombdd", height: 21,
map_to: "idcivilite",
type: "multiselect",
options: scheduler.serverList("id_civilite"),
script_url: 'chargeur/gerer_agenda'}
]
In my controller, CrossoptionsConnector works with type "multiselect" in my view but with "select" it doesn't work and my 'idcivilite' is not associated to the good 'idcivilite' present in table "agenda_civilite".
How can i have the good 'idcivilite' selected if i want to have type : "select" on the code (Cf. supra).
With JSON component, type:"select" works !! but without JSON, i must use type :"multiselect" :(
Thanks.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions