Forum Replies Created

Page 2 of 2
  • Hi Ajay,

    This isn't going to be possible the way you defined it

    Lead History report primary object is Lead History
    Lead Activity History report primary object is Task (Activity)
    Hence, no common object to join

    Because there is no common object, but a conceptual common Lead.Id, you might be better off writing a simple APEX VF controller and VF page to do the joins in memory into a single wrapper class. You'll need to think about what your layout is going to look like as for a given lead, there are n field histories and m activities

    Thanks

  • Suyash

    Member
    April 30, 2016 at 10:26 am in reply to: Getting error of 'BLOB is not a valid UTF-8 string'.

    Hi Nitish,

    This error was too faced by me when I was writing the email service class.
    First ensure that your file is  encoded in UTF-8 encoding.
    Second if you are splitting your file which was my case check it split in right way as some times extra ",(comma)" creates this type of error.

    Thanks

  • Suyash

    Member
    April 30, 2016 at 10:16 am in reply to: “UNABLE_TO_LOCK_ROW” error?

    Hi Ravi,

    When you run async their is a chance that single record get dml operationed simultaneously.For this you can put For Update in your query.
    It will solve your error.
    Thanks

     

  • Suyash

    Member
    April 30, 2016 at 8:00 am in reply to: Send button on DocuSign is not Working

    Hi Nitish,

    One of the reason may be that your DSProSFUsername should match to your Docusign API User name
    You can view and  edit the DSProSFUsername in Salesforce:

    Setup >> Manage Users>> Users >> Selecting the Username >> Edit >> Populate either the DocuSign API Username.If you cannot view, you may have to add "DSProSFUsername" to the Layout.

    You can locate the the API Username in Docusign:

    Account Preferences >> Member Options >> Permissions >> Under DocuSign API >> API UserName

    Another reason for it may be:
    Org wide default security settings for the Docusign Account configuration object in SF, were set to Private which was prevents non admin users from accessing these configurations. Setting this to Public Read/Write may solve your issue.

     

    Thanks.

  • Suyash

    Member
    April 30, 2016 at 7:49 am in reply to: Can we use Map in dynamic query?

    Hi Piyush,

    You cannot directly use mapname.keyset() or mapname.values() in dynamic queries as dynamic query doesnt allow to map methods to be used in it.
    For this you need to fill all the keys or values in a set or list and then IN check to query filterd  data
    For ex.
    set<string> mapkeys=new set<string>()

    mapkeys.addAll(mapname.keyset());

    string query='Select id from lead where fieldName IN:mapkeys'

  • Suyash

    Member
    April 30, 2016 at 7:41 am in reply to: Record is read-only error

    Hi Gaurav,

    I think you are updating your triggered records directly in after trigger.
    for ex:
    for(Sobjecttype obj: trigger.new){

    obj.fieldApiName__c='Updated value';

    update obj;

    }

    You cannot do this in After trigger as Trigger.new is read only. To update it you need to query the records from the sObject which are having their ids in trigger.new.

    Hope it helps
    Thanks.

  • Suyash

    Member
    April 30, 2016 at 6:54 am in reply to: Converting Visualforce to Salesforce1

    Hi Audrey,

    It depends on your customer requirement.

    Lets say you want just mobile look and feel then the approach would be to just style your existing page with CSS friendlier to mobile.You may use plugins like jquery mobile ,polymer,bootsrap .

    If you want a responsive UI with better perfomance then would redesign controller to use VF remoting or javascript remoting.This will remove viewstate and make your transaction light .You may consider using frameworks like angular , backbone or knockout to manipulate DOM.

    Thanks

    • This reply was modified 8 years, 7 months ago by  Suyash.
  • Suyash

    Member
    April 27, 2016 at 11:08 am in reply to: How do I change the date format?

    Hi Utsav,

    i think you can do this by using CSS for your output text.

    outputtext {

    text-transform: uppercase
    }

    Hope this helps

    Thanks.

  • Suyash

    Member
    April 27, 2016 at 10:13 am in reply to: Wave Analytic Official User Group

    Hi Danna,

    Below is the  link for Official: Wave - Analytics Cloud Group in Success Community:

    https://success.salesforce.com/loginswitcher?startURL=%2F_ui%2Fcore%2Fchatter%2Fgroups%2FGroupProfilePage%3Fg%3D0F9300000009MBP.
    Hope it helps.
    Thanks.

  • Suyash

    Member
    April 27, 2016 at 10:11 am in reply to: Where should we use Analytic Cloud?

    Hi Piyush,

    Analytics cloud have certain advantages over R&D.
    -: Its can work on large amount of data which is the limitation for Reports and Dashboards.
    -: Speed and processing power becomes even more apparent when you realise that Analytics Cloud can process data from external systems as well.
    If you need to work on large amount of data with speedy processing then you may like to go with Analytics cloud.

    Thanks.

  • Hi Utsav,

    Go through this link it contains a particular section about your query about R&D and Wave analytics:

    http://www.salesforceben.com/introduction-to-salesforce-wave-the-analytics-cloud/

    Thanks.

  • Hi karen,

    Use this simple query to get Owner name from case records:

    select id,owner.name from case.

    Thanks.

  • Suyash

    Member
    April 22, 2016 at 7:11 am in reply to: How to align pageBlockButtons left or right in a pageBlock?

    Hi Ravi,

    Can you just provide your code for override css because I am able to do it simply in my case. As in my case override it as:

    .listRelatedObject .bPageBlock .pbHeader .btn, .listRelatedObject .bPageBlock .pbBottomButtons .btn, .apexp .bPageBlock .pbHeader .btn, .apexp .bPageBlock .pbBottomButtons .btn, div.buttons .btn, div.pbBottomButtons>.btn {
    margin-left: 197px;
    margin-right: 3px;

    Thanks.

    • This reply was modified 8 years, 8 months ago by  Suyash.
  • Suyash

    Member
    April 22, 2016 at 6:44 am in reply to: Is there a way to Query Salesforce Role Hierarchy?

    Hi Nitish,

    Try the below code.U just need to pass the user id to this class and it chugs through all of the level beneath that User in the role hierarchy and returns the IDs of all of the users in those roles:

    public with sharing class RoleUtils {
        public static Set<ID> getRoleSubordinateUsers(Id userId) {
            // get requested user’s role
            Id roleId = [select UserRoleId from User where Id = :userId].UserRoleId;
            // get all of the roles underneath the user
            Set<Id> allSubRoleIds = getAllSubRoleIds(new Set<ID>{roleId});
            // get all of the ids for the users in those roles
            Map<Id,User> users = new Map<Id, User>([Select Id, Name From User where
            UserRoleId IN :allSubRoleIds]);
            // return the ids as a set so you can do what you want with them
            return users.keySet();
        }
    
        private static Set<ID> getAllSubRoleIds(Set<ID> roleIds) {
            Set<ID> currentRoleIds = new Set<ID>();
            // get all of the roles underneath the passed roles
            for(UserRole userRole :[select Id from UserRole where ParentRoleId IN :roleIds AND ParentRoleID != null])
    currentRoleIds.add(userRole.Id);
            // go fetch some more rolls!
            if(currentRoleIds.size() > 0)
                currentRoleIds.addAll(getAllSubRoleIds(currentRoleIds));
            return currentRoleIds;
        }
    }

    Code Source: http://blog.jeffdouglas.com/2011/02/15/find-my-salesforce-users-by-role-hierarchy

    Thanks.

  • Suyash

    Member
    April 22, 2016 at 6:38 am in reply to: Clean the Account on a contact record.

    Hi Danna,

    Go through this link,you will find some Demo's for your query:

    http://www.salesforce.com/data/why/?d=70130000000m05tAAA&internal=true#clean

    Thanks.

  • Suyash

    Member
    April 22, 2016 at 6:28 am in reply to: How to align pageBlockButtons left or right in a pageBlock?

    Hello Ravi,

    Apex pageblock buttons and commadbuttons gets its default css styles applied when its rendered. you can use chrome dev tools or firebug to findout the css classes and override them in your vf page.

    Thanks.

  • Hi Audrey,
    For this we use sharing via apex. In this you need to query account team member of each account with all the related object records on it one by one. And then create a share (Share is object in salesforce) for each child record by giving the team member id in its Userorgroupid field. Sample code can be found in below link.

    Refer to this link:
    https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_bulk_sharing_creating_with_apex.html

     

  • Suyash

    Member
    April 19, 2016 at 6:11 am in reply to: Process Builder problem while referencing parent field

    Hello Ajit,

    I think you can use Global Constant NULL here or just put "isNull" check in your process builder and it will allow the record to be saved.

    Image link for Global constant:

    http://i.stack.imgur.com/BxmgM.jpg

    Image link for "isNull" check:

    http://i.stack.imgur.com/rMVY6.jpg

     

    Image source article:

    http://salesforce.stackexchange.com/questions/104812/what-criteria-to-use-in-process-builder-to-check-for-null-reference

     

    Hit like if this answer solved your query.

    Thanks

     

    View post on imgur.com

  • Suyash

    Member
    April 19, 2016 at 5:51 am in reply to: How to create popup from Visualforce page?

    Hello,

    Have a look into the following code:

    <apex:page controller="popup">
    <apex:form >
    <apex:commandButton value="Show Pop up" action="{!showPopup}" rerender="popup"/>
    <apex:outputPanel id="popup">
    <apex:outputPanel styleClass="customPopup" layout="block" rendered="{!displayPopUp}" id="firstpopup" >
    firstpopup <br/>
    <apex:commandButton value="Hide Pop up" action="{!closePopup}" rerender="popup"/>
    <apex:commandButton value="show inner Pop up" action="{!showinnerpopup}" rerender="firstpopup"/>
    <apex:outputPanel styleClass="ccustomPopup" layout="block" rendered="{!displayinnerPopUp}" id="innerpopup">
    innerpopup <br/>
    <apex:commandButton value="Hide inner Pop up" action="{!closeinnerpopup}" rerender="firstpopup"/>
    </apex:outputPanel>
    </apex:outputPanel>
    </apex:outputPanel>
    </apex:form>
    <style type="text/css">
    .customPopup{
    background-color: lightgrey;
    border-style: solid;
    border-width: 1px;
    left: 65%;
    padding:10px;
    position: absolute;
    z-index: 999;

    width: 500px;
    margin-left: -250px;
    top:100px;
    .ccustomPopup{
    background-color: lightgrey;
    border-style: solid;
    border-width: 1px;
    left: 65%;
    padding:10px;
    position: absolute;
    width: 100px;
    margin-left: -250px;
    top:100px;}</style></apex:page>

     

    Its controller:

     

    public class popup {
    public boolean displayPopup {get; set;}
    public boolean displayinnerPopup {get; set;}
    public void closePopup() {
    displayPopup = false;
    displayinnerPopup=true;
    }
    public void showPopup() {
    displayPopup = true;
    displayinnerPopup =false;

    }
    public void showinnerpopup() {
    displayinnerPopup = true;
    }
    public void closeinnerpopup() {
    displayinnerPopup =false;
    }
    }

    • This reply was modified 8 years, 8 months ago by  Suyash.
  • Suyash

    Member
    April 14, 2016 at 7:57 am in reply to: Make Document accessible outside salesforce.

    Hi Sourabh

    You can make any Document available through a Force.com site. That is, as long as

    a) the Force.com site 'profile' has read access to Documents in general and

    b) the Force.com site 'user' has access to the folder that the Documents are stored in (usually they have, because a folder is generally available to 'everybody').

     

    Thanks.

  • Suyash

    Member
    April 14, 2016 at 7:54 am in reply to: How can I create Email Template from a Salesforce Visualforce page?

    Hi Ajay

    A direct article is written on your query.
    Go through the following link and you may find your answer

    https://developer.salesforce.com/docs/atlas.en-us.pages.meta/pages/pages_email_templates_creating.htm

    Thanks

  • Hi Nitish

    You can't use Map.keySet() directly in the dynamic, for this you must add map.keySet() either in a set or in list after that you can use it in your Dynamic query.

    In your case what you can do is:

    make a set of ids

    set<id> setofids=new set<id>();

    setofids= maps.keySet();

    now use this set in your dynamic soql like this

    String s = ‘Select Id from Contact Where Id IN :setofids’ ;

  • Suyash

    Member
    March 30, 2016 at 11:55 am in reply to: Formula Field in Aggregate Salesforce Query

    Hello Ajit,

    Formula fields are not "groupable" i.e they are not usable in the GROUP BY clause of a SOQL query.

Page 2 of 2