Salesforce Developer Community

Chatter

Feed
0

Best Answers
1

Likes Received
0

Likes Given
8

Questions
12

Replies

How to show message when data is empty in lightning datatable

I want to show a data in table form if data was there and a message if there is no data for this account

public class AccountController{
@AuraEnabled
public static List <Account> fetchAccounts(record Id) {
//Qyery 10 accounts
List<Account> accList = [SELECT Id, Name, BillingState,
Website, Phone, Industry, Type from Account where Name=:redId];
//return list of accounts
return accList;
}
}

<aura:component controller="AccountController">

<aura:attribute type="Account[]" name="acctList"/>
<aura:attribute name="mycolumns" type="List"/>

<aura:handler name="init" value="{!this}" action="{!c.fetchAcc}"/>

<lightning:datatable data="{! v.acctList }"
columns="{! v.mycolumns }"
keyField="id"
hideCheckboxColumn="true"/>

</aura:component>

({
fetchAcc : function(component, event, helper) {
helper.fetchAccHelper(component, event, helper);
}
})

({
fetchAccHelper : function(component, event, helper) {
component.set('v.mycolumns', [
{label: 'Account Name', fieldName: 'Name', type: 'text'},
{label: 'Industry', fieldName: 'Industry', type: 'text'},
{label: 'Phone', fieldName: 'Phone', type: 'Phone'},
{label: 'Website', fieldName: 'Website', type: 'url '}
]);
var action = component.get("c.fetchAccounts");
action.setParams({
  recId: component.get("v.recordId")
});
action.setCallback(this, function(response){
var state = response.getState();
if (state === "SUCCESS") {
component.set("v.acctList", response.getReturnValue());
}
});
$A.enqueueAction(action);
}
})

.12
September 09, 2021
Like
0

1 replies

column sorting in lightning datatable getting data.sort is not a function don't know where i missed

I was getting the above error while i was trying to sort the data in datatable

Component:

<aura:component controller="DataController" implements="force:appHostable,flexipage:availableForAllPageTypes,flexipage:availableForRecordHome,force:hasRecordId,forceCommunity:availableForAllPageTypes,force:lightningQuickActionWithoutHeader,lightning:availableForFlowScreens" access="global" >

<aura:attribute type="sobject" name="acctList"/>
<aura:attribute name="mycolumns" type="List"/>
<aura:attribute name="sortedBy" type="String" default="Name"/>
<aura:attribute name="sortedDirection" type="String" default="asc"/>

<aura:handler name="init" value="{!this}" action="{!c.fetchAccounts}"/>

<lightning:datatable data="{!v.acctList.stocks}"
columns="{!v.mycolumns}"
keyField="id"
hideCheckboxColumn="true"
onsort="{!c.updateColumnSorting}"
sortedBy="{!v.sortedBy}"
sortedDirection="{!v.sortedDirection}"/>
</aura:component>

Controller:

({
fetchAccounts : function(component, event, helper) {
component.set('v.mycolumns', [ {label: 'Stock Name', fieldName: 'stockName', type: 'text', sortable: true},
{label: 'Stock', fieldName: 'stock', type: 'text', sortable: true},
{label: 'Total Share', fieldName: 'totalShare', type: 'text', sortable: true}
]);
var action = component.get("c.dataFetch");
action.setParams({
});
action.setCallback(this, function(response){
var state = response.getState();
if (state === "SUCCESS") {
component.set("v.acctList", response.getReturnValue());
helper.sortData(component, component.get("v.sortedBy"), component.get("v.sortedDirection"));
}
});
$A.enqueueAction(action);
},
updateColumnSorting: function (cmp, event, helper) {
var fieldName = event.getParam('fieldName');
var sortDirection = event.getParam('sortDirection');
cmp.set("v.sortedBy", fieldName);
cmp.set("v.sortedDirection", sortDirection);
helper.sortData(cmp, fieldName, sortDirection);
}
})

Helper:

