Hi all, I'm working on maintaining the Email Message Status. I appreciate if anyone knows how you can change New => Replied by apex.
I made a datatable of EmailMessages (works like email Inbox) and trigger onrowaction to update the email status from New => Read by Apex. However, I never know i we can change from New => Replied.
You can change manually press the button "Reply" or "Reply All" on each email record but this forces the users to leave the Email Mesage datatable and go to the Email Mesage record.
Chatter on Files/ContentDocument in Lightning is not available UNLESS you upload a new version of the File. Does anyone know how to generate a new FeedItem with parentId is ContentDocumentId by flow/Apex?
I tested as follows:
1) SUCCESS Simple post a chatter post, successfully made a new FeedItem.
FeedItem fi = new FeedItem();
fi.Body = 'Hello There';
fi.Title = 'File Name';
fi.parentId = '00510000000me1VAAQ'; // UserId
insert fi;
2) FAILURE Chatter post with ParentId with ContentDocumentId is failed.
FeedItem fi = new FeedItem();
fi.Body = 'Hello There';
fi.Title = 'File Name';
fi.parentId = '0691000000Krzl1AAB'; //ContentDocumentId
insert fi;
I analyzed the FeedItem by a new Version, it shows the FeedItem as follows: Id (feedItemId) : 0D510000047U2i1CAC ParentId (File) : 0691000000Krzl1AAB Type : TrackedChange
This may be because that the FeedItem is automatically generated by the Type "TrackedChange" upon a new Version is inserted. But TrackedChanged can't be inserted directly by Apex
Type "TextPost" is no enabled for ContentDocument.
I have difficulty to set the boder 0 on <div force-alohapage_alohapage... >. css doesn't work on this DOM, but in the Chrome Inspector, I can set the border 0 to hide the hair-thin white border...
Hi all, if anyone spot what is the cause of in the following code error? debug log tells me that is "argument can not be null."
and it seems it null pointer exception issue in the loop of for (Billing__c due : dueBillings) part, but not sure what can fix this.
The logic is Apex Controller is called by controller.js fetchDueBalance method, pass the return value to the controller.js, then set component dueBalance (Decimal) in the component.
Apex Controller
@AuraEnabled
public static Decimal fetchDueBalance(Id recordId) {
// check which object started the apex class
Decimal dueBalance;
String sObjName = recordId.getSObjectType().getDescribe().getName();
List<Billing__c> dueBillings = new List<Billing__c>();
System.debug('dueBlalance: initial point: ' + dueBalance); //passed
if (sObjName == 'Billing__c') {
Billing__c bl = [
SELECT Id, Case__c
FROM Billing__c
WHERE Id =:recordId
LIMIT 1
];
dueBillings = [
SELECT Id, Due_Balance__c
FROM Billing__c
WHERE Case__c = :bl.Case__c AND Due_Balance__c !=0 AND User_Due_Date__c < :Date.today()
ORDER BY User_Due_Date__c ASC
];
System.debug('dueBlalance: list search: ' + dueBalance); // passed
if (dueBillings != null){
System.debug('dueBlalance: nullcheck: ' + dueBalance); // passed
dueBalance = 0;
for (Billing__c due: dueBillings) {
dueBalance += due.Due_Balance__c;
System.debug('dueBlalance: loop point: ' + dueBalance); /passed
}
}
}
return dueBalance;
}
It passes to the final debug log, but not returning the dueBalance value (Decimal) to the component via controller.
({
doInit: function(component, event, helper) {
//call apex class method
var recordId = component.get("v.recordId");
var action = component.get('c.fetchBillings');
action.setParams({recordId :recordId});
action.setCallback(this, function(response) {
var state = response.getState();
if (state === "SUCCESS") {
component.set('v.billings', response.getReturnValue());
}
});
$A.enqueueAction(action);
/* action1 for the sumup number of the overdue billings */
var recordId = component.get("v.recordId");
var action = component.get('c.fetchDueBalance');
action.setParams({recordId :recordId});
action.setCallback(this, function(response) {
//store state of response
var state = response.getState();
if (state === "SUCCESS") {
component.set('v.dueBalance', response.getReturnValue());
}
});
$A.enqueueAction(action);
},
})
Hi all, I'm working on get the current record with some fields (Name, Current_Balance__c) by <force:recordData /> in aura component. How do we get the value from Controller and update the record field?
({
init: function(component, event, helper) {
var today = $A.localizationService.formatDate(new Date(), "YYYY-MM-DD");
component.set('v.today', today);
var accountRecord = component.get("v.accountRecord");
var recordId = component.get ("v.recordId");
var action = component.get("c.sumBalance");
action.setParams({recordId:recordId});
action.setCallback(this, function(response){
let state = response.getState();
if (state === "SUCCESS") {
component.set("v.sumBalance",response.getReturnValue());
component.set("v.accountRecord.Current_Balance__c",sumBalance.bl);
component.find("recordLoader").reloadRecord();
} else {
console.log("Failed with state: " + state);
}
});
$A.enqueueAction(action);
},
})
Apex Contorller
public with sharing class DueBalanceController{
@AuraEnabled
public static Object sumBalance (String recordId){
Date d_today = system.Date.today();
AggregateResult[] groupedResults = [
SELECT SUM(Balance__c)bl,SUM(Paid_Total__c)pt,SUM(Billing_Total__c)bt, Tenant__c
FROM Billing__c
WHERE Tenant__c = :recordId AND (User_Due_Date__c <= :d_today OR Paid_Date__c <=:d_today) AND (Status__c='Unpaid' OR Status__c='Paid' OR Status__c='Captured' OR Status__c ='Chasing Overdue')
GROUP BY Tenant__c
];
return groupedResults[0];
}
}
I want to tweak when I click the "view detail" button then open in a new tab (or open in background tab) instead of refreshing the same tab I was looking at. If anyone has any idea how to open in a new tab, please adivice.
I sense the issue is in the bottom part of the AccountListController.js Thanks!
I'm working on Apex Test Class. If anyone knows the problem the below test code. Thanks!
The Class is returning Object sumBalance withSUM values (alias: bl, bt, pt) from SOQL and component receives {v.sumBalance.bl}, {v.sumBalance.bt}, {v.sumBalance.pt}. These are working fine. But can't figure out how to test this Class....
Class
public with sharing class DueBalanceController{
@AuraEnabled
public static Object sumBalance (String recordId){
Date d_today = system.Date.today();
AggregateResult[] groupedResults = [
SELECT SUM(Balance__c)bl,SUM(Paid_Total__c)pt,SUM(Billing_Total__c)bt, Tenant__c
FROM Billing__c
WHERE Tenant__c = :recordId AND User_Due_Date__c <= :d_today AND (Status__c='Unpaid' OR Status__c='Paid' OR Status__c='Captured')
GROUP BY Tenant__c
];
Object sumAmount = groupedResults[0];
return sumAmount;
}
}
Chatter on Files/ContentDocument in Lightning is not available UNLESS you upload a new version of the File. Does anyone know how to generate a new FeedItem with parentId is ContentDocumentId by flow/Apex?
I tested as follows:
1) SUCCESS Simple post a chatter post, successfully made a new FeedItem.
FeedItem fi = new FeedItem();
fi.Body = 'Hello There';
fi.Title = 'File Name';
fi.parentId = '00510000000me1VAAQ'; // UserId
insert fi;
2) FAILURE Chatter post with ParentId with ContentDocumentId is failed.
FeedItem fi = new FeedItem();
fi.Body = 'Hello There';
fi.Title = 'File Name';
fi.parentId = '0691000000Krzl1AAB'; //ContentDocumentId
insert fi;
I analyzed the FeedItem by a new Version, it shows the FeedItem as follows: Id (feedItemId) : 0D510000047U2i1CAC ParentId (File) : 0691000000Krzl1AAB Type : TrackedChange
This may be because that the FeedItem is automatically generated by the Type "TrackedChange" upon a new Version is inserted. But TrackedChanged can't be inserted directly by Apex
Type "TextPost" is no enabled for ContentDocument.
Hi all, if anyone spot what is the cause of in the following code error? debug log tells me that is "argument can not be null."
and it seems it null pointer exception issue in the loop of for (Billing__c due : dueBillings) part, but not sure what can fix this.
The logic is Apex Controller is called by controller.js fetchDueBalance method, pass the return value to the controller.js, then set component dueBalance (Decimal) in the component.
Apex Controller
@AuraEnabled
public static Decimal fetchDueBalance(Id recordId) {
// check which object started the apex class
Decimal dueBalance;
String sObjName = recordId.getSObjectType().getDescribe().getName();
List<Billing__c> dueBillings = new List<Billing__c>();
System.debug('dueBlalance: initial point: ' + dueBalance); //passed
if (sObjName == 'Billing__c') {
Billing__c bl = [
SELECT Id, Case__c
FROM Billing__c
WHERE Id =:recordId
LIMIT 1
];
dueBillings = [
SELECT Id, Due_Balance__c
FROM Billing__c
WHERE Case__c = :bl.Case__c AND Due_Balance__c !=0 AND User_Due_Date__c < :Date.today()
ORDER BY User_Due_Date__c ASC
];
System.debug('dueBlalance: list search: ' + dueBalance); // passed
if (dueBillings != null){
System.debug('dueBlalance: nullcheck: ' + dueBalance); // passed
dueBalance = 0;
for (Billing__c due: dueBillings) {
dueBalance += due.Due_Balance__c;
System.debug('dueBlalance: loop point: ' + dueBalance); /passed
}
}
}
return dueBalance;
}
It passes to the final debug log, but not returning the dueBalance value (Decimal) to the component via controller.
({
doInit: function(component, event, helper) {
//call apex class method
var recordId = component.get("v.recordId");
var action = component.get('c.fetchBillings');
action.setParams({recordId :recordId});
action.setCallback(this, function(response) {
var state = response.getState();
if (state === "SUCCESS") {
component.set('v.billings', response.getReturnValue());
}
});
$A.enqueueAction(action);
/* action1 for the sumup number of the overdue billings */
var recordId = component.get("v.recordId");
var action = component.get('c.fetchDueBalance');
action.setParams({recordId :recordId});
action.setCallback(this, function(response) {
//store state of response
var state = response.getState();
if (state === "SUCCESS") {
component.set('v.dueBalance', response.getReturnValue());
}
});
$A.enqueueAction(action);
},
})
Hi all, I'm working on get the current record with some fields (Name, Current_Balance__c) by <force:recordData /> in aura component. How do we get the value from Controller and update the record field?
({
init: function(component, event, helper) {
var today = $A.localizationService.formatDate(new Date(), "YYYY-MM-DD");
component.set('v.today', today);
var accountRecord = component.get("v.accountRecord");
var recordId = component.get ("v.recordId");
var action = component.get("c.sumBalance");
action.setParams({recordId:recordId});
action.setCallback(this, function(response){
let state = response.getState();
if (state === "SUCCESS") {
component.set("v.sumBalance",response.getReturnValue());
component.set("v.accountRecord.Current_Balance__c",sumBalance.bl);
component.find("recordLoader").reloadRecord();
} else {
console.log("Failed with state: " + state);
}
});
$A.enqueueAction(action);
},
})
Apex Contorller
public with sharing class DueBalanceController{
@AuraEnabled
public static Object sumBalance (String recordId){
Date d_today = system.Date.today();
AggregateResult[] groupedResults = [
SELECT SUM(Balance__c)bl,SUM(Paid_Total__c)pt,SUM(Billing_Total__c)bt, Tenant__c
FROM Billing__c
WHERE Tenant__c = :recordId AND (User_Due_Date__c <= :d_today OR Paid_Date__c <=:d_today) AND (Status__c='Unpaid' OR Status__c='Paid' OR Status__c='Captured' OR Status__c ='Chasing Overdue')
GROUP BY Tenant__c
];
return groupedResults[0];
}
}
I want to tweak when I click the "view detail" button then open in a new tab (or open in background tab) instead of refreshing the same tab I was looking at. If anyone has any idea how to open in a new tab, please adivice.
I sense the issue is in the bottom part of the AccountListController.js Thanks!
I'm working on Apex Test Class. If anyone knows the problem the below test code. Thanks!
The Class is returning Object sumBalance withSUM values (alias: bl, bt, pt) from SOQL and component receives {v.sumBalance.bl}, {v.sumBalance.bt}, {v.sumBalance.pt}. These are working fine. But can't figure out how to test this Class....
Class
public with sharing class DueBalanceController{
@AuraEnabled
public static Object sumBalance (String recordId){
Date d_today = system.Date.today();
AggregateResult[] groupedResults = [
SELECT SUM(Balance__c)bl,SUM(Paid_Total__c)pt,SUM(Billing_Total__c)bt, Tenant__c
FROM Billing__c
WHERE Tenant__c = :recordId AND User_Due_Date__c <= :d_today AND (Status__c='Unpaid' OR Status__c='Paid' OR Status__c='Captured')
GROUP BY Tenant__c
];
Object sumAmount = groupedResults[0];
return sumAmount;
}
}
