Forums

Use fields content

webcrea 13 Oct, 2017
how to use custom fields in chrono list ?

Array
(
    [restaurants] => Array
        (
            [log] => Array
                (
                    [0] => SELECT COUNT(`restaurants`.`id`) AS `restaurants.count` FROM `art_content` AS `restaurants` WHERE `restaurants`.`catid` = '8';
                    [1] => SELECT `restaurants`.`id` AS `restaurants.id`, `restaurants`.`asset_id` AS `restaurants.asset_id`, `restaurants`.`title` AS `restaurants.title`, `restaurants`.`alias` AS `restaurants.alias`, `restaurants`.`introtext` AS `restaurants.introtext`, `restaurants`.`fulltext` AS `restaurants.fulltext`, `restaurants`.`state` AS `restaurants.state`, `restaurants`.`catid` AS `restaurants.catid`, `restaurants`.`created` AS `restaurants.created`, `restaurants`.`created_by` AS `restaurants.created_by`, `restaurants`.`created_by_alias` AS `restaurants.created_by_alias`, `restaurants`.`modified` AS `restaurants.modified`, `restaurants`.`modified_by` AS `restaurants.modified_by`, `restaurants`.`checked_out` AS `restaurants.checked_out`, `restaurants`.`checked_out_time` AS `restaurants.checked_out_time`, `restaurants`.`publish_up` AS `restaurants.publish_up`, `restaurants`.`publish_down` AS `restaurants.publish_down`, `restaurants`.`images` AS `restaurants.images`, `restaurants`.`urls` AS `restaurants.urls`, `restaurants`.`attribs` AS `restaurants.attribs`, `restaurants`.`version` AS `restaurants.version`, `restaurants`.`ordering` AS `restaurants.ordering`, `restaurants`.`metakey` AS `restaurants.metakey`, `restaurants`.`metadesc` AS `restaurants.metadesc`, `restaurants`.`access` AS `restaurants.access`, `restaurants`.`hits` AS `restaurants.hits`, `restaurants`.`metadata` AS `restaurants.metadata`, `restaurants`.`featured` AS `restaurants.featured`, `restaurants`.`language` AS `restaurants.language`, `restaurants`.`xreference` AS `restaurants.xreference` FROM `art_content` AS `restaurants` WHERE `restaurants`.`catid` = '8' LIMIT 25;
                    [2] => SELECT `valeurs`.`field_id` AS `valeurs.field_id`, `valeurs`.`item_id` AS `valeurs.item_id`, `valeurs`.`value` AS `valeurs.value`, `champs`.`id` AS `champs.id`, `champs`.`asset_id` AS `champs.asset_id`, `champs`.`context` AS `champs.context`, `champs`.`group_id` AS `champs.group_id`, `champs`.`title` AS `champs.title`, `champs`.`name` AS `champs.name`, `champs`.`label` AS `champs.label`, `champs`.`default_value` AS `champs.default_value`, `champs`.`type` AS `champs.type`, `champs`.`note` AS `champs.note`, `champs`.`description` AS `champs.description`, `champs`.`state` AS `champs.state`, 
`champs`.`required` AS `champs.required`, `champs`.`checked_out` AS `champs.checked_out`, `champs`.`checked_out_time` AS `champs.checked_out_time`, 
`champs`.`ordering` AS `champs.ordering`, `champs`.`params` AS `champs.params`, `champs`.`fieldparams` AS `champs.fieldparams`, `champs`.`language` AS 
`champs.language`, `champs`.`created_time` AS `champs.created_time`, `champs`.`created_user_id` AS `champs.created_user_id`, `champs`.`modified_time` AS `champs.modified_time`, `champs`.`modified_by` AS `champs.modified_by`, `champs`.`access` AS `champs.access` FROM `art_fields_values` AS `valeurs` LEFT JOIN `art_fields` AS `champs` ON `valeurs`.`field_id` = `champs`.`id` WHERE `valeurs`.`item_id` IN ('17');
                )

            [var] => Array
                (
                    [0] => Array
                        (
                            [restaurants] => Array
                                (
                                    [id] => 17
                                    [asset_id] => 88
                                    [title] => A la bonne franquette
                                    [alias] => a-la-bonne-franquette
                                    [introtext] => 
                                    [fulltext] => 
                                    [state] => 1
                                    [catid] => 8
                                    [created] => 2017-10-13 11:54:31
                                    [created_by] => 995
                                    [created_by_alias] => 
                                    [modified] => 2017-10-13 12:43:11
                                    [modified_by] => 990
                                    [checked_out] => 0
                                    [checked_out_time] => 0000-00-00 00:00:00
                                    [publish_up] => 2017-10-13 12:43:11
                                    [publish_down] => 0000-00-00 00:00:00
                                    [images] => {"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}
                                    [urls] => {"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}
                                    [attribs] => {"article_layout":"","show_title":"","link_titles":"","show_tags":"","show_intro":"","info_block_position":"","info_block_show_title":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_associations":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_page_title":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}
                                    [version] => 3
                                    [ordering] => 0
                                    [metakey] => 
                                    [metadesc] => 
                                    [access] => 1
                                    [hits] => 0
                                    [metadata] => {"robots":"","author":"","rights":"","xreference":""}
                                    [featured] => 0
                                    [language] => fr-FR
                                    [xreference] => 
                                )

                            [valeurs] => Array
                                (
                                    [0] => Array
                                        (
                                            [field_id] => 1
                                            [item_id] => 17
                                            [value] => 5
                                        )

                                    [1] => Array
                                        (
                                            [field_id] => 2
                                            [item_id] => 17
                                            [value] => 2
                                        )

                                )

                            [champs] => Array
                                (
                                    [0] => Array
                                        (
                                            [id] => 1
                                            [asset_id] => 87
                                            [context] => com_content.article
                                            [group_id] => 0
                                            [title] => Classement San Pellegrino
                                            [name] => cls-sanpellegrino
                                            [label] => Classement San Pellegrino
                                            [default_value] => 
                                            [type] => text
                                            [note] => 
                                            [description] => 
                                            [state] => 1
                                            [required] => 0
                                            [checked_out] => 0
                                            [checked_out_time] => 0000-00-00 00:00:00
                                            [ordering] => 0
                                            [params] => {"hint":"","render_class":"","class":"","showlabel":"1","show_on":"","display":"2"}
                                            [fieldparams] => {"filter":"integer","maxlength":""}
                                            [language] => *
                                            [created_time] => 2017-10-13 11:54:08
                                            [created_user_id] => 990
                                            [modified_time] => 0000-00-00 00:00:00
                                            [modified_by] => 0
                                            [access] => 1
                                        )

                                    [1] => Array
                                        (
                                            [id] => 2
                                            [asset_id] => 89
                                            [context] => com_content.article
                                            [group_id] => 0
                                            [title] => Classement Michelin
                                            [name] => cls-michelin
                                            [label] => Classement Michelin
                                            [default_value] => 
                                            [type] => text
                                            [note] => 
                                            [description] => 
                                            [state] => 1
                                            [required] => 0
                                            [checked_out] => 0
                                            [checked_out_time] => 0000-00-00 00:00:00
                                            [ordering] => 0
                                            [params] => {"hint":"","render_class":"","class":"","showlabel":"1","show_on":"","display":"2"}
                                            [fieldparams] => {"filter":"integer","maxlength":""}
                                            [language] => *
                                            [created_time] => 2017-10-13 12:42:55
                                            [created_user_id] => 990
                                            [modified_time] => 0000-00-00 00:00:00
                                            [modified_by] => 0
                                            [access] => 1
                                        )

                                )

                        )

                )

        )

)

thanks
Max_admin 13 Oct, 2017
Hi Christophe,

What kind of custom fields ? please give an example

Best regrads
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
webcrea 14 Oct, 2017
Hi Max,

All the native custom fields create via Joomla.

Best regards
Max_admin 20 Oct, 2017
Hi Christophe,

Joomla does not save the extra fields in the same content table and so getting their values will require a multi value join, you are doing it correctly but a PHP loop on the values may be necessary to add the extra fields values to the main list, maybe this feature will be added to the core in the future but currently its not available.

Best regards
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.