({
sortData: function (cmp, fieldName, sortDirection) {
var data = cmp.get("v.acctList");
var reverse = sortDirection !== 'asc';
data.sort(this.sortBy(fieldName, reverse));
cmp.set("v.acctList", data);
},
sortBy: function (field, reverse, primer) {
var key = primer ?
function(x) {return primer(x[field])} :
function(x) {return x[field]};
reverse = !reverse ? 1 : -1;
return function (a, b) {
return a = key(a), b = key(b), reverse * ((a > b) - (b > a));
}
}
})

Apex:
public class DataController {
@AuraEnabled
public static DataWrapper dataFetch(){
try{
  String json = '{\"accountName\": \"RAM REDDY\",\"registrationId\": \"501049438\",\"accountType\": \"Savings\",\"openDate\": \"08/24/2021\",\"allowedTransactions\": [\"Send\",\"Recieve\",\"Manage\"],\"address\": {\"addressLine1\": \"\",\"addressLine2\": \"\",\"addressLine3\": \"\"},\"stocks\": [{\"stock\": \"BTC\",\"stockName\": \"Bitcoin\",\"stockNumber\": \"051\",\"accountNumber\": \"12000012653\",\"currentValue\": \"161293.80\",\"totalShare\": \"5367.514\", \"totalCost\": \"134931.56089999998\",\"minimumInvestment\": \"200.000000000000\"},{\"stock\": \"LTC\",\"stockName\": \"Litecoin\",\"stockNumber\": \"052\",\"accountNumber\": \"3338493\",\"currentValue\": \"324.80\",\"totalShare\": \"545.514\", \"totalCost\": \"2242.56089999998\",\"minimumInvestment\": \"50.000000000000\"}],\"accountClosedStatus\": false,\"totalCurrentValue\": 170790.31}';
DataWrapper responseWrapper = DataWrapper.parse(json);
return responseWrapper;
} catch(Exception ex){
System.debug('Error occured while fetching the documents list' + ex);
}
return null;
}

Wrapper:
//
// Generated by JSON2Apex http://json2apex.herokuapp.com/
//

public class DataWrapper {

   @AuraEnabled
   public String accountName;
   @AuraEnabled
   public String registrationId;
   @AuraEnabled
   public String accountType;
   @AuraEnabled
   public String openDate;
   @AuraEnabled
   public List<String> allowedTransactions;
   @AuraEnabled
   public Address address;
   @AuraEnabled
   public List<Stocks> stocks;
   @AuraEnabled
   public Boolean accountClosedStatus;
   @AuraEnabled
   public Double totalCurrentValue;

   public class Address {
       @AuraEnabled
       public String addressLine1;
       @AuraEnabled
       public String addressLine2;
       @AuraEnabled
       public String addressLine3;
   }

   public class Stocks {
       @AuraEnabled
       public String stock;
       @AuraEnabled
       public String stockName;
       @AuraEnabled
       public String stockNumber;
       @AuraEnabled
       public String accountNumber;
       @AuraEnabled
       public String currentValue;
       @AuraEnabled
       public String totalShare;
       @AuraEnabled
       public String totalCost;
       @AuraEnabled
       public String minimumInvestment;
   }


