Forums

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.