From 17bd5b18e21c9f46aefdbf3400262764f0def4da Mon Sep 17 00:00:00 2001
From: yumenghui <953181891@qq.com>
Date: 星期五, 04 八月 2023 15:12:14 +0800
Subject: [PATCH] 触发器附件修改
---
force-app/main/default/triggers/TemporaryFileBoxUpdate.trigger | 15 +++++++++++----
1 files changed, 11 insertions(+), 4 deletions(-)
diff --git a/force-app/main/default/triggers/TemporaryFileBoxUpdate.trigger b/force-app/main/default/triggers/TemporaryFileBoxUpdate.trigger
index caec312..813487e 100644
--- a/force-app/main/default/triggers/TemporaryFileBoxUpdate.trigger
+++ b/force-app/main/default/triggers/TemporaryFileBoxUpdate.trigger
@@ -7,12 +7,19 @@
}
}
if (tfbIds.size() > 0) {
+ // List<ContentDocumentLink> linkList = [SELECT LinkedEntityId,ContentDocumentId FROM ContentDocumentLink WHERE LinkedEntityId IN: tfbIds];
Map<Id, AggregateResult> arMap = new Map<Id, AggregateResult>(
- [SELECT ParentId Id, Count(Id) Cnt_Id
- FROM Attachment
- WHERE ParentId IN :tfbIds
- GROUP BY ParentId
+ [SELECT LinkedEntityId Id, Count(ContentDocumentId) Cnt_Id
+ FROM ContentDocumentLink
+ WHERE LinkedEntityId IN :tfbIds
+ GROUP BY LinkedEntityId
]);
+ // Map<Id, AggregateResult> arMap = new Map<Id, AggregateResult>(
+ // [SELECT ParentId Id, Count(Id) Cnt_Id
+ // FROM Attachment
+ // WHERE ParentId IN :tfbIds
+ // GROUP BY ParentId
+ // ]);
for(TemporaryFileBox__c tfb : Trigger.new) {
AggregateResult ar = arMap.get(tfb.Id);
if (ar == null || Integer.valueOf(ar.get('Cnt_Id')) == 0) {
--
Gitblit v1.9.1