@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.revision.diff.affected'
5 WHERE r.contentType = 'differential'
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.revision.author'
12 WHERE r.contentType = 'differential'
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.revision.author.projects'
19 WHERE r.contentType = 'differential'
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.revision.diff.new'
26 WHERE r.contentType = 'differential'
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.revision.diff.content'
33 WHERE r.contentType = 'differential'
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.revision.diff.old'
40 WHERE r.contentType = 'differential'
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.revision.package'
47 WHERE r.contentType = 'differential'
48 AND c.fieldName = 'affected-package';
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.revision.repository'
54 WHERE r.contentType = 'differential'
55 AND c.fieldName = 'repository';
56
57UPDATE {$NAMESPACE}_herald.herald_condition c
58 JOIN {$NAMESPACE}_herald.herald_rule r
59 ON c.ruleID = r.id
60 SET c.fieldName = 'differential.revision.repository.projects'
61 WHERE r.contentType = 'differential'
62 AND c.fieldName = 'repository-projects';
63
64UPDATE {$NAMESPACE}_herald.herald_condition c
65 JOIN {$NAMESPACE}_herald.herald_rule r
66 ON c.ruleID = r.id
67 SET c.fieldName = 'differential.revision.reviewers'
68 WHERE r.contentType = 'differential'
69 AND c.fieldName = 'reviewers';
70
71UPDATE {$NAMESPACE}_herald.herald_condition c
72 JOIN {$NAMESPACE}_herald.herald_rule r
73 ON c.ruleID = r.id
74 SET c.fieldName = 'differential.revision.summary'
75 WHERE r.contentType = 'differential'
76 AND c.fieldName = 'body';
77
78UPDATE {$NAMESPACE}_herald.herald_condition c
79 JOIN {$NAMESPACE}_herald.herald_rule r
80 ON c.ruleID = r.id
81 SET c.fieldName = 'differential.revision.title'
82 WHERE r.contentType = 'differential'
83 AND c.fieldName = 'title';
84
85UPDATE {$NAMESPACE}_herald.herald_condition c
86 JOIN {$NAMESPACE}_herald.herald_rule r
87 ON c.ruleID = r.id
88 SET c.fieldName = 'differential.revision.package.owners'
89 WHERE r.contentType = 'differential'
90 AND c.fieldName = 'affected-package-owner';