@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
1UPDATE {$NAMESPACE}_herald.herald_condition c
2 JOIN {$NAMESPACE}_herald.herald_rule r
3 ON c.ruleID = r.id
4 SET c.fieldName = 'differential.diff.affected'
5 WHERE r.contentType = 'differential.diff'
6 AND c.fieldName = 'diff-file';
7
8UPDATE {$NAMESPACE}_herald.herald_condition c
9 JOIN {$NAMESPACE}_herald.herald_rule r
10 ON c.ruleID = r.id
11 SET c.fieldName = 'differential.diff.author'
12 WHERE r.contentType = 'differential.diff'
13 AND c.fieldName = 'author';
14
15UPDATE {$NAMESPACE}_herald.herald_condition c
16 JOIN {$NAMESPACE}_herald.herald_rule r
17 ON c.ruleID = r.id
18 SET c.fieldName = 'differential.diff.author.projects'
19 WHERE r.contentType = 'differential.diff'
20 AND c.fieldName = 'authorprojects';
21
22UPDATE {$NAMESPACE}_herald.herald_condition c
23 JOIN {$NAMESPACE}_herald.herald_rule r
24 ON c.ruleID = r.id
25 SET c.fieldName = 'differential.diff.new'
26 WHERE r.contentType = 'differential.diff'
27 AND c.fieldName = 'diff-added-content';
28
29UPDATE {$NAMESPACE}_herald.herald_condition c
30 JOIN {$NAMESPACE}_herald.herald_rule r
31 ON c.ruleID = r.id
32 SET c.fieldName = 'differential.diff.content'
33 WHERE r.contentType = 'differential.diff'
34 AND c.fieldName = 'diff-content';
35
36UPDATE {$NAMESPACE}_herald.herald_condition c
37 JOIN {$NAMESPACE}_herald.herald_rule r
38 ON c.ruleID = r.id
39 SET c.fieldName = 'differential.diff.old'
40 WHERE r.contentType = 'differential.diff'
41 AND c.fieldName = 'diff-removed-content';
42
43UPDATE {$NAMESPACE}_herald.herald_condition c
44 JOIN {$NAMESPACE}_herald.herald_rule r
45 ON c.ruleID = r.id
46 SET c.fieldName = 'differential.diff.repository'
47 WHERE r.contentType = 'differential.diff'
48 AND c.fieldName = 'repository';
49
50UPDATE {$NAMESPACE}_herald.herald_condition c
51 JOIN {$NAMESPACE}_herald.herald_rule r
52 ON c.ruleID = r.id
53 SET c.fieldName = 'differential.diff.repository.projects'
54 WHERE r.contentType = 'differential.diff'
55 AND c.fieldName = 'repository-projects';