Clarification on filter[tag] operator for AND conditions in Joomla 5 Web Services API

[HuynhMi]

Hello Joomla team,

I'm using the Joomla 5 Web Services REST API to query articles by multiple tags. For example:

/api/index.php/v1/content/articles?filter[tag]=57,5

(docs: https://slides.woluweb.be/api/#multivalue)
This seems to return articles that match either tag (logical OR).

However, I would like to retrieve only the articles that contain all the specified tags (logical AND).

I've tried several variations, such as:

filter[tags]=57,209
filter[tags][]=57&filter[tags.operator]=AND

but none seem to apply the AND logic.

Could you please clarify:

Does the Joomla 5 API currently support AND filtering for multiple tags?

If not, is there any supported way or planned update to allow that functionality?

Where can I find the documentation or code reference for the operators used in filters (like filter[tags])?

Thank you for your help in understanding how tag filters are processed in Joomla’s core API.

[alikon]

You are right at this time the query use the IN() operator so logical OR, you can see the same behavior in Content > Articles in Joomla administrator see

joomla-cms/administrator/components/com_content/src/Model/ArticlesModel.php

Lines 462 to 492 in a3baa9a

	if ($tag && \is_array($tag)) {
	$tag = ArrayHelper::toInteger($tag);
	$subQuery = $db->getQuery(true)
	->select('DISTINCT ' . $db->quoteName('content_item_id'))
	->from($db->quoteName('#__contentitem_tag_map'))
	->where(
	[
	$db->quoteName('tag_id') . ' IN (' . implode(',', $query->bindArray($tag)) . ')',
	$db->quoteName('type_alias') . ' = ' . $db->quote('com_content.article'),
	]
	);
	$query->join(
	'INNER',
	'(' . $subQuery . ') AS ' . $db->quoteName('tagmap'),
	$db->quoteName('tagmap.content_item_id') . ' = ' . $db->quoteName('a.id')
	);
	} elseif ($tag = (int) $tag) {
	$query->join(
	'INNER',
	$db->quoteName('#__contentitem_tag_map', 'tagmap'),
	$db->quoteName('tagmap.content_item_id') . ' = ' . $db->quoteName('a.id')
	)
	->where(
	[
	$db->quoteName('tagmap.tag_id') . ' = :tag',
	$db->quoteName('tagmap.type_alias') . ' = ' . $db->quote('com_content.article'),
	]
	)
	->bind(':tag', $tag, ParameterType::INTEGER);

so right now we don't support logical AND

imho it should be a good new feature

[alikon]

@HuynhMi can you check #46325

[HuynhMi]

@alikon thank you for the quick update