Forums

Salve
ho creato un database gestione angrafica e sto usando ChronoConnectivity per visualizzare i relativi elenchi. Ho due elenchi: il primo mi visualizza una serie di categorie come si può vedere nell'allegato "cattura", dove in ogni categoria appartengono una serie di persone in base alla data di nascita come da allegato "cattura2". Avrei bisogno che cliccando su una categoria si aprisse l'elenco delle persone la cui data di nascita sia compresa tra le due date della categoria

Google translation added by GreyHead
I created a database management angrafica and I'm using ChronoConnectivity to display their lists. I have two lists: the first shows me a number of categories as you can see in the attachment "capture", where in each category are a number of people on the basis of date of birth as per attachment "cattura2." I need that by clicking on a category would open the list of persons whose date of birth falls between the two dates of the class

Hi Fasano,

You will need to add the "Catgeoria" field in the first list in the "Links" box, the target link should be to the 2nd listing, and the category id should be passed in the URL, you will then use the id in the 2nd list (in the conditions box of the model) and load the associated users, you may also pass the start and end dates instead of the id, this may make it easier!

Regards,
Max

Hi max and thanks for the reply
It was what I was trying to do but I can not edit the code to do this.
You can not help me?

This is the link:
categorie.categoria:index.php?option=com_chronoconnectivity5&cont=lists&act=index&ccname=visualizza_iscritti_per_categoria
and it works perfectly and opens the second list.
But how can I do to pass the start date and end time?
Excuse me, but are not very practical
greetings
Fabrizio

Hi Fabrizio,

What are the names of the start date and end date fields in the "categoria" model ?

Regards,
Max

So the link field should be:

categorie.categoria:index.php?option=com_chronoconnectivity5&cont=lists&act=index&ccname=visualizza_iscritti_per_categoria&da={categoria.da}&a={categoria.a}

Now in the "Conditions" box of the other listing, just use this:

<?php
return array("da >=" => \GCore\Libs\Request::data("da"), "a <=" => \GCore\Libs\Request::data("a"));

The fields names in the 2nd list may need to be changed if they are different, and you may need to add the Model id as well!

Regards,
Max

Hi Max
It works perfectly.
thank you very much
greetings
Fabri