Hi, anyone can help me how to call ApprovarId variable from JavaScript to Apex controller to replace value = :ActorId in query?
export default class ToApproved extends LightningElement {
ApprovarId= Id;
availableItems;
error;
columns = columns;
@wire (toApproved)
wiredAccount({error,data}){
if(data){
let tempRecs = [];
data.forEach((record)=>{
let tempRec = Object.assign({},record);
//Name & target object id
var objDes = JSON.stringify(tempRec.ProcessInstance.TargetObject);
var finalObject = JSON.parse(objDes);
tempRec.Object = '/'+tempRec.ProcessInstance.TargetObjectId;
tempRec.recordName = finalObject.Name;
//Name & created/submitted user id
var createduser = JSON.stringify(tempRec.CreatedBy);
var finalData = JSON.parse(createduser);
tempRec.CreatedBy = '/'+tempRec.CreatedById;
tempRec.createdByName = finalData.Name;
//Name and approverid
var approvar = JSON.stringify(tempRec.Actor);
var finalApprovar = JSON.parse(approvar);
tempRec.ApprovedBy = '/'+finalApprovar.name;
tempRec.ApprovarName = tempRec.Actor.Name;
tempRecs.push(tempRec);
});
this.availableItems = tempRecs;
this.error = undefined;
}else if(error){
this.error = error;
this.availableItems = undefined;
}
}
}
public with sharing class toApproved {
@AuraEnabled(cacheable=true)
public static list<ProcessInstanceWorkitem> getItemApprove(id ActorId){
return[select ProcessInstance.TargetObject.name, CreatedDate, CreatedBy.name, ActorId, Actor.name from ProcessInstanceWorkitem
where ActorId = :ActorId
order by CreatedDate limit 100];
}
}
Hi, need your help to check on this code. This code does not give me the expected result. By right object should display all record name and submitted y should display user name. But both field should be can clock and redirect to its record
Apex class
public with sharing class toApproved {
@AuraEnabled(cacheable=true)
public static list<ProcessInstanceWorkitem> getItemApprove(){
return[select id, CreatedById,ProcessInstance.TargetObject.name,ProcessInstance.TargetObjectId,CreatedDate,CreatedBy.name from ProcessInstanceWorkitem order by CreatedDate limit 100];
}
}
Anyone can assist me with the code coverage for this class?
trigger CheckUserforBooth on Booth__c (after insert, before update) {
List<booth__c> id=new List<booth__c>();
for(Booth__c B : Trigger.new) {
id=[select Tradeshow_Name__r.pic_1__r.id,Tradeshow_Name__r.pic_2__r.id from booth__c where Tradeshow_Name__c =: B.Tradeshow_Name__c];
Id profileId = UserInfo.getProfileId();
String profileName =[Select Id, Name from Profile where Id=:profileId].Name;
system.debug('Profile Name'+profileName);
if(UserInfo.getUserId() <> id[0].Tradeshow_Name__r.pic_1__r.id
&& UserInfo.getUserId() <> id[0].Tradeshow_Name__r.pic_2__r.id
&& profileName<> 'User1')
{
B.addError('You are not allowed to Save');
}
}
}
Hi, my scenario I have 3 objects here. payment term credit limit, sales order and vehicle. let's say when users create new payment term records, the vehicle records will auto-populate based on the sales order. This code is working well for after insert only. but is I put After insert and after update, the vehicle records become double (duplicate value)
trigger CreateSOonPtcl on Payment_Term_Credit_Limit__c (after insert, after update) {
set<Id> lstId = new set<Id>();
set<date> startDate = New set<date>();
set<date> endDate = New set<date>();
List <Vehicle__c> vehToInsert = new List <Vehicle__c>();
for (Payment_Term_Credit_Limit__c o : Trigger.new) {
//meets the criteria
if (o.Category__c == 'Increase / Decrease Credit Limit') {
lstId.add(o.Name_of_Customer__c);
startDate.add(o.Start_Order_Date__c);
endDate.add(o.End_Order_Date__c);
}
}
list<Sales_Order__c> lstOb1 =[select Id,Requested_Delivery_Date__c, account__c, Name,Po_No__c,Total_Qty_Pcs__c,Total_Amount_USD__c,Currency__c from Sales_Order__c where Account__c IN :lstId AND Status__c = 'E0005 ZSHP' and Order_Date__c >= :startDate and Order_Date__c <= :endDate order by CreatedDate ];
for (Payment_Term_Credit_Limit__c oo : Trigger.new) {
for(integer i=0; i<lstOb1.size(); i++){
Vehicle__c v = new Vehicle__c ();
v.Payment_Term_Credit_Limit__c = oo.id;
V.Sales_Order__c = lstOb1[i].Id;
vehToInsert.add(v);
}
}
try {
insert vehToInsert;
} catch (system.Dmlexception e) {
system.debug (e);
}
}
please help me with this. I think It is because this code in loop
Hi, we have created mass upload records using CSV file. but when we upload the file, the owner name will be the one who uploads the CSV. May I know how to make a record owner name based on the name that has in the CSV file? Any code that can refer?
