ChronoEngine.com homepage

Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

where is the keyword?

Fredolino 24 Jul, 2019
Hello,
I look for the place where the [keywords] is passed.
I made changes to the dropdown (field_filter_species), the form area (search), the button (button-filter) and also the read data (read_filter_species). But it does not work.
But if I use the search widget in default mode, then it works.
I do not know where to look ...
Array
(
    [conn] => beobachtungsliste
    [article_id] => 643
    [event] => view
    [field_filter_species] => unicolorella, Eulamprotes, (DUPONCHEL, 1843)
    [keywords] => 
    [99b2d8d194748b816f5a52b3f980c167] => 1ae96c5b653a22265f0d6f6d15528f26
    [84a67b6ec4a2db8ac9e867546b14d6f3] => dd38f37033a5811f2b75cbd3725538b7
    [joomla_user_state] => logged_in
    [Itemid] => 112
    [option] => com_content
    [view] => article
    [id] => 36
    [beobachtungsliste] => 
)
Array
(
    [read_filter_species] => Array
        (
            [log] => Array
                (
                    [0] => SELECT `filt_species`.`species` AS `filt_species.species` FROM `mtb_beobachtung` AS `filt_species` WHERE `filt_species`.`user_id` = '909' AND `filt_species`.`beo_id` = '643';
                )

            [var] => Array
                (
                    [unicolorella, Eulamprotes, (DUPONCHEL, 1843)] => unicolorella, Eulamprotes, (DUPONCHEL, 1843)
                    [padella, Yponomeuta, (LINNAEUS, 1758)] => padella, Yponomeuta, (LINNAEUS, 1758)
                )

        )

    [read_article] => Array
        (
            [log] => Array
                (
                    [0] => SELECT `Article`.`beo_id` AS `Article.beo_id`, `Article`.`user_id` AS `Article.user_id`, `Article`.`fundort` AS `Article.fundort`, `Article`.`beobachter` AS `Article.beobachter`, `Article`.`teilnehmer` AS `Article.teilnehmer`, `Article`.`datenweitergabe` AS `Article.datenweitergabe`, `Article`.`created` AS `Article.created`, `Article`.`modified` AS `Article.modified` FROM `mtb_beobachtung_fundort` AS `Article` WHERE `Article`.`beo_id` = '643' GROUP BY `Article.fundort`;
                )

            [var] => Array
                (
                    [Article] => Array
                        (
                            [beo_id] => 643
                            [user_id] => 909
                            [fundort] => Klosterfelde am Waldrand, BAR
                            [beobachter] => 
                            [teilnehmer] => 
                            [datenweitergabe] => 1
                            [created] => 2019-07-02 18:08:02
                            [modified] => 
                        )

                )

        )

    [read_beob] => 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] => 1021
                                    [user_id] => 909
                                    [beo_id] => 643
                                    [mapid_v] => 0
                                    [datum] => 2019-07-24
                                    [species] => padella, Yponomeuta, (LINNAEUS, 1758)
                                    [anzahl] => 7
                                    [stadium] => Imago
                                    [geschlecht] => Ohne 
                                    [beobachtung] => Am Licht
                                    [bestimmung] => Augenschein
                                    [bemerkung] => 
                                    [photo] => 
                                    [created] => 2019-07-23 10:54:41
                                    [modified] => 
                                )

                        )

                    [1] => Array
                        (
                            [Fund] => Array
                                (
                                    [beof_id] => 1070
                                    [user_id] => 909
                                    [beo_id] => 643
                                    [mapid_v] => 0
                                    [datum] => 2019-07-24
                                    [species] => unicolorella, Eulamprotes, (DUPONCHEL, 1843)
                                    [anzahl] => 3
                                    [stadium] => Imago
                                    [geschlecht] => Ohne 
                                    [beobachtung] => Am Licht
                                    [bestimmung] => Augenschein
                                    [bemerkung] => 
                                    [photo] => 
                                    [created] => 2019-07-23 16:04:23
                                    [modified] => 
                                )

                        )

                )

        )

)
healyhatman 24 Jul, 2019
1 Likes
Don't use the search widget or the searchable fields. Just use a normal field, and put the filtering in your Where Conditions as

tablefieldname LIKE %{data:formfieldname}%

... and for the 'On null value' set to continue.
Fredolino 24 Jul, 2019
Wow,
I would never have guessed that.
Many Thanks!

Now only the Reset / Clear button has to work ...
This topic is locked and no more replies can be posted.

2Checkout.com

2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for goods and services provided by ChronoEngine.com