+ Start a Discussion
Abhishek VONTELA 11Abhishek VONTELA 11 

Help with App customization specialist Super badge

My Shifts Pending Approval Report is showing following error I have tried all the filters (status confirmed or canceled and Pending shift

Thanks in Advance User-added image
NagendraNagendra (Salesforce Developers) 
Hi Abhishek,

Please check with below piece of code if you have done the same.
<?xml version="1.0" encoding="UTF-8"?>
<Report xmlns="http://soap.sforce.com/2006/04/metadata">
    <columns>
        <field>User.Volunteer_Shift_Workers__r$Name</field>
    </columns>
    <columns>
        <field>User.Volunteer_Shift_Workers__r$Shift_Start_Time__c</field>
    </columns>
    <columns>
        <field>User.Volunteer_Shift_Workers__r$Volunteer_Activity__c</field>
    </columns>
    <columns>
        <field>User.Volunteer_Shift_Workers__r$Volunteer_Job__c</field>
    </columns>
    <columns>
        <field>User.Volunteer_Shift_Workers__r$Volunteer_Organization__c</field>
    </columns>
    <filter>
        <criteriaItems>
            <column>User.Volunteer_Shift_Workers__r$Status__c</column>
            <isUnlocked>false</isUnlocked>
            <operator>equals</operator>
            <value>Pending Approval</value>
        </criteriaItems>
        <criteriaItems>
            <column>User.Volunteer_Shift_Workers__r$IsShiftVolunteer__c</column>
            <isUnlocked>true</isUnlocked>
            <operator>equals</operator>
            <value>1</value>
        </criteriaItems>
    </filter>
    <format>Tabular</format>
    <name>My Shifts Pending Approval</name>
    <params>
        <name>co</name>
        <value>1</value>
    </params>
    <reportType>Users_with_Volunteer_Shift_Worker_Records__c</reportType>
    <scope>organization</scope>
    <showDetails>true</showDetails>
    <timeFrameFilter>
        <dateColumn>User.Volunteer_Shift_Workers__r$CreatedDate</dateColumn>
        <interval>INTERVAL_CUSTOM</interval>
    </timeFrameFilter>
</Report>
The above code works fine for me and was able to pass the challenge.

Please let us know if this helps.

Kindly mark this as solved if the reply was helpful.

Thanks,
Nagendra
 
Abhishek VONTELA 11Abhishek VONTELA 11
Can you please share the screenshot of the report I am new to salesforce i don't know  where to use the above mentioned metadata 
Thanks in Advance 
Ronak SFDCRonak SFDC
Hi,

Compare your report to mine below which works.

User-added image