• Akash Pandey 25
  • NEWBIE
  • 5 Points
  • Member since 2019

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 5
    Replies
HI 

I have been stuck on this step for so many days now! Can someone please help? I have tried all combinations as well, nothing seems to work
Here is my latest iteration of the report-

User-added image
Can someone tell what is wrong here?
Hi all,
I'm currently facing a problem while attempting to "
For this pilot, provide Shinje Tashi access to the Language Preference field without modifying his profile. Name the solution you create for extending access Bilingual Pilot. After creating Lincoln, Lance, and Erin, make Shinje Tashi active to complete this requirement."
However, I am unable to locate the Language Preference field.

 User-added image
I Have few  questions on this step.

How many custom report types are needed?
I thought about 2, but can't properly figure out the correct objects:
  • Users with Volunteer Shift Worker Records 
    • A Primary Object = Users,  has at least one B record
    • B Secondary Object = Volunteer Shift, has at least one C record
    • C Tertiary Object = Volunteer Shift Worker
  • Accounts with Vol Activities with Vol Jobs
    • A Primary Object = Account, has at least one B record
    • B Secondary Object = Volunteer Activities, has at least one C record
    • C Tertiary object = Volunteer Jobs
What Am I missing here?

Thanks


 






 
Hi,

I'm currently working on the App Customization Specialist Lightning Superbadge.
I'm stuck on Challenge 4 with the reported error of:
 
Challenge Not yet complete... here's what's wrong: 
The 'My Top Volunteer Organizations' report is not sorting by the correct field.

However, I have summarized the shift hours and the report is sorted by Sum of Shift Hours, as seen below:

Report Builder:User-added image


Report:User-added image

Could this error description be incorrect and misleading?
If so, what else might be wrong on this report?
(Am I even correct to believe it is a problem with this report?)
Hi , I am also facing some problem with salesforce Trailhead SOQL injection Challenge, I tried many ways but still i am getting error .
can you suggest me where i am going wrong ?
​Thank you 

SOQL_Injection_Challenge:

public class SOQL_Injection_Challenge {
    public string textual {get; set;}
    public List<Supply__c> whereclause_records {get; set;}
//SELECT Id,Name,Quantity__c,Storage_Location__c,Type__c FROM Supply__c
    public PageReference whereclause_search(){
        string query = 'SELECT Id,Name,Quantity__c,Storage_Location__c,Storage_Location__r.Castle__c,Type__c FROM Supply__c';
        string whereClause = '';
        if(textual != null && textual!=''){
                whereClause += 'name like  \'%'+textual+'%\' ';
        }
        if(whereClause != ''){
            whereclause_records = database.query(query+' where '+whereClause+' Limit 10');
            validate(whereClause,whereclause_records.size());
        }
        return null;
    }
    public void validate(string s, integer i){
      if(s.contains('\'%') && s.containsIgnoreCase('Nobles_Only__c') && s.contains('%\'') && i<10){
        cvcs__c  v = cvcs__c.getInstance('sic1');
        if(v==null){
          v = new  cvcs__c(name='sic1',c1__c = 1);
        } else {
            v.c1__c += 1;
        }
        upsert v;
      }
    } 

}
  • September 25, 2017
  • Like
  • 0
Hi all, I am stuck on the prevent SOQL injection trailhead, where I am looking to determine which portions of the code I would need to invoke escapeSingleQuotes or whitelist to enable. I've made several attempts at investigation to little avail. I have appended my code are there any steps I would need to take. My goal is to assess the code to see how it works and what I would need to do.

Hope it helps.
 
public class Prevent_SOQL_Injection_Challenge {

    public string textOne {get; set;}
    public string textTwo {get; set;}
    public string comparator {get; set;}
    public string numberOne {get; set;}

    public List<Supply__c> whereclause_records {get; set;}


    public PageReference stringSearchOne(){
        string query = 'SELECT Id,Name,Quantity__c,Storage_Location__c,Storage_Location__r.Castle__c,Type__c FROM Supply__c';
        string whereClause = '';

        if(textOne != null && textOne!=''){
                whereClause += 'name like  \'%'+textOne+'%\' ';
        }

        if(whereClause != ''){
            whereclause_records = database.query(query+' where '+whereClause+' Limit 10');
        }

        return null;
    }


    public PageReference stringSearchTwo(){
        string query = 'SELECT Id,Name,Quantity__c,Storage_Location__c,Storage_Location__r.Castle__c,Type__c FROM Supply__c';
        string whereClause = '';

        if(textTwo != null && textTwo!=''){
                whereClause += 'Storage_Location__r.name like  \'%'+textTwo+'%\' ';
        }

        if(whereClause != ''){
            whereclause_records = database.query(query+' where '+whereClause+' Limit 10');
        }

        return null;
    }


    public PageReference numberSearchOne(){
        string query = 'SELECT Id,Name,Quantity__c,Storage_Location__c,Storage_Location__r.Castle__c,Type__c FROM Supply__c';
        string whereClause = '';

        if(numberOne != null && comparator != null){
            whereClause += 'Quantity__c '+comparator+' '+numberOne+' ';
        }

        if(whereClause != ''){
            whereclause_records = database.query(query+' where '+whereClause+' Limit 10');
        }

        return null;
    }

}