You need to sign in to do that
Don't have an account?
anil Kumar
how to show child query count in lightning component
Hi All,
I have to show child query count in aura:iteration. Could anyone help me how to show child query count ?
Below is apex controller:
public without sharing class BH_LocationsListClass {
@AuraEnabled
public static List<SVMXC__Site__c> findAll() {
id persAccId;
Set<id> BusAcc = new Set<id>();
set<id> Locid = new set<id>();
List<id> SiteIds = new List<id>();
persAccId = [SELECT AccountID FROM User WHERE id = : UserInfo.getUserId()].AccountID;//0050V0000070hym UserInfo.getUserId()
List<Person_Account_Location_Association__c> AsscoBusList = [select BH_Business_Account__c from Person_Account_Location_Association__c where BH_Person_Account_Association__c =:persAccId];
system.debug('Account ID '+ persAccId);
if(AsscoBusList.size()>0){
for(Person_Account_Location_Association__c mainAcc : AsscoBusList){
BusAcc.add(mainAcc.BH_Business_Account__c);
}
}
List<SVMXC__Site__c> SiteList = [select name from SVMXC__Site__c where SVMXC__Account__c in:BusAcc];
for(SVMXC__Site__c sites :SiteList){
SiteIds.add(sites.id);
}
List<Person_Account_Location_Association__c> AsscolIst = [select BH_Location_Association__c from Person_Account_Location_Association__c where BH_Person_Account_Association__c =:persAccId and BH_Location_Association__c in: SiteIds];
system.debug('AsscolIst common'+AsscolIst);
if(AsscolIst.size()>0){
for(Person_Account_Location_Association__c mainAcc : AsscolIst){
Locid.add(mainAcc.BH_Location_Association__c);
}
}
system.debug('Locid common'+Locid);
List<SVMXC__Site__c> AssocLocationLocList = [select name,id,BH_Location_Address__c,Superior_Asset_Count__c,
SVMXC__Account__c,SVMXC__Account__r.name,SVMXC__City__c,
SVMXC__State__c,SVMXC__Country__c,
(select id,name,BH_US_SM_Superior_Asset__c from R00N70000001hzcqEAA__r where BH_US_SM_Superior_Asset__c!=null),
SVMXC__Zip__c from SVMXC__Site__c where id in:Locid];
system.debug('AssocLocationList common'+AssocLocationLocList);
String AssetCount;
for(SVMXC__Site__c acc : AssocLocationLocList){
AssetCount = String.valueOf(acc.R00N70000001hzcqEAA.size());
}
system.debug('Number of assets '+ AssetCount );
AssocLocationLocList.sort();
return AssocLocationLocList;
}
}
Thanks,
Anil Kumar
I have to show child query count in aura:iteration. Could anyone help me how to show child query count ?
Below is apex controller:
public without sharing class BH_LocationsListClass {
@AuraEnabled
public static List<SVMXC__Site__c> findAll() {
id persAccId;
Set<id> BusAcc = new Set<id>();
set<id> Locid = new set<id>();
List<id> SiteIds = new List<id>();
persAccId = [SELECT AccountID FROM User WHERE id = : UserInfo.getUserId()].AccountID;//0050V0000070hym UserInfo.getUserId()
List<Person_Account_Location_Association__c> AsscoBusList = [select BH_Business_Account__c from Person_Account_Location_Association__c where BH_Person_Account_Association__c =:persAccId];
system.debug('Account ID '+ persAccId);
if(AsscoBusList.size()>0){
for(Person_Account_Location_Association__c mainAcc : AsscoBusList){
BusAcc.add(mainAcc.BH_Business_Account__c);
}
}
List<SVMXC__Site__c> SiteList = [select name from SVMXC__Site__c where SVMXC__Account__c in:BusAcc];
for(SVMXC__Site__c sites :SiteList){
SiteIds.add(sites.id);
}
List<Person_Account_Location_Association__c> AsscolIst = [select BH_Location_Association__c from Person_Account_Location_Association__c where BH_Person_Account_Association__c =:persAccId and BH_Location_Association__c in: SiteIds];
system.debug('AsscolIst common'+AsscolIst);
if(AsscolIst.size()>0){
for(Person_Account_Location_Association__c mainAcc : AsscolIst){
Locid.add(mainAcc.BH_Location_Association__c);
}
}
system.debug('Locid common'+Locid);
List<SVMXC__Site__c> AssocLocationLocList = [select name,id,BH_Location_Address__c,Superior_Asset_Count__c,
SVMXC__Account__c,SVMXC__Account__r.name,SVMXC__City__c,
SVMXC__State__c,SVMXC__Country__c,
(select id,name,BH_US_SM_Superior_Asset__c from R00N70000001hzcqEAA__r where BH_US_SM_Superior_Asset__c!=null),
SVMXC__Zip__c from SVMXC__Site__c where id in:Locid];
system.debug('AssocLocationList common'+AssocLocationLocList);
String AssetCount;
for(SVMXC__Site__c acc : AssocLocationLocList){
AssetCount = String.valueOf(acc.R00N70000001hzcqEAA.size());
}
system.debug('Number of assets '+ AssetCount );
AssocLocationLocList.sort();
return AssocLocationLocList;
}
}
Thanks,
Anil Kumar