@recaptime-dev's working patches + fork for Phorge, a community fork of Phabricator. (Upstream dev and stable branches are at upstream/main and upstream/stable respectively.)
hq.recaptime.dev/wiki/Phorge
phorge
phabricator
1# This converts old conditions which use common fields like "body" to new
2# conditions which use modular rules like "Maniphest Task Description".
3
4UPDATE {$NAMESPACE}_herald.herald_condition c
5 JOIN {$NAMESPACE}_herald.herald_rule r
6 ON c.ruleID = r.id
7 SET c.fieldName = 'maniphest.task.title'
8 WHERE r.contentType = 'HeraldManiphestTaskAdapter'
9 AND c.fieldName = 'title';
10
11UPDATE {$NAMESPACE}_herald.herald_condition c
12 JOIN {$NAMESPACE}_herald.herald_rule r
13 ON c.ruleID = r.id
14 SET c.fieldName = 'maniphest.task.description'
15 WHERE r.contentType = 'HeraldManiphestTaskAdapter'
16 AND c.fieldName = 'body';
17
18UPDATE {$NAMESPACE}_herald.herald_condition c
19 JOIN {$NAMESPACE}_herald.herald_rule r
20 ON c.ruleID = r.id
21 SET c.fieldName = 'maniphest.task.author'
22 WHERE r.contentType = 'HeraldManiphestTaskAdapter'
23 AND c.fieldName = 'author';
24
25UPDATE {$NAMESPACE}_herald.herald_condition c
26 JOIN {$NAMESPACE}_herald.herald_rule r
27 ON c.ruleID = r.id
28 SET c.fieldName = 'maniphest.task.assignee'
29 WHERE r.contentType = 'HeraldManiphestTaskAdapter'
30 AND c.fieldName = 'assignee';