List or row problem

How to display a date correctly in a ChronoForms list header.

Overview

The issue occurs when referencing a list variable before the list is rendered, causing the date to default to the current day.
Ensure the date variable is correctly scoped by using the proper array index from the read data function, such as referencing the first element's date field.

Answered
Connectivity v6
Fr Fredolino 17 Jul, 2019
Hi,

In the tab "Events" under "View" I have a date in the headline.
The date in the header is displayed incorrectly.

However, the date is displayed correctly if it is displayed below the list.

What is the problem?
How can I correctly display the date in the header?

many Greetings
F.
{fn:read_article}
{fn:check_article_exists}
{fn:read_beob}
{fn:check_beob_exists}
[h3]
{date:d.m.Y$(var:beob_list.row.Fund.datum)}:  {var:read_article.Article.fundort}[/h3]
incorrectly: 17.07.2019

{view:zuruck_button}
{fn:read_beobs}
{view:beob_list}
{date:d.m.Y$(var:beob_list.row.Fund.datum)}:
correctly: 24.07.2019
[h3]Neue Art hinzufügen[/h3]
{fn:read_specieslist}
{view:beob_new_form}

{view:beob_paginator}
he healyhatman 17 Jul, 2019
Because it's not inside or after beob_list, so var:beob_list.xxx doesn't exist yet, so it defaults to today's date.
Fr Fredolino 18 Jul, 2019
Hi,
ok, but how can I show the date that already exists in the title?
If I load the date with Read Data, enter it as a data provider in a "custom header" or "details list" and then display it in Events view in the content:
{Fn: read_beob_date}
{View: article_dates}
I do not get a date either ...
Fr Fredolino 18 Jul, 2019
Hi,
I only get the 18.7. displayed.
The list (name: beob_list) is based on {var: read_beob}.
The date in the column on "Fund.datum".
The list is displayed in the "Events view":
{Fn: read_beobs}
{View: beob_list}

In the headline I have now: {date: d.m.Y $ (var: read_beob.Fund.datum)}
And also the function:
{Fn: read_beob}
{Fn: check_beob_exists}

But I still make a mistake there ...

List or row problem image 1
Fr Fredolino 18 Jul, 2019
Array
(
    [log] => Array
        (
            [0] => SELECT `Fund`.`beof_id` AS `Fund.beof_id`, `Fund`.`user_id` AS `Fund.user_id`, `Fund`.`beo_id` AS `Fund.beo_id`, `Fund`.`mapid_v` AS `Fund.mapid_v`, `Fund`.`datum` AS `Fund.datum`, `Fund`.`species` AS `Fund.species`, `Fund`.`anzahl` AS `Fund.anzahl`, `Fund`.`stadium` AS `Fund.stadium`, `Fund`.`geschlecht` AS `Fund.geschlecht`, `Fund`.`beobachtung` AS `Fund.beobachtung`, `Fund`.`bestimmung` AS `Fund.bestimmung`, `Fund`.`bemerkung` AS `Fund.bemerkung`, `Fund`.`photo` AS `Fund.photo`, `Fund`.`created` AS `Fund.created`, `Fund`.`modified` AS `Fund.modified` FROM `mtb_beobachtung` AS `Fund` WHERE `Fund`.`beo_id` = '643' GROUP BY `Fund.beof_id`;
        )

    [var] => Array
        (
            [0] => Array
                (
                    [Fund] => Array
                        (
                            [beof_id] => 905
                            [user_id] => 909
                            [beo_id] => 643
                            [mapid_v] => 3
                            [datum] => 2019-07-24
                            [species] => padella, Yponomeuta, (LINNAEUS, 1758)
                            [anzahl] => 1
                            [stadium] => Imago
                            [geschlecht] => männl
                            [beobachtung] => Am Licht
                            [bestimmung] => Augenschein
                            [bemerkung] => 
                            [photo] => 
                            [created] => 2019-07-02 18:08:02
                            [modified] => 
                        )

                )

            [1] => Array
                (
                    [Fund] => Array
                        (
                            [beof_id] => 906
                            [user_id] => 909
                            [beo_id] => 643
                            [mapid_v] => 3
                            [datum] => 2019-07-24
                            [species] => vulgana, Capua, (FRÍLICH, 1828)
                            [anzahl] => 1
                            [stadium] => Imago
                            [geschlecht] => männl
                            [beobachtung] => Am Licht
                            [bestimmung] => Augenschein
                            [bemerkung] => 
                            [photo] => 
                            [created] => 2019-07-02 18:08:02
                            [modified] => 
                        )

                )

            [2] => Array
                (
                    [Fund] => Array
                        (
                            [beof_id] => 920
                            [user_id] => 909
                            [beo_id] => 643
                            [mapid_v] => 0
                            [datum] => 2019-07-24
                            [species] => expressella, Coleophora, KLEMENSIEWICZ, 1883
                            [anzahl] => 4
                            [stadium] => Imago
                            [geschlecht] => männl
                            [beobachtung] => Am Licht
                            [bestimmung] => Augenschein
                            [bemerkung] => 
                            [photo] => 
                            [created] => 2019-07-03 12:05:17
                            [modified] => 
                        )

                )

            [3] => Array
                (
                    [Fund] => Array
                        (
                            [beof_id] => 921
                            [user_id] => 909
                            [beo_id] => 643
                            [mapid_v] => 0
                            [datum] => 2019-07-24
                            [species] => hostilis, Sciota, (STEPHENS, 1834)
                            [anzahl] => 8
                            [stadium] => Imago
                            [geschlecht] => männl
                            [beobachtung] => Am Licht
                            [bestimmung] => Augenschein
                            [bemerkung] => 
                            [photo] => 
                            [created] => 2019-07-03 12:17:47
                            [modified] => 
                        )

                )

            [4] => Array
                (
                    [Fund] => Array
                        (
                            [beof_id] => 922
                            [user_id] => 909
                            [beo_id] => 643
                            [mapid_v] => 0
                            [datum] => 2019-07-24
                            [species] => microgrammana, Cydia, (GUENÉE, 1845)
                            [anzahl] => 4
                            [stadium] => Imago
                            [geschlecht] => männl
                            [beobachtung] => Am Licht
                            [bestimmung] => Augenschein
                            [bemerkung] => 
                            [photo] => 
                            [created] => 2019-07-03 12:23:11
                            [modified] => 
                        )

                )

            [5] => Array
                (
                    [Fund] => Array
                        (
                            [beof_id] => 936
                            [user_id] => 909
                            [beo_id] => 643
                            [mapid_v] => 0
                            [datum] => 2019-07-24
                            [species] => fovealis, Duponchelia, (FABRICIUS, 1794)
                            [anzahl] => 4
                            [stadium] => Imago
                            [geschlecht] => männl
                            [beobachtung] => Am Licht
                            [bestimmung] => Augenschein
                            [bemerkung] => 
                            [photo] => 
                            [created] => 2019-07-17 17:13:50
                            [modified] => 
                        )

                )

        )

)
he healyhatman 18 Jul, 2019
Answer
1 Likes
Right well there you go then. Needs to be {var:read_beob.0.Fund.datum}
This topic is locked and no more replies can be posted.