
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
3 个回答