Good day,
How to correct enter sql command in the data source.
| Code: |
AND #__docman_categories.docman_category_id NOT IN (5,6,7)
|
I need to exclude certain categories docman if the site in English language , how to enter here an exception?
| 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`
WHERE
`#__docman_categories`.`access` IN {aid}
AND `#__docman_categories`.`enabled` = '1'
AND (`#__docman_documents`.`access` IN {aid} OR `#__docman_documents`.`access` = 0)
AND `#__docman_documents`.`enabled` = '1'
ORDER BY
`#__docman_categories`.`title` ASC,
`#__docman_documents`.`title` ASC
|
Thanks for the help,
Mikhail
