Skip to main content
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 Help with App customization specialist Super badge
3 个回答
  1. 2018年7月18日 10:41
    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

     
0/9000