Re:How to correct enter sql command in the data source - Post #5984

Categories

Forum

All forums Threaded View

Welcome, Guest
Please Login to access forum.

- Joomla! Extensions Store

Re:How to correct enter sql command in the data source (1 viewing)

TOPIC: Re:How to correct enter sql command in the data source

#5983

Mikhail

Fresh Boarder

Posts: 6

How to correct enter sql command in the data source Karma: 0

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

Logged

The administrator has disabled public write access.

#5984

Mikhail

Fresh Boarder

Posts: 6

Re:How to correct enter sql command in the data source	Karma: 0
Close topic please. I found as.

Logged

The administrator has disabled public write access.

#5985

John Dagelmore

Admin

Posts: 3873

Re:How to correct enter sql command in the data source	Karma: 84
Good day, Docman has not assignment of documents to language, so you can't make an exception by language in the sql query. All you can do is create a separate data source and use it for English only. For exclusions of categories, ity's ok the query that you posted. You can simply use the settings of the data source as in the screenshot. Best regards John

Logged

The administrator has disabled public write access.

#5986

John Dagelmore

Admin

Posts: 3873

Re:How to correct enter sql command in the data source	Karma: 84
Closed.

Logged

The administrator has disabled public write access.

Forum List

Extensions

JSitemap