Skip to main content
Abhishek VONTELA (Meta) 님이 #Trailhead에 질문했습니다
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