[html-formfu] How to restrict retrieved rows in has_many relationships?

[michele.gherlone at liceoberchet.it]

> Hi Michele,
>
> currently I don't think this is possible in the dynamic way you want it.
>
> What I don't understand is that materia is a underneath voti. If materia
> shall control the elements of voti, it should be at least on the same
> hierarchical level.

Hi, Mario. I didn't explain my relationships in detail, maybe.
Since table materia has_many voti, and table studente has_many voti, in
the 'voti' table we have studente_id and materia_id. In the config file I
showed you, I am exploiting in the last Block underneath voti the
belongs_to relationship (voto belongs_to materia, materia_id). The column
I'd like to restrict my results with would also be materia_id.

I think I could also try to use a multi like a select or a checkboxgroup
with options_from_ model, but again I should then set:
model_config:
 resultset: Voto
 condition:
  materia_id: 2
  studente_id: 2315

Could I set these 2 params using dynamically defined values?
Greets,
Michele

> To achieve your goal, we would need to extend FormFu::Model::DBI to
> handle dynamic parameters.
>
>
> Greets,
>
> Mario Minati
>
> michele.gherlone at liceoberchet.it schrieb:
>> Hi all.
>> I've setup the following relationships in my application:
>> - table classe has_many studenti
>> - table studente has_many voti
>> - table voto belongs_to studente, materia
>> Now I have created the following table/form in yaml:
>>
>> ---
>> auto_fieldset: 1
>> elements:
>>   - type: Hidden
>>     name: count
>>   - type: Block
>>     tag: table
>>     attributes:
>>       width: 100%
>>     elements:
>>         - type: Repeatable
>>           tag: tr
>>           nested_name: studenti
>>           counter_name: count
>>           elements:
>>             - type: Block
>>               tag: td
>>               elements:
>>                 - type: Hidden
>>                   name: id
>>                 - type: Label
>>                   name: cognome
>>                 - type: Label
>>                   name: nome
>>                 - type: Hidden
>>                   name: count
>>                 - type: Repeatable
>>                   nested_name: voti
>>                   counter_name: count
>>                   tag: td
>>                   elements:
>>                     - type: Hidden
>>                       name: id
>>                     - name: voto
>>                     - name: data_voto
>>                     - type: Block
>>                       nested_name: materia
>>                       elements:
>>                         - name: materia
>>
>>   - type: Submit
>>     name: submit
>>     attributes:
>>       value: Invia
>>
>> This works very well. But what I want now to do is to restrict the rows
>> which are retrieved by the nested Repeatable 'voti' based on the value
>> of
>> 'materia', i.e. I *DON'T* want all the notes for each student, but I
>> want
>> only a few of them based upon some search criteria. How can I pass a
>> search condition or something similar to the repeatable block? Is this
>> possible at all?
>> Thanks in advance,
>> Michele Gherlone
>>
>>
>>
>> _______________________________________________
>> HTML-FormFu mailing list
>> HTML-FormFu at lists.scsys.co.uk
>> http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/html-formfu
>>
>
>
> _______________________________________________
> HTML-FormFu mailing list
> HTML-FormFu at lists.scsys.co.uk
> http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/html-formfu
>