-
ChatterFeed
-
0Best Answers
-
0Likes Received
-
0Likes Given
-
19Questions
-
33Replies
List of queues assigned to the user
Can anyone tell me, Can we display the list of queues and public groups assigned to the particular user in report or dashboard?
Thanks in Advance.
Sarma
- Sarma Duvvuri
- February 23, 2019
- Like
- 0
- Continue reading or reply
validation rule for routing queues
i want to assign the case to particualt queue based on code.
Code is DEL, I can assign that case to the queue name which contains DEL as a admin
Please help for validation rule..
Thnaks,
Sarma
- Sarma Duvvuri
- February 06, 2019
- Like
- 0
- Continue reading or reply
Insert Case Owner Name in text field using apex
I have one text field. I wnat to insert that field with owner name using Apex or Trigger. Can any one suggest me.
Thanks,
Sarma
- Sarma Duvvuri
- February 04, 2019
- Like
- 0
- Continue reading or reply
Case Event Value in Case Object
I have One Parent Object- Case and Child Object- Case Events. For every status change in case (like new, Pend, Reject) event is created in case events. if status changed 3 times 3 evenmts created in case events object.
Now we have one filed (Time) in case event i want to get that field value in case.
Please Help me how to proceed.
Thanks,
Sarma
- Sarma Duvvuri
- January 04, 2019
- Like
- 0
- Continue reading or reply
User should not access reports in public folder
User should not edit the reports in public folder and save. I have diabled the below permissions.
Manage Reports in Public Folders & View Reports in Public Folders
Still user able to edit and save as report in public folder. User has to create his own reports in private folder but he should not edit and save as reports in public folder.
Please help.
Thanks Inadvance.
Sarma
- Sarma Duvvuri
- December 31, 2019
- Like
- 0
- Continue reading or reply
Summarize the Formula field in Reports
Can any one tell me how to Summarize the Formula field (Custom Field) in Reports.
Thanks & Regards,
Sarma
- Sarma Duvvuri
- December 05, 2018
- Like
- 0
- Continue reading or reply
Trigger after case updated
When case status is updated, Total duration hours should be displayed in sub total column of report. Can any one please help me how to write trigger for this scenario. Its very urgent
Thanks In Advance.
Sarma
- Sarma Duvvuri
- December 04, 2018
- Like
- 0
- Continue reading or reply
cron expression
I want to run the batch from monday to friday in between 9 AM to 5 PM for every one hour. Please tell me how to proceed.
Thanks,
Sarma
- Sarma Duvvuri
- November 30, 2018
- Like
- 0
- Continue reading or reply
batch class to fetch the records based on time
Please provide any sample code of Batch class to fetch the records based on time and date.
Thanks,
Sarma
- Sarma Duvvuri
- November 23, 2018
- Like
- 0
- Continue reading or reply
PostChatter Test Class
Kindly provide the sample test class for Creating Installation Case records based on Application Status
Thanks & Regards,
Sarma
- Sarma Duvvuri
- October 08, 2018
- Like
- 0
- Continue reading or reply
List of Records and want to save to account object
I have imported the list of accounts in CSV formate in visualforce page. i have 2 tasks.
1. I want to upload only 5 account records if it is more than 5 it should show the error message
2. What are the records i got in visual force page should save in account object once i click on save button in visual force page. please suggest.
code is below..
VisualforcePage:
<apex:page controller="importDataFromCSVController">
<apex:form >
<apex:pagemessages />
<apex:pageBlock >
<apex:pageBlockSection >
<apex:inputFile value="{!csvFileBody}" filename="{!csvAsString}"/>
<apex:commandButton value="Upload" action="{!importCSVFile}"/>
</apex:pageBlockSection>
</apex:pageBlock>
<apex:pageBlock >
<apex:pageblocktable value="{!accList}" var="acc">
<apex:column value="{!acc.name}" />
<apex:column value="{!acc.AccountNumber}" />
<apex:column value="{!acc.Type}" />
<apex:column value="{!acc.Accountsource}" />
<apex:column value="{!acc.Industry }" />
</apex:pageblocktable>
</apex:pageBlock>
</apex:form>
</apex:page>
Apex class:
public class importDataFromCSVController {
public Blob csvFileBody{get;set;}
public string csvAsString{get;set;}
public String[] csvFileLines{get;set;}
public List<account> acclist{get;set;}
public importDataFromCSVController(){
csvFileLines = new String[]{};
acclist = New List<Account>();
}
public void importCSVFile(){
try{
csvAsString = csvFileBody.toString();
csvFileLines = csvAsString.split('\n');
for(Integer i=1;i<csvFileLines.size();i++){
Account accObj = new Account() ;
string[] csvRecordData = csvFileLines[i].split(',');
accObj.name = csvRecordData[0] ;
accObj.accountnumber = csvRecordData[1];
accObj.Type = csvRecordData[2];
accObj.AccountSource = csvRecordData[3];
accObj.Industry = csvRecordData[4];
acclist.add(accObj);
}
//insert acclist;
}
catch (Exception e)
{
ApexPages.Message errorMessage = new ApexPages.Message(ApexPages.severity.ERROR,'Please upload the csv format file');
ApexPages.addMessage(errorMessage);
}
}
}
- Sarma Duvvuri
- July 14, 2018
- Like
- 0
- Continue reading or reply
Lead Conversion from Web to lead form to Account
Can anyone ell me how to convert the lead from Web to Lead form to Direct account and contact please.
Its Urgent.
Sarma
- Sarma Duvvuri
- February 21, 2018
- Like
- 0
- Continue reading or reply
Error while running the batch class
I am not able to run the batch for the below quesry.
i am getting below error messages after modifications also. kindly help.
1. First error: Only variable references are allowed in dynamic SOQL/SOSL.
2. First error: unexpected token: '='
3. IF i mention IN instead of = i got error message like First error: unexpected token: 'IN'
4. First error: expecting a colon, found 'NULLStatus__c'
5.First error: Too many query rows: 50001 (Main Error)
I want to get all the ACTIVE status customers from orders.
Code:
global with sharing class Batch_ProductVolumeTarget_Stats implements Database.Batchable<sObject>
{
public class X_Exception extends Exception{}
global Database.QueryLocator start(Database.BatchableContext BC)
{
string strQuery =
' select Id' +
' from Order__c ' +
' where Customer__C= NULL';
return Database.getQueryLocator(strQuery);
}
Regards,
Sarma
- Sarma Duvvuri
- January 27, 2018
- Like
- 0
- Continue reading or reply
Apex Class for Lead Conversion to the existing Account
I am not able to update the contact details for existing account in Lead Conversion. Kindly help in this issue.
This is the code i am using.
Public class AutoConvertLeads
{
@InvocableMethod
public static void LeadAssign(List<Id> LeadIds)
{
LeadStatus CLeadStatus= [SELECT Id, MasterLabel FROM LeadStatus WHERE IsConverted=true Limit 1];
List<Database.LeadConvert> MassLeadconvert = new List<Database.LeadConvert>();
for(id currentlead: LeadIds){
Database.LeadConvert Leadconvert = new Database.LeadConvert();
Leadconvert.setLeadId(currentlead);
Leadconvert.setConvertedStatus(CLeadStatus.MasterLabel);
Leadconvert.setDoNotCreateOpportunity(TRUE); //Remove this line if you want to create an opportunity from Lead Conversion
MassLeadconvert.add(Leadconvert);
}
if (!MassLeadconvert.isEmpty()) {
List<Database.LeadConvertResult> lcr = Database.convertLead(MassLeadconvert);
}
}
}
- Sarma Duvvuri
- January 25, 2018
- Like
- 0
- Continue reading or reply
Conversion of Lead Without Opportunity
How to do lead conversion without creating an opportunity. (Only account and contact has to be created)
If the account is already exists contact detailes has to updated to that exisiting account and if the details are already there in salesforce and different from the requirement, we need to update those details in account and contacts.
Lead Conversion Code:
Trigger web2LeadConvert on Lead (after Update) {
LeadStatus convertStatus = [
select MasterLabel
from LeadStatus
where IsConverted = true
limit 1
];
List<Database.LeadConvert> leadConverts = new List<Database.LeadConvert>();
for (Lead lead: Trigger.new) {
if (!lead.isConverted && lead.Status == 'Qualified') {
Database.LeadConvert lc = new Database.LeadConvert();
lc.setLeadId(lead.Id);
lc.setConvertedStatus(convertStatus.MasterLabel);
leadConverts.add(lc);
}
}
if (!leadConverts.isEmpty()) {
List<Database.LeadConvertResult> lcr = Database.convertLead(leadConverts);
}
Please help to slove above problems.
Regards,
Sarma
- Sarma Duvvuri
- January 22, 2018
- Like
- 0
- Continue reading or reply
Pseudo code
Kindly provide the Pseudo code for Trigger to conversion from Lead to Account.
Thanks inadvance.
Regards,
Sarma
- Sarma Duvvuri
- January 09, 2018
- Like
- 0
- Continue reading or reply
onclick button in lightning
Hi All,
Please resolve the below issue. I am unable to search the values.
Component:
<aura:component controller="SearchApexClass" implements="force:appHostable,flexipage:availableForAllPageTypes,flexipage:availableForRecordHome,force:hasRecordId,forceCommunity:availableForAllPageTypes,force:lightningQuickAction" access="global" >
<aura:attribute name="SkillsRequired" type="String"/>
<aura:attribute name="Salary" type="Decimal"/>
<aura:attribute name="RelatedExperience" type="Integer"/>
<aura:attribute name="Search" type="String" default=""/>
<form class="slds-form--Stacked form">
<div class="slds Search">
<div class="Seprator"> </div>
<div class="slds-grid seprate">
<div class="slds-form-element">
<h1> <b>Search Options</b> </h1>
</div>
</div>
</div>
<div> <br/>
<p> Skills Required </p>
<p><ui:outputText class="result" aura:id="singleResult" value="" /></p>
<ui:inputSelect class="single" aura:id="SkillsRequired" change="{!c.SkillChange}">
<ui:inputSelectOption text=" "/>
<ui:inputSelectOption text="Salesforce Admin"/>
<ui:inputSelectOption text="Salesforce Developer"/>
<ui:inputSelectOption text="SFDC-Integration"/>
<ui:inputSelectOption text="SFDC-Lightning"/>
</ui:inputSelect>
<br/><br/>
<p> Salary (in LPA) </p>
<p><ui:outputText class="result" aura:id="singleResult" value="" /></p>
<ui:inputSelect class="single" aura:id="Salary" change="{!c.CurrencyChange}">
<ui:inputSelectOption text=" "/>
<ui:inputSelectOption text="4"/>
<ui:inputSelectOption text="5"/>
<ui:inputSelectOption text="6-7"/>
<ui:inputSelectOption text="8-10"/>
</ui:inputSelect>
<br/><br/>
<p> Related Experience(In Years)</p>
<p><ui:outputText class="result" aura:id="singleResult" value="" /></p>
<ui:inputSelect class="single" aura:id="RelatedExp" change="{!c.ExpChange}">
<ui:inputSelectOption text=" "/>
<ui:inputSelectOption text="1-2"/>
<ui:inputSelectOption text="3-4"/>
<ui:inputSelectOption text="5-6"/>
</ui:inputSelect>
</div> <br/>
<div class="slds-grid buttons">
<lightning:button variant="brand" label="Search" onclick="{!c.SearchButtomClick}" />
</div>
</form>
</aura:component>
Controller:
({
doInit: function(component, event, helper) {
helper.fetchPickListVal(component, 'Industry', 'accIndustry');
},
SkillChange: function(component, event, helper) {
// get the value of select option
alert(event.getSource().get("v.value"));
},
CurrencyChange: function(component, event, helper) {
// get the value of select option
alert(event.getSource().get("v.value"));
},
ExpChange: function(component, event, helper) {
// get the value of select option
alert(event.getSource().get("v.value"));
},
SearchButtomClick: function(component, event, helper) {
//var Search = component.get("v.search");
var action = component.get("c.Search");
action.setParams({"SkillsRequired": component.find("SkillsRequired").get("v.value"),
"Salary" : component.find("Salary").get("v.value"),
"RelatedExp" : component.find("RelatedExp").get("v.value")});
action.setCallback(this, function(response) {
var state = response.getState();
if (state === 'SUCCESS') {
var ids = response.getReturnValue();
console.log('>>>>>' +ids);
}
});
$A.enqueueAction(action);
}
})
Helper :
({
doInit: function(component, fieldName, elementId) {
var action = component.get("c.getselectOptions");
action.setParams({
"objObject": component.get("v.objInfo"),
"fld": fieldName
});
var opts = [];
action.setCallback(this, function(response) {
if (response.getState() == "SUCCESS") {
var allValues = response.getReturnValue();
if (allValues != undefined && allValues.length > 0) {
opts.push({
class: "optionClass",
label: "",
value: ""
});
}
for (var i = 0; i < allValues.length; i++) {
opts.push({
class: "optionClass",
label: allValues[i],
value: allValues[i]
});
}
component.find(elementId).set("v.options", opts);
}
});
$A.enqueueAction(action);
},
})
Class:
public class SearchApexClass {
@AuraEnabled
public static List <String> getselectOptions(sObject objObject, string fld) {
system.debug('objObject --->' + objObject);
system.debug('fld --->' + fld);
List <String> allOpts = new list < String > ();
Schema.sObjectType objType = objObject.getSObjectType();
Schema.DescribeSObjectResult objDescribe = objType.getDescribe();
map < String, Schema.SObjectField > fieldMap = objDescribe.fields.getMap();
list < Schema.PicklistEntry > values = fieldMap.get(fld).getDescribe().getPickListValues();
for (Schema.PicklistEntry a: values) {
allOpts.add(a.getValue());
}
system.debug('allOpts ---->' + allOpts);
allOpts.sort();
return allOpts;
}
public static string Search(String SkillsRequired, Integer Salary, String RelatedExp) {
string returnvariable;
list<Naukri__c> naukriList = new list<Naukri__c>();
naukriList = [SELECT Id,Skills_Required__c,Salary__c,Related_Experience__c FROM Naukri__c limit 10];
if(naukriList != null && !naukriList.isEmpty()){
if(SkillsRequired==naukriList[0].Skills_Required__c && Salary==naukriList[0].Salary__c && RelatedExp==naukriList[0].Related_Experience__c){
system.debug('Hiii');
returnvariable = 'Welcome';
}
else{
returnvariable = 'Please enter valid credentials';
}
}
system.debug('Hiii'+ returnvariable);
return returnvariable;
}
}
I am getting the error message like "This page has an error. You might just need to refresh it. Unable to find 'Search' on 'compound://c.Search'. Failing descriptor: {markup://c:Search}" while clicking on Search button.
Please look into it.
Thnaks,
Sarma
- Sarma Duvvuri
- November 28, 2017
- Like
- 0
- Continue reading or reply
Login page in lightning
I have created the fields, but i am not able to do in controller for login button.
<div class="slds Naukri">
<ui:inputtext aura:id="User" label=" User Name " class="" value="" maxlength="30" placeholder="Enter Email Id" required="false" size="20"/> <br/>
<ui:inputSecret aura:id="pwd" label=" Password " class="" value="" maxlength="10" placeholder="Enter upto 10 character" required="false" size="20"/> <br/>
<div class="slds-float--right slds-button_brand">
<div class="slds-grid buttons">
<lightning:button variant="brand" label="Login" onclick="{!c.handleLoginButtomClick}" />
</div>
</div>
</div>
Can you please help me in this.
Regards,
Sarma
- Sarma Duvvuri
- November 11, 2017
- Like
- 0
- Continue reading or reply
Space between two fields
How to add space between two fields in lightning-SLDS.
Thanks,
Sarma
- Sarma Duvvuri
- October 24, 2017
- Like
- 0
- Continue reading or reply
List of queues assigned to the user
Can anyone tell me, Can we display the list of queues and public groups assigned to the particular user in report or dashboard?
Thanks in Advance.
Sarma
- Sarma Duvvuri
- February 23, 2019
- Like
- 0
- Continue reading or reply
validation rule for routing queues
i want to assign the case to particualt queue based on code.
Code is DEL, I can assign that case to the queue name which contains DEL as a admin
Please help for validation rule..
Thnaks,
Sarma
- Sarma Duvvuri
- February 06, 2019
- Like
- 0
- Continue reading or reply
Case Event Value in Case Object
I have One Parent Object- Case and Child Object- Case Events. For every status change in case (like new, Pend, Reject) event is created in case events. if status changed 3 times 3 evenmts created in case events object.
Now we have one filed (Time) in case event i want to get that field value in case.
Please Help me how to proceed.
Thanks,
Sarma
- Sarma Duvvuri
- January 04, 2019
- Like
- 0
- Continue reading or reply
Trigger after case updated
When case status is updated, Total duration hours should be displayed in sub total column of report. Can any one please help me how to write trigger for this scenario. Its very urgent
Thanks In Advance.
Sarma
- Sarma Duvvuri
- December 04, 2018
- Like
- 0
- Continue reading or reply
batch class to fetch the records based on time
Please provide any sample code of Batch class to fetch the records based on time and date.
Thanks,
Sarma
- Sarma Duvvuri
- November 23, 2018
- Like
- 0
- Continue reading or reply
PostChatter Test Class
Kindly provide the sample test class for Creating Installation Case records based on Application Status
Thanks & Regards,
Sarma
- Sarma Duvvuri
- October 08, 2018
- Like
- 0
- Continue reading or reply
List of Records and want to save to account object
I have imported the list of accounts in CSV formate in visualforce page. i have 2 tasks.
1. I want to upload only 5 account records if it is more than 5 it should show the error message
2. What are the records i got in visual force page should save in account object once i click on save button in visual force page. please suggest.
code is below..
VisualforcePage:
<apex:page controller="importDataFromCSVController">
<apex:form >
<apex:pagemessages />
<apex:pageBlock >
<apex:pageBlockSection >
<apex:inputFile value="{!csvFileBody}" filename="{!csvAsString}"/>
<apex:commandButton value="Upload" action="{!importCSVFile}"/>
</apex:pageBlockSection>
</apex:pageBlock>
<apex:pageBlock >
<apex:pageblocktable value="{!accList}" var="acc">
<apex:column value="{!acc.name}" />
<apex:column value="{!acc.AccountNumber}" />
<apex:column value="{!acc.Type}" />
<apex:column value="{!acc.Accountsource}" />
<apex:column value="{!acc.Industry }" />
</apex:pageblocktable>
</apex:pageBlock>
</apex:form>
</apex:page>
Apex class:
public class importDataFromCSVController {
public Blob csvFileBody{get;set;}
public string csvAsString{get;set;}
public String[] csvFileLines{get;set;}
public List<account> acclist{get;set;}
public importDataFromCSVController(){
csvFileLines = new String[]{};
acclist = New List<Account>();
}
public void importCSVFile(){
try{
csvAsString = csvFileBody.toString();
csvFileLines = csvAsString.split('\n');
for(Integer i=1;i<csvFileLines.size();i++){
Account accObj = new Account() ;
string[] csvRecordData = csvFileLines[i].split(',');
accObj.name = csvRecordData[0] ;
accObj.accountnumber = csvRecordData[1];
accObj.Type = csvRecordData[2];
accObj.AccountSource = csvRecordData[3];
accObj.Industry = csvRecordData[4];
acclist.add(accObj);
}
//insert acclist;
}
catch (Exception e)
{
ApexPages.Message errorMessage = new ApexPages.Message(ApexPages.severity.ERROR,'Please upload the csv format file');
ApexPages.addMessage(errorMessage);
}
}
}
- Sarma Duvvuri
- July 14, 2018
- Like
- 0
- Continue reading or reply
Lead Conversion from Web to lead form to Account
Can anyone ell me how to convert the lead from Web to Lead form to Direct account and contact please.
Its Urgent.
Sarma
- Sarma Duvvuri
- February 21, 2018
- Like
- 0
- Continue reading or reply
Error while running the batch class
I am not able to run the batch for the below quesry.
i am getting below error messages after modifications also. kindly help.
1. First error: Only variable references are allowed in dynamic SOQL/SOSL.
2. First error: unexpected token: '='
3. IF i mention IN instead of = i got error message like First error: unexpected token: 'IN'
4. First error: expecting a colon, found 'NULLStatus__c'
5.First error: Too many query rows: 50001 (Main Error)
I want to get all the ACTIVE status customers from orders.
Code:
global with sharing class Batch_ProductVolumeTarget_Stats implements Database.Batchable<sObject>
{
public class X_Exception extends Exception{}
global Database.QueryLocator start(Database.BatchableContext BC)
{
string strQuery =
' select Id' +
' from Order__c ' +
' where Customer__C= NULL';
return Database.getQueryLocator(strQuery);
}
Regards,
Sarma
- Sarma Duvvuri
- January 27, 2018
- Like
- 0
- Continue reading or reply
Conversion of Lead Without Opportunity
How to do lead conversion without creating an opportunity. (Only account and contact has to be created)
If the account is already exists contact detailes has to updated to that exisiting account and if the details are already there in salesforce and different from the requirement, we need to update those details in account and contacts.
Lead Conversion Code:
Trigger web2LeadConvert on Lead (after Update) {
LeadStatus convertStatus = [
select MasterLabel
from LeadStatus
where IsConverted = true
limit 1
];
List<Database.LeadConvert> leadConverts = new List<Database.LeadConvert>();
for (Lead lead: Trigger.new) {
if (!lead.isConverted && lead.Status == 'Qualified') {
Database.LeadConvert lc = new Database.LeadConvert();
lc.setLeadId(lead.Id);
lc.setConvertedStatus(convertStatus.MasterLabel);
leadConverts.add(lc);
}
}
if (!leadConverts.isEmpty()) {
List<Database.LeadConvertResult> lcr = Database.convertLead(leadConverts);
}
Please help to slove above problems.
Regards,
Sarma
- Sarma Duvvuri
- January 22, 2018
- Like
- 0
- Continue reading or reply