   public static DataWrapper parse(String json) {
       return (DataWrapper) System.JSON.deserialize(json, DataWrapper.class);
   }
}

.12
August 30, 2021
Like
0

2 replies

My aura iteration is not working properly inside a <tbody>

Here is my json i was using to iterate and display values in table form

While i was trying to display only first array was keep on iterating second array values were not showing for me

For suppose if i'm trying to display ${!det.totalValue} from JSON

The Output i was getting like:-

6923.9346
6923.9346

But Expected Output should be like below:-

6923.9346
8923.9346

What i was missing code can any one explain me in details please.

Thanks in Advance

values= {"message": "Success","responseCode": 4000,"response": "Success","result": [{"accountType": "Savings","accounts": [{"accountName": "RAM REDDY","registrationId": 501049438,"details": [{"currentNumber": 12,"accountNumber": 12000012653,"bankName": "STATE BANK BANK, KA","gender": "M","releaseAmount": "77.00","accountName": "RAM REDDY","totalValue": "6923.9346","registrationId": 501049438,"nominee": {"nomineeName": "RAJI REDDY","shortName": "RAJI"},"recieptId": "001","recieptDate": "12/12/2021"}]}]},{"accountType": "Savings","accounts": [{"accountName": "RAM GANESH","registrationId": 501049438,"details": [{"currentNumber": 13,"accountNumber": 3338359458,"bankName": "STATE BANK BANK, KA","gender": "M","releaseAmount": "7237.00","accountName": "RAM GANESH","totalValue": "8923.9346","registrationId": 501023433,"nominee": {"nomineeName": "RASI REDDY","shortName": "RASI"},"recieptId": "23","recieptDate": "12/12/2021"}]}]}]}

<tbody>
<aura:iteration items="{!v.values}" var="result" indexVar="rowIndex">
<aura:iteration items="{!result.accounts}" var="acc" indexVar="rowIndex">
<aura:iteration items="{!acc.details}" var="det" indexVar="rowIndex">
<aura:if isTrue="{!item.accountNumber== '!det.accountNumber'}">
<td role="gridcell" tabindex="-1" data-label="Record Type Name">
<span class="slds-grid slds-grid_align-spread">
<div class="slds-truncate">
<span class="slds-truncate">Yes</span>
</div>
</span>
</td>
<td role="gridcell" tabindex="-1" data-label="Record Type Name">
<span class="slds-grid slds-grid_align-spread">
<div class="slds-truncate">
<span class="slds-truncate">${!det.totalValue}</span>
</div>
</span>
</td>
<aura:set attribute="else">
<td role="gridcell" tabindex="-1" data-label="Record Type Name">
<span class="slds-grid slds-grid_align-spread">
<div class="slds-truncate">
<span class="slds-truncate">No</span>
</div>
</span>
</td>
<td role="gridcell" tabindex="-1" data-label="Record Type Name">
<span class="slds-grid slds-grid_align-spread">
<div class="slds-truncate">
<span class="slds-truncate"></span>
</div>
</span>
</td>
</aura:set>
</aura:if>
</aura:iteration>
</aura:iteration>
</aura:iteration>
</tbody>

.12
August 26, 2021
Like
0

0 replies

comparing two strings in aura if inside aura iteration

In the first iteration i have some values of frist json and in second also i have some values in json which will match in first json so comparing those values i was trying to set the values in second iteration of third and fourth column of the table

Here are my two jsons i'm providing

options = {"accountName": "RAM REDDY","registrationId": "501049438","accountType": "Savings","openDate": "08/24/2021","allowedTransactions": ["Send","Recieve","Manage"],"address": {"addressLine1": "","addressLine2": "","addressLine3": ""},"stocks": [{"stock": "BTC","stockName": "Bitcoin","stockNumber": "051","accountNumber": "12000012653","currentValue": "161293.80","totalShare": "5367.514", "totalCost": "134931.56089999998","minimumInvestment": "200.000000000000"},{"stock": "LTC","stockName": "Litecoin","stockNumber": "052","accountNumber": "3338493","currentValue": "324.80","totalShare": "545.514", "totalCost": "2242.56089999998","minimumInvestment": "50.000000000000"}],"accountClosedStatus": false,"totalCurrentValue": 170790.31}

values= {"message": "Success","responseCode": 4000,"response": "Success","result": [{"accountType": "Savings","accounts": [{"accountName": "RAM REDDY","registrationId": 501049438,"details": [{"currentNumber": 12,"accountNumber": 12000012653,"bankName": "STATE BANK BANK, KA","gender": "M","releaseAmount": "77.00","accountName": "RAM REDDY","totalValue": "6923.9346","registrationId": 501049438,"nominee": {"nomineeName": "RAJI REDDY","shortName": "RAJI"},"recieptId": "001","recieptDate": "12/12/2021"}]}]},{"accountType": "Savings","accounts": [{"accountName": "RAM GANESH","registrationId": 501049438,"details": [{"currentNumber": 13,"accountNumber": 3338359458,"bankName": "STATE BANK BANK, KA","gender": "M","releaseAmount": "7237.00","accountName": "RAM GANESH","totalValue": "8923.9346","registrationId": 501023433,"nominee": {"nomineeName": "RASI REDDY","shortName": "RASI"},"recieptId": "23","recieptDate": "12/12/2021"}]}]}]}

<tbody>
<aura:iteration items="{!v.options.stocks}" var="item" indexVar="rowIndex">
<tr data-data="{!rowIndex}">
<td role="gridcell" tabindex="-1" data-label="Record Type Name">
<span class="slds-grid slds-grid_align-spread">
<div class="slds-truncate">
<span class="slds-truncate">{!item.accountNumber}</span>
</div>
</span>
</td>
<td role="gridcell" tabindex="-1" data-label="Record Type Name">
<span class="slds-grid slds-grid_align-spread">
<div class="slds-truncate">
<span class="slds-truncate">{!item.stockName}</span>
</div>
</span>
</td>
<aura:iteration items="{!v.values}" var="result" indexVar="rowIndex">
<aura:iteration items="{!result.accounts}" var="acc" indexVar="rowIndex">
<aura:iteration items="{!acc.details}" var="det" indexVar="rowIndex">
<aura:if isTrue="{!item.accountNumber== '!det.accountNumber'}">
<td role="gridcell" tabindex="-1" data-label="Record Type Name">
<span class="slds-grid slds-grid_align-spread">
<div class="slds-truncate">
<span class="slds-truncate">Yes</span>
</div>
</span>
</td>
<td role="gridcell" tabindex="-1" data-label="Record Type Name">
<span class="slds-grid slds-grid_align-spread">
<div class="slds-truncate">
<span class="slds-truncate">${!det.totalValue}</span>
</div>
</span>
</td>
<aura:set attribute="else">
<td role="gridcell" tabindex="-1" data-label="Record Type Name">
<span class="slds-grid slds-grid_align-spread">
<div class="slds-truncate">
<span class="slds-truncate">No</span>
</div>
</span>
</td>
<td role="gridcell" tabindex="-1" data-label="Record Type Name">
<span class="slds-grid slds-grid_align-spread">
<div class="slds-truncate">
<span class="slds-truncate"></span>
</div>
</span>
</td>
</aura:set>
</aura:if>
</aura:iteration>
</aura:iteration>
</aura:iteration>
</tr>
</aura:iteration>
</tbody>

.12
August 26, 2021
Like
0

7 replies

how to use aura if to match two values from aura iteration

What if i have two json files i have to use aura if and match two values and show YES if two values were matching if not matching have to show else NO how it is possible can any one explain if possible

Because i've tried the below code but it is not working and always displaying only else part

<aura:if isTrue="{!firstjson.firstName== '!secondjson.firstName'}" >
<td role="gridcell" tabindex="-1" data-label="Record Type Name">
<span class="slds-grid slds-grid_align-spread">
<div class="slds-truncate">
<span class="slds-truncate">Yes</span>
</div>
</span>
</td>
<aura:set attribute="else">
<td role="gridcell" tabindex="-1" data-label="Record Type Name">
<span class="slds-grid slds-grid_align-spread">
<div class="slds-truncate">
<span class="slds-truncate">No</span>
</div>
</span>
</td>
</aura:set>
</aura:if>

.12
August 25, 2021
Like
0

SOLVED

7 replies

I've a json and i'm using aura:iteration to display values in <tbody> but i don't want to show all the values in table

I want only one value from the json but i'm getting all the values how can i stop iteration or is there any way to show only one row like keeping size please help to find the solution

Thank you in Advance,

<tbody>
<aura:iteration items="{!v.jsonValues}" var="item" indexVar="rowIndex">
<tr data-data="{!rowIndex}">
<td role="gridcell" tabindex="-1" data-label="Record Type Name">
<span class="slds-grid slds-grid_align-spread">
<div class="slds-truncate">
<span class="slds-truncate">{!item.firstName}</span>
</div>
</span>
</td>
</tr>
</aura:iteration>
</tbody>

Original Output:-
Ramesh
Suresh
Rakesh

Expected Output:-
Ramesh

.12
August 25, 2021
Like
1

1 replies

How to restrict date and currency after dot

Here i just added a date adn currency input field in my datatable and there i want to restrict previous dates in date field
COming to curency field i would like to restrit the digits after dot in with only two numbers can you please helpt me out of this

Thanks and Regards
Saiteja Gowd K

.12
April 15, 2021
Like
0

SOLVED

3 replies

How to remove array string from particular values

.12
April 08, 2021
Like
0

SOLVED

7 replies

I've a json and i'm using aura:iteration to display values in <tbody> but i don't want to show all the values in table

.12
August 25, 2021
Like
1

2 replies

My aura iteration is not working properly inside a <tbody>

Here is my json i was using to iterate and display values in table form

While i was trying to display only first array was keep on iterating second array values were not showing for me

For suppose if i'm trying to display ${!det.totalValue} from JSON

The Output i was getting like:-

6923.9346
6923.9346

But Expected Output should be like below:-

6923.9346
8923.9346

What i was missing code can any one explain me in details please.

.12
August 26, 2021
Like
0

7 replies

how to use aura if to match two values from aura iteration

.12
August 25, 2021
Like
0

SOLVED

7 replies

I've a json and i'm using aura:iteration to display values in <tbody> but i don't want to show all the values in table

.12
August 25, 2021
Like
1

2 replies

Dynamic Aura:Id inside Aura:Iteration

I have one component in this i'm creating dynaminc row and column in table . we can get the value from Component to JS controller using Aura:id but i'm not understanding how we can get the values of row which i have created dynamically?? how we can set the aura:id for that dynamic row and how to get that value in js controller

Ashish Kumar 743
July 17, 2021
Like
0

18 replies

How can I stop a Lightning DataTable from showing the WrapText/ClipText drop down

Is there a way to stop the drop down that give and option to wrap or clip text in a lightning data table?

User-added image

Andrew Aldis 15
June 11, 2018
Like
2

SOLVED

7 replies

How to display error message if the datatable is empty(datatable having no results) in component?

Sam1980
July 28, 2014
Like
0

SOLVED

3 replies

Hide and show the section of fields if the checkbox is true

Hi,

Here im trying to create vf page to create multiple object records in a single VF page.Im able to display the records in the page .In VF page i have created section for account,account qualification ,contact,opportunity and task.It is working fine

Im trying to implement one more functionality says there is a checkbox in all sections.if i checkbox is true then it should display next section

eg: In account if the checkbox is true then only account qualification section will display.I know it is possible through apex:actionsupport .Suggest me how can i use it here

Below mentioned is VF page and Controller

<apex:page controller="multirecords" tabStyle="Account">
<apex:form>
<apex:pageBlock >
<apex:pageBlockButtons >
<apex:commandButton value="Save" action="{!save}"/>
</apex:pageBlockButtons>
<apex:pageBlockSection title="Enter Account Information">

<apex:inputField value="{!A.Name}"/>
<apex:inputField value="{!A.Phone}"/>

</apex:pageBlockSection>
<apex:pageBlockSection title="Enter Account Qualification">
<!--<apex:inputField value="{!AQ.name}" required="false"/>-->
<apex:inputField value="{!AQ.Product__c}" required="false"/>
<apex:inputField value="{!AQ.Status__c}" required="false"/>
<apex:inputField value="{!AQ.Sub_Status__c}" required="false"/>
</apex:pageBlockSection>
<apex:pageBlockSection title="Enter Contact Information">
<apex:inputField value="{!c.lastname}" required="false"/>
<apex:inputField value="{!c.firstname}" required="false"/>
<apex:inputField value="{!c.email}" required="false"/>
</apex:pageBlockSection>
<apex:pageBlockSection title="Enter Opportunity Information">
<apex:inputField value="{!O.name}" required="false"/>
<apex:inputField value="{!O.closedate}" required="false"/>
<apex:inputField value="{!O.stagename}" required="false"/>
</apex:pageBlockSection>
<apex:pageBlockSection title="Enter Activities">
<apex:inputField value="{!t.Type}" required="false"/>
<apex:inputField value="{!t.Subject}" required="false"/>
<apex:inputField value="{!t.Status}" required="false"/>
<!--<apex:inputField value="{!t.WhoId}" required="false"/>
<apex:inputField value="{!t.WhatId}" required="false"/>-->
<apex:inputField value="{!t.Description}" required="false"/>
</apex:pageBlockSection>
</apex:pageBlock>
</apex:form>
</apex:page>

public class multirecords {

public Account A {get; set;}
Public Contact C {get; set;}
Public Opportunity O {get; set;}
Public Account_Qualification__c AQ{get;set;}
public Task t{get;set;}
public multirecords()
{
A = new account();
C = new contact();
O = new opportunity();
AQ = new Account_Qualification__c();
t = new Task();
}

public PageReference Save()
{
insert A;

C.Accountid = A.id;


AQ.Account__c=A.Id;
insert AQ;
O.Accountid = A.id;

If (O.name != NULL || C.lastname != NULL)
{
insert O;
insert C;
}
t.WhoId=C.id;
t.WhatId=O.id;
insert t;
return new PageReference('/'+A.id);
}

public static testmethod void multirecords()
{
multirecords M = new multirecords();

Account A = new account(name = 'Test');
insert A;

Contact C = new contact(lastname = 'test', AccountId = A.id);
insert C;

}
}

Any help would be greatly appreciated

Thanks

amrit
February 16, 2013
Like
0

5 replies

Disable set of inputfields using a single checkbox

Hi,

I have the ff code which disable one inputfield when a checkbox is selected. My question is how do i make all the inputfields disabled using the same checkbox. When i tick the checkbox all the inputfield should also be disabled.

<apex:pageBlockSection title="Billing Address" collapsible="false" columns="1">
    <apex:inputCheckbox value="{!Lead.Cpy_from_Installation_Address__c}" onchange="document.getElementById('{!$Component.disablefield}').disabled=this.checked"/>
    <apex:inputField id="disablefield" value="{!Lead.Billing_House__c}"/>
    <apex:inputField id="disablefield2" value="{!Lead.Billing_Apartment__c}"/>
    <apex:inputField id="disablefield3" value="{!Lead.Billing_Street__c}"/>
    <apex:inputField id="disablefield4" value="{!Lead.Billing_Subdivision__c}"/>
    <apex:inputField id="disablefield5" value="{!Lead.Billing_City__c}"/>
    <apex:inputField id="disablefield6" value="{!Lead.Billing_Zip_Code__c}"/>
</apex:pageBlockSection>

Thanks,

Del

Del_Santos
June 13, 2012
Like
0

SOLVED

9 replies

Disabling a field in input page based on a picklist value?

Hi Guys,

I need help for a functionality in VF page to hide one of two fields based on picklist value in the same page.

Here we have : 1)Opportunity type (PICKLIST) with options NEW, EXISTING.

2)Opportunity LookUp

3) Opportunity Name Text Field

Here, i need to disable the Opportunity Lookup if the picklist value is NEW. Sameway, i need to disable Opportunity Name text field, if the piklist value in EXISTING.

Please let me know whether i can do this or not, suggest me the code to disable appropriate fields in my custom object's new record page.

Tons of Thanks,

Nishanth.

nishanth0208
June 07, 2010
Like
0