Hi Franck,
you can simply edit the SQL string for example, copy and paste the below string and click the 'Save and close' button in the data source:
| Code: |
SELECT `#__docman_documents`.`title`, CONCAT_WS('-',`#__docman_documents`.`docman_document_id`,`#__docman_documents`.`slug`) AS `alias`, `#__docman_categories`.`title` AS `cattitle`, `#__docman_categories`.`slug` AS `category_slug` FROM `#__docman_documents` JOIN `#__docman_categories` ON `#__docman_documents`.`docman_category_id` = `#__docman_categories`.`docman_category_id` JOIN `#__docman_category_relations` ON `#__docman_categories`.`docman_category_id` = `#__docman_category_relations`.`descendant_id` WHERE `#__docman_categories`.`enabled` = '1' AND `#__docman_category_relations`.`ancestor_id` = '1' ORDER BY `#__docman_categories`.`created_on` ASC, `#__docman_documents`.`title` ASC
|
After that check if documents are included in the sitemap
John
