[logical AND ...] Displaying articles for only specific tags

milind.purandare
Topic Author
Offline
Premium Member

10 years 2 months ago #45272 by milind.purandare

[logical AND ...] Displaying articles for only specific tags was created by milind.purandare

Hi

I want to use Universal Module (or is there any other way?) to display articles belonging to specifically selected tags. Like say "washington" and "teachers" ... (or could be a longer list of tags)

Only those articles which have both the tags should be displayed. Is that possible?

Thanks in anticipation of your early response.

Please Log in or Create an account to join the conversation.

micker
Offline
Administrator

10 years 2 months ago #45284 by micker

Replied by micker on topic [logical AND ...] Displaying articles for only specific tags

realy simple .. in universal mudole use scope tags to display (use uinclude option) only what you want

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

milind.purandare
Topic Author
Offline
Premium Member

10 years 2 months ago #45293 by milind.purandare

Replied by milind.purandare on topic [logical AND ...] Displaying articles for only specific tags

Thanks

I tried that with "include" in "tags scope". It does not do logical a "AND" between the tags as I need it. It does a "OR"

Am I doing something wrong?

How do I show articles which have BOTH / ALL tags specified.

A million thanks in anticipation

Please Log in or Create an account to join the conversation.

micker
Offline
Administrator

10 years 2 months ago #45297 by micker

Replied by micker on topic [logical AND ...] Displaying articles for only specific tags

did you read tool tips ??

Please Log in or Create an account to join the conversation.

milind.purandare
Topic Author
Offline
Premium Member

10 years 2 months ago #45298 by milind.purandare

Replied by milind.purandare on topic [logical AND ...] Displaying articles for only specific tags

seems I am missing something simple?

I am not able to logically "AND" the tags ...

plss help ....

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

10 years 2 months ago #45317 by ggppdk

Replied by ggppdk on topic [logical AND ...] Displaying articles for only specific tags

Hello

yes now it is a logical "OR"

ok , since this is small change
and since these days we were enhancing 2 other SCOPEs
very useful SCOPEs of universal module
(date ... and (new) Dynamic custom field scope that compare any field to the currently view item)

- i will add a new parameter for a logical "AND"
new final version is coming in 10-15 , (it is ready now but beta)

but note this will make query SLOWER !!
how much, not sure !

- parameter will state that it is slower

to test it now, edit helper.php of the module and
replace

Code:

$query2 = 'SELECT DISTINCT itemid'
	. ' FROM #__flexicontent_tags_item_relations'
	. ' WHERE tid IN ('.implode(',', $tag_ids).')'
	;

with:

Code:

$query2 = 'SELECT itemid'
	. ' FROM #__flexicontent_tags_item_relations'
	. ' WHERE tid IN ('.implode(',', $tag_ids).')'
	. ' GROUP BY itemid HAVING COUNT(*) >= '.count($tag_ids)
	;

after you install final remember to enable new parameter

Regards

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.