# Suche nach historischen Aufträgen

**URL:** <https://meta.discourse.org/t/searching-for-historical-assignments/228716>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [1. Juni 2022 um 09:10 UTC](https://meta.discourse.org/t/searching-for-historical-assignments/228716 "2022-06-01T09:10:14Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![michebs](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/michebs/32/190102_2.png) [@michebs](https://meta.discourse.org/u/michebs)\
**Post date:** [1. Juni 2022 um 18:44 UTC](https://meta.discourse.org/t/searching-for-historical-assignments/228716/3 "2022-06-01T18:44:07Z")

</div>

Sie können diese Daten mit dem [Data Explorer](https://meta.discourse.org/t/32566?silent=true) Plugin extrahieren.

Ich hoffe, die folgende Abfrage hilft Ihnen weiter.

###### 1. Listet alle Themen auf, die derzeit einer Gruppe zugewiesen sind

```sql
SELECT 
    g.name group_name,
    a.topic_id,
    a.assigned_by_user_id,
    a.created_at
FROM assignments a
INNER JOIN groups g ON g.id = a.assigned_to_id
WHERE assigned_to_type = 'Group'
ORDER BY g.name, created_at DESC

```

###### 2. Listet die Historie der Zuweisung von Themen zu Gruppen auf

```sql
SELECT 
    pcf.value AS group,
    p.topic_id,
    p.user_id AS "assigned_by_user_id",
    pcf.created_at::date
FROM posts p
INNER JOIN post_custom_fields pcf ON pcf.post_id = p.id
WHERE action_code = 'assigned_group'
    AND pcf.name = 'action_code_who'
ORDER BY pcf.value, pcf.created_at DESC

```

---

_[View the full topic](https://meta.discourse.org/t/searching-for-historical-assignments/228716)._