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!

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...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
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...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
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