Desde que actualicé mi Discourse a la versión 3.5.0.beta3-dev, mi consulta para buscar temas resueltos ya no funciona correctamente.
Para encontrar temas resueltos, generalmente consulto la tabla topic_custom_fields en la columna name buscando que contenga accepted_answer_post_id.
select
users.username, count(distinct assignments.topic_id) as obligaciones
from assignments
inner join users on assignments.assigned_to_id=users.id
inner join topics on assignments.topic_id=topics.id
inner join categories on topics.category_id=categories.id
left outer join topic_custom_fields on topics.id=topic_custom_fields.topic_id and topic_custom_fields.name='accepted_answer_post_id'
where assignments.active=true
and assigned_to_type='User'
and deleted_at is null
and topics.closed=false
and topic_custom_fields.value is null
group by users.username
order by obligaciones desc
Pero ahora parece que la tabla topic_custom_fields no obtiene filas con el valor accepted_answer_post_id.
¿Dónde debería buscar ahora los temas resueltos/no resueltos?
Aquí está mi consulta en JSON:
{
"query": {
"id": 12,
"name": "Número de obligaciones por usuario",
"description": "Este es el número de obligaciones por usuario agrupadas",
"username": "admir",
"group_ids": [47],
"last_run_at": "2025-04-30T13:07:43.405Z",
"user_id": 5,
"sql": "\r\n\r\nselect \r\nusers.username, count(distinct assignments.topic_id) as obligaciones\r\nfrom assignments\r\ninner join users on assignments.assigned_to_id=users.id\r\ninner join topics on assignments.topic_id=topics.id\r\ninner join categories on topics.category_id=categories.id\r\nleft outer join topic_custom_fields on topics.id=topic_custom_fields.topic_id and topic_custom_fields.name='accepted_answer_post_id'\r\nwhere assignments.active=true\r\nand assigned_to_type='User'\r\nand deleted_at is null\r\nand topics.closed=false\r\nand topic_custom_fields.value is null\r\ngroup by users.username\r\norder by obligaciones desc",
"param_info": [],
"created_at": "2023-08-29T13:15:17.015Z",
"hidden": false
}
}