How to pass array parameters to SQL queries in admin dashboard

[craftyweb]

Hi,

I'm currently struggling with passing arrays to SQL queries in the admin dashboard. When I call the query and I pass an array of content item ids to the query it returns an empty result.

This is the query

SELECT ci.DocumentId
FROM ContentItemIndex ci
{% if categories.size > 0 %}
INNER JOIN TaxonomyFieldIndex tfi ON ci.ContentItemId = tfi.ContentItemId
{% endif %}
WHERE ci.ContentType = 'NewsItem'
AND ci.Published = 1
{% if categories.size  > 0 %}
AND tfi.ContentField = 'Category'
AND tfi.TermContentItemId IN ({{ categories }}) 
{% endif %}
ORDER BY ci.CreatedUtc DESC
{% if limit > 0 %}
	LIMIT {{ limit }}
{% endif %}
{% if offset > 0 %}
	OFFSET {{ offset }}
{% endif %}

And this is how I call it in liquid

{% assign newsItems = Queries.NewsItems | query: limit: limit, offset: offset, categories: filterCategories %}

Does anyone know what's the best way to do this?

Thanks!

[hishamco]

I think you missed the query parameters prefix @. For more information please refer to https://docs.orchardcore.net/en/latest/reference/modules/Queries/#sql-parameters

[craftyweb]

Hi thanks for the response. Even with the @ prefix it's not working

[hishamco]

Try to run the query from the admin to ensure you have the expected result

[craftyweb]

Yes I'm trying to get the result like this before I implement this in the liquid template but it doesn't seem to work

[hishamco]

Forgot the Liquid for now, try to execute the query in the admin, then check the results