THIS_YEAR ,THIS_MONTH,TODAY and THIS_QUARTER NOT WORKING on GRID PAGE

  • 1
  • Problem
  • Updated 3 years ago
  • In Progress
I have one field called registration date.I have added manual select option filter.
There i have used THIS_YEAR,THIS_MONTH and other date filters.
but it is not working.
I have provided xml.Please check and let me know where I am doing mistake.
---------
<skuidpage unsavedchangeswarning="yes" showsidebar="false" showheader="true" tabtooverride="spct__Candidate__c" theme="Modern">
   <models>
      <model id="Candidate" limit="50" query="true" createrowifnonefound="false" sobject="spct__Candidate__c" doclone="" type="">
         <fields>
            <field id="spct__Age__c"/>
            <field id="spct__Annual_income__c"/>
            <field id="spct__Birthdate__c"/>
            <field id="Name"/>
            <field id="spct__Contact_Method__c"/>
            <field id="spct__Disability_Type__c"/>
            <field id="spct__Disabled__c"/>
            <field id="spct__First_name__c"/>
            <field id="spct__Job_Category__c"/>
            <field id="spct__Last_name__c"/>
            <field id="spct__Middle_name__c"/>
            <field id="spct__Partner__r.Name"/>
            <field id="spct__Picture__c"/>
            <field id="spct__Picture__r.Name"/>
            <field id="spct__Picture__r.skuid__AttachmentId__c"/>
            <field id="spct__Placed_by_Parent_Organization__c"/>
            <field id="spct__Program__c"/>
            <field id="spct__Program__r.Name"/>
            <field id="Id"/>
            <field id="spct__Referred_through__c"/>
            <field id="spct__Referred_through__r.Name"/>
            <field id="spct__Region__c"/>
            <field id="spct__Region__r.Name"/>
            <field id="spct__Registration_Date__c"/>
            <field id="spct__Registration_Date_Year__c"/>
            <field id="spct__Religion__c"/>
            <field id="spct__Salary__c"/>
            <field id="spct__Socio_economic_category__c"/>
            <field id="spct__Stage__c"/>
            <field id="spct__Work_Experience_In_Year__c"/>
            <field id="spct__Preferred_Shift__c"/>
            <field id="spct__Education_level__c"/>
            <field id="spct__Severity__c"/>
            <field id="spct__Company__c"/>
            <field id="spct__Company__r.Name"/>
            <field id="spct__Contacts__r.FirstName"/>
            <field id="spct__Contacts__r.LastName"/>
            <field id="spct__Contacts__r.MiddleName"/>
            <field id="spct__Contacts__r.HomePhone"/>
            <field id="spct__Primary_Phone__c"/>
            <field id="spct__Email__c"/>
            <field id="spct__Reason_For_Inactive__c"/>
            <field id="spct__Contacts__c"/>
            <field id="spct__Contacts__r.Name"/>
            <field id="spct__Contacts__r.spct__Primary_Phone__c"/>
            <field id="spct__Contacts__r.Birthdate"/>
            <field id="spct__Contacts__r.Email"/>
            <field id="spct__Reason_for_inactive_description__c"/>
            <field id="spct__Contacts__r.MobilePhone"/>
            <field id="spct__Contacts__r.spct__Phone_Reachability__c"/>
            <field id="spct__Contacts__r.spct__Date_Of_Call__c"/>
            <field id="spct__Prev_Id__c"/>
            <field id="spct__Contacts__r.MailingAddress"/>
            <field id="spct__Contacts__r.OtherAddress"/>
            <field id="spct__Willing_to_relocate__c"/>
            <field id="spct__Facebook__c"/>
            <field id="spct__Linkedin__c"/>
            <field id="spct__Twitter__c"/>
            <field id="spct__Marital_Status__c"/>
            <field id="spct__Beneficiary_Entity__c"/>
            <field id="spct__Beneficiary_Status__c"/>
            <field id="spct__Beneficiary_Demographics__c"/>
            <field id="spct__Beneficiary_Type__c"/>
            <field id="spct__Beneficiary_Socioeconomics__c"/>
            <field id="spct__Beneficiary_Settings__c"/>
            <field id="spct__Gender__c"/>
            <field id="spct__WPS_Options__c"/>
            <field id="spct__WPS_solutions__c"/>
            <field id="spct__Current_Situation__c"/>
            <field id="spct__Is_Unemployed__c"/>
            <field id="spct__Expected_Salary__c"/>
            <field id="spct__Distance_Travel_Preference__c"/>
            <field id="spct__Shift_Information__c"/>
            <field id="spct__Preferred_Location__c"/>
            <field id="spct__Preferred_Location__r.Name"/>
            <field id="spct__SMART_Value__c"/>
            <field id="spct__No_of_time_Placed__c"/>
            <field id="spct__Communication__c"/>
            <field id="spct__Typing_Speed__c"/>
            <field id="spct__Basic_Computer__c"/>
            <field id="spct__Referred_through__r.spct__Partner_Name_String__c"/>
            <field id="spct__Contacts__r.MailingStreet"/>
            <field id="spct__Contacts__r.MailingCity"/>
            <field id="spct__Contacts__r.MailingPostalCode"/>
            <field id="spct__Contacts__r.MailingState"/>
            <field id="spct__Contacts__r.MailingStateCode"/>
            <field id="spct__Contacts__r.MailingCountry"/>
            <field id="spct__Contacts__r.MailingCountryCode"/>
            <field id="spct__Contacts__r.OtherStreet"/>
            <field id="spct__Contacts__r.OtherPostalCode"/>
            <field id="spct__Contacts__r.OtherCity"/>
            <field id="spct__Contacts__r.OtherState"/>
            <field id="spct__Contacts__r.OtherStateCode"/>
            <field id="spct__Contacts__r.OtherCountry"/>
            <field id="spct__Contacts__r.OtherCountryCode"/>
            <field id="spct__Training_Recommended_Candidates__r" type="childRelationship" limit="10">
               <fields>
                  <field id="spct__Training__c"/>
                  <field id="spct__Training__r.Name"/>
               </fields>
            </field>
            <field id="spct__Source__c"/>
            <field id="spct__Contacts__r.spct__Current_Region__c"/>
            <field id="spct__Contacts__r.spct__Current_Region__r.Name"/>
            <field id="spct__Contacts__r.spct__Permanent_Region__c"/>
            <field id="spct__Contacts__r.spct__Permanent_Region__r.Name"/>
            <field id="spct__Contacts__r.spct__Age__c"/>
            <field id="spct__Unemployed_Since__c"/>
            <field id="spct__Track_Information__c"/>
            <field id="CreatedById"/>
            <field id="CreatedBy.Name"/>
            <field id="spct__Id__c"/>
            <field id="spct__Contacts__r.spct__Permanent_Region__r.spct__Parent__c"/>
            <field id="spct__Contacts__r.spct__Permanent_Region__r.spct__Parent__r.Name"/>
            <field id="spct__Employable__c"/>
            <field id="spct__Minimum_End_Date__c"/>
         </fields>
         <conditions logic="25 OR 24 OR 23 OR 22 OR 26 OR 27 OR 28 OR 29">
            <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="spct__Stage__c" state="filterableoff" inactive="true" name="Stage__c1"/>
            <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="spct__Gender__c" state="filterableoff" inactive="true" name="Gender__c"/>
            <condition type="fieldvalue" value="TODAY" enclosevalueinquotes="false" field="spct__Registration_Date__c" state="filterableoff" inactive="true" name="Todays" operator="="/>
            <condition type="fieldvalue" value="THIS_WEEK" enclosevalueinquotes="false" field="spct__Registration_Date__c" state="filterableoff" inactive="true" name="This_WEEK"/>
            <condition type="fieldvalue" value="THIS_MONTH" enclosevalueinquotes="false" field="spct__Registration_Date__c" state="filterableoff" inactive="true" name="THIS_MONTH"/>
            <condition type="fieldvalue" value="THIS_QUARTER" enclosevalueinquotes="false" field="spct__Registration_Date__c" state="filterableoff" inactive="true" name="THIS_QUARTER"/>
            <condition type="fieldvalue" value="THIS_YEAR" enclosevalueinquotes="false" field="spct__Registration_Date__c" state="filterableoff" inactive="true" name="THIS_YEAR" operator="="/>
            <condition type="fieldvalue" value="THIS_FISCAL_YEAR" enclosevalueinquotes="false" field="spct__Registration_Date__c" state="filterableoff" inactive="true" name="THIS_FISCAL_YEAR"/>
            <condition type="multiple" value="" field="spct__Stage__c" operator="in" mergefield="Id" novaluebehavior="deactivate" enclosevalueinquotes="true" state="filterableoff" inactive="true" name="stage_job_seeker_employable">
               <values>
                  <value>Employable</value>
                  <value>Job Seeker</value>
               </values>
            </condition>
            <condition type="fieldvalue" value="" field="spct__Preferred_Shift__c" state="filterableoff" inactive="true" name="Preferred_Shift" operator="=" mergefield="Preferred_Shift__c" novaluebehavior="deactivate" enclosevalueinquotes="true"/>
            <condition type="join" value="" field="Id" operator="in" mergefield="Individual_Name__c" novaluebehavior="deactivate" state="filterableoff" inactive="true" enclosevalueinquotes="true" joinobject="Qualification_Histroy__c" joinfield="Individual_Name__c" logic="" name="QualificationHistory">
               <conditions>
                  <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="spct__Qualification__c" state="filterableoff" inactive="true" name="QualificationHistorySub" operator="="/>
               </conditions>
            </condition>
            <condition type="fieldvalue" value="0.0" enclosevalueinquotes="false" field="spct__Annual_income__c" operator="gt" state="filterableoff" inactive="true" name="Annual_Income"/>
            <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="spct__Region__c" state="filterableoff" inactive="true" name="Region__c"/>
            <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="Id" state="filterableoff" inactive="true" name="CandidateId"/>
            <condition type="multiple" field="spct__Education_level__c" operator="includes" inactive="true" enclosevalueinquotes="true" name="__autofilter__spct__Education_level__c" state="filterableoff" value=""/>
            <condition type="fieldvalue" field="spct__Registration_Date__c" operator="gte" inactive="true" enclosevalueinquotes="false" name="__autofilter__start__spct__Registration_Date__c" state="filterableoff" value=""/>
            <condition type="fieldvalue" field="spct__Registration_Date__c" operator="lte" inactive="true" enclosevalueinquotes="false" name="__autofilter__end__spct__Registration_Date__c" state="filterableoff" value=""/>
            <condition type="join" value="" field="Id" operator="in" novaluebehavior="" enclosevalueinquotes="true" joinobject="spct__Qualification_Histroy__c" joinfield="spct__Individual_Name__c" state="filterableoff" inactive="true" name="Qualification_History">
               <conditions>
                  <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="spct__Qualification__c" state="filterableoff" inactive="true" name="QualificationCondition" operator="="/>
               </conditions>
            </condition>
            <condition type="join" value="" field="Id" operator="in" mergefield="Id" novaluebehavior="deactivate" enclosevalueinquotes="true" joinobject="spct__Training_Recommended_Candidates__c" joinfield="spct__Candidate__c" state="filterableoff" inactive="true" name="RcommendedTrainingName">
               <conditions>
                  <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="spct__Training__c" state="filterableoff" inactive="true" name="TrainingList" operator="="/>
               </conditions>
            </condition>
            <condition type="fieldvalue" value="0" enclosevalueinquotes="false" field="spct__Work_Experience_In_Year__c" operator="lte" state="filterableoff" inactive="true" name="LessThanAndEqualCondition"/>
            <condition type="fieldvalue" value="0" enclosevalueinquotes="false" field="spct__Work_Experience_In_Year__c" operator="gte" state="filterableoff" inactive="true" name="GraterThanAndEqualCondition"/>
            <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="spct__Contacts__r.spct__Permanent_Region__c" state="filterableoff" inactive="true" name="permanent_region"/>
            <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="spct__Contacts__r.spct__Permanent_Region__r.spct__Parent__c" state="filterableoff" inactive="true" name="parent_permanent_region"/>
            <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="spct__Contacts__r.spct__Permanent_Region__r.spct__Parent__r.spct__Parent__c" state="filterableoff" inactive="true" name="permmant_region_parent_parent"/>
            <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="spct__Contacts__r.spct__Permanent_Region__r.spct__Parent__r.spct__Parent__r.spct__Parent__c" operator="=" state="filterableoff" inactive="true" name="permanent_region_parent_parent_parent"/>
            <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="spct__Contacts__r.spct__Current_Region__c" state="filterableoff" inactive="true" name="Current_Region"/>
            <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="spct__Contacts__r.spct__Current_Region__r.spct__Parent__c" state="filterableoff" inactive="true" name="Current_Region_Parent"/>
            <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="spct__Contacts__r.spct__Current_Region__r.spct__Parent__r.spct__Parent__c" state="filterableoff" inactive="true" name="Current_Region_Parent_Parent"/>
            <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="spct__Contacts__r.spct__Current_Region__r.spct__Parent__r.spct__Parent__r.spct__Parent__c" state="filterableoff" inactive="true" name="Current_Region_Parent_Parent_Parent" operator="="/>
         </conditions>
         <actions/>
         <groupby method="simple"/>
      </model>
      <model id="Enrollment" limit="20" query="true" createrowifnonefound="true" sobject="spct__Enrollment__c" doclone="" type="">
         <fields>
            <field id="spct__Candidate__c"/>
            <field id="spct__Candidate__r.Name"/>
            <field id="spct__Class__c"/>
            <field id="spct__Class__r.Name"/>
            <field id="spct__Employer_Feedback__c"/>
            <field id="spct__Employer_rating__c"/>
            <field id="spct__End_date__c"/>
            <field id="Name"/>
            <field id="spct__Job_Rating__c"/>
            <field id="spct__School_Rating__c"/>
            <field id="spct__Stage__c"/>
            <field id="spct__Start_date__c"/>
            <field id="spct__Student_feedback__c"/>
            <field id="spct__Student_rating__c"/>
            <field id="spct__Candidate__r.spct__Contacts__r.Name"/>
            <field id="spct__Class__r.spct__Stage__c"/>
            <field id="spct__Candidate__r.Id"/>
         </fields>
         <conditions>
            <condition type="modelmerge" value="" field="spct__Candidate__c" operator="=" novaluebehavior="deactivate" model="Candidate" enclosevalueinquotes="true" mergefield="Id"/>
         </conditions>
         <actions/>
      </model>
      <model id="Qualification" limit="1000" query="true" createrowifnonefound="false" sobject="spct__Qualification__c" doclone="" type="">
         <fields>
            <field id="Name"/>
         </fields>
         <conditions/>
         <actions/>
      </model>
      <model id="Qualification_Histroy" limit="30" query="true" createrowifnonefound="false" sobject="spct__Qualification_Histroy__c" doclone="" type="">
         <fields>
            <field id="spct__Individual_Name__c"/>
            <field id="spct__Individual_Name__r.Name"/>
            <field id="spct__Percentage__c"/>
            <field id="spct__Passing_Year__c"/>
            <field id="spct__Qualification__c"/>
            <field id="spct__Qualification__r.Name"/>
         </fields>
         <conditions/>
         <actions/>
      </model>
      <model id="OpenTasks" limit="20" query="true" createrowifnonefound="false" sobject="Task">
         <fields>
            <field id="WhoId"/>
            <field id="Who.Name"/>
            <field id="OwnerId"/>
            <field id="Owner.Name"/>
            <field id="CallDisposition"/>
            <field id="CallType"/>
            <field id="IsClosed"/>
            <field id="Description"/>
            <field id="ActivityDate"/>
            <field id="Priority"/>
            <field id="ReminderDateTime"/>
            <field id="Status"/>
            <field id="Subject"/>
         </fields>
         <conditions>
            <condition type="fieldvalue" value="" field="WhoId" state="filterableon" inactive="false" operator="=" mergefield="Id" novaluebehavior="deactivate" enclosevalueinquotes="true" name="WhoId"/>
            <condition type="fieldvalue" value="false" enclosevalueinquotes="false" field="IsClosed"/>
            <condition type="blank" value="null" field="WhoId" operator="!=" enclosevalueinquotes="false"/>
         </conditions>
         <actions/>
      </model>
      <model id="TaskHistory" limit="20" query="true" createrowifnonefound="false" sobject="Task">
         <fields>
            <field id="OwnerId"/>
            <field id="Owner.Name"/>
            <field id="Subject"/>
            <field id="Status"/>
            <field id="Priority"/>
            <field id="ActivityDate"/>
            <field id="CallDisposition"/>
            <field id="CallType"/>
            <field id="CallDurationInSeconds"/>
            <field id="Description"/>
            <field id="WhoId"/>
            <field id="Who.Name"/>
         </fields>
         <conditions>
            <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="WhoId" state="filterableon" inactive="false" name="WhoId"/>
            <condition type="fieldvalue" value="true" enclosevalueinquotes="false" field="IsClosed"/>
            <condition type="blank" value="null" field="WhoId" operator="!=" enclosevalueinquotes="false"/>
         </conditions>
         <actions/>
      </model>
      <model id="CountCandidate" limit="" query="true" createrowifnonefound="false" sobject="spct__Candidate__c" doclone="" type="aggregate">
         <fields>
            <field id="Id" name="countId" function="COUNT"/>
         </fields>
         <conditions>
            <condition type="fieldvalue" field="spct__Registration_Date__c" operator="gte" inactive="true" enclosevalueinquotes="false" name="__autofilter__start__spct__Registration_Date__c" state="filterableoff" value=""/>
            <condition type="fieldvalue" field="spct__Registration_Date__c" operator="lte" inactive="true" enclosevalueinquotes="false" name="__autofilter__end__spct__Registration_Date__c" state="filterableoff" value=""/>
            <condition type="fieldvalue" field="spct__Education_level__c" operator="=" inactive="true" enclosevalueinquotes="true" name="__autofilter__spct__Education_level__c" state="filterableoff" value=""/>
            <condition type="fieldvalue" field="spct__Stage__c" operator="=" inactive="true" enclosevalueinquotes="true" name="__autofilter__spct__Stage__c" state="filterableoff" value=""/>
            <condition type="fieldvalue" value="TODAY" enclosevalueinquotes="false" field="spct__Registration_Date__c" state="filterableoff" inactive="true" name="Today"/>
            <condition type="fieldvalue" value="THIS_WEEK" enclosevalueinquotes="false" field="spct__Registration_Date__c" state="filterableoff" inactive="true" name="This_week"/>
            <condition type="fieldvalue" value="THIS_MONTH" enclosevalueinquotes="false" field="spct__Registration_Date__c" state="filterableoff" inactive="true" name="THIS_MONTH"/>
            <condition type="fieldvalue" value="THIS_YEAR" enclosevalueinquotes="false" field="spct__Registration_Date__c" state="filterableoff" inactive="true" name="THIS_YEAR"/>
            <condition type="fieldvalue" value="THIS_FISCAL_YEAR" enclosevalueinquotes="false" field="spct__Registration_Date__c" state="filterableoff" inactive="true" name="THIIS_FISCAL_YEAR"/>
            <condition type="join" value="" field="Id" operator="in" mergefield="Id" novaluebehavior="deactivate" state="filterableoff" inactive="true" name="QualificationHistory" enclosevalueinquotes="true" joinobject="spct__Qualification_Histroy__c" joinfield="spct__Individual_Name__c">
               <conditions>
                  <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="spct__Qualification__c" state="filterableoff" inactive="true" name="Qualification_sub"/>
               </conditions>
            </condition>
            <condition type="fieldvalue" field="spct__Preferred_Shift__c" operator="=" inactive="true" enclosevalueinquotes="true" name="__autofilter__spct__Preferred_Shift__c" state="filterableoff" value=""/>
            <condition type="fieldvalue" value="0.0" enclosevalueinquotes="false" field="spct__Annual_income__c" state="filterableoff" inactive="true" operator="gt" name="annual_income"/>
            <condition type="fieldvalue" field="spct__Disability_Type__c" operator="=" inactive="true" enclosevalueinquotes="true" name="__autofilter__spct__Disability_Type__c" state="filterableoff" value=""/>
            <condition type="fieldvalue" field="spct__Severity__c" operator="=" inactive="true" enclosevalueinquotes="true" name="__autofilter__spct__Severity__c" state="filterableoff" value=""/>
            <condition type="fieldvalue" field="spct__Job_Category__c" operator="=" inactive="true" enclosevalueinquotes="true" name="__autofilter__spct__Job_Category__c" state="filterableoff" value=""/>
            <condition type="join" value="" field="Id" operator="in" enclosevalueinquotes="true" joinobject="spct__Training_Recommended_Candidates__c" joinfield="spct__Candidate__c" state="filterableoff" inactive="true" name="RcommendedTrainingName">
               <conditions>
                  <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="spct__Training__c" state="filterableoff" inactive="true" name="TrainingList" operator="="/>
               </conditions>
            </condition>
            <condition type="fieldvalue" field="spct__Contacts__r.spct__Permanent_Region__c" operator="=" inactive="true" enclosevalueinquotes="true" name="__autofilter__spct__Contacts__r.spct__Permanent_Region__c" state="filterableoff" value=""/>
            <condition type="fieldvalue" field="spct__Contacts__r.spct__Current_Region__c" operator="=" inactive="true" enclosevalueinquotes="true" name="__autofilter__spct__Contacts__r.spct__Current_Region__c" state="filterableoff" value=""/>
            <condition type="fieldvalue" value="0.0" enclosevalueinquotes="false" field="spct__Work_Experience_In_Year__c" operator="gte" state="filterableoff" inactive="true" name="GreterThanEquals"/>
            <condition type="fieldvalue" value="0.0" enclosevalueinquotes="false" field="spct__Work_Experience_In_Year__c" operator="lte" state="filterableoff" inactive="true" name="LessThanEquals"/>
         </conditions>
         <actions/>
         <groupby method="simple"/>
      </model>
      <model id="Training_Recommended_Candidates" limit="20" query="true" createrowifnonefound="false" sobject="spct__Training_Recommended_Candidates__c" doclone="" type="">
         <fields>
            <field id="spct__Candidate__c"/>
            <field id="spct__Candidate__r.Name"/>
            <field id="spct__Training__c"/>
            <field id="spct__Training__r.Name"/>
         </fields>
         <conditions/>
         <actions/>
      </model>
      <model id="spct__Training__c" limit="30" query="true" createrowifnonefound="false" sobject="spct__Training__c" doclone="" type="">
         <fields>
            <field id="Name"/>
         </fields>
         <conditions/>
         <actions/>
      </model>
      <model id="AddEnrollment" limit="1" query="false" createrowifnonefound="true" sobject="spct__Enrollment__c" doclone="" type="">
         <fields>
            <field id="spct__Candidate__c"/>
            <field id="spct__Candidate__r.Name"/>
            <field id="spct__Class__c"/>
            <field id="spct__Class__r.Name"/>
            <field id="spct__Employer_Feedback__c"/>
            <field id="spct__Employer_rating__c"/>
            <field id="spct__End_date__c"/>
            <field id="Name"/>
            <field id="spct__Job_Rating__c"/>
            <field id="spct__School_Rating__c"/>
            <field id="spct__Stage__c"/>
            <field id="spct__Start_date__c"/>
            <field id="spct__Student_feedback__c"/>
            <field id="spct__Student_rating__c"/>
            <field id="spct__Candidate__r.spct__Contacts__r.Name"/>
            <field id="spct__Class__r.spct__Stage__c"/>
            <field id="spct__Candidate__r.Id"/>
         </fields>
         <conditions/>
         <actions/>
      </model>
      <model id="User" limit="20" query="true" createrowifnonefound="false" sobject="User">
         <fields>
            <field id="ProfileId"/>
            <field id="Profile.Name"/>
         </fields>
         <conditions>
            <condition type="userinfo" value="" field="Id" operator="=" enclosevalueinquotes="true" userinfotype="userid"/>
         </conditions>
         <actions/>
      </model>
      <model id="CurrentPermanentRegionFilter" limit="8000" query="true" createrowifnonefound="false" sobject="spct__Region__c" doclone="" type="" orderby="">
         <fields>
            <field id="Name"/>
            <field id="Id"/>
         </fields>
         <conditions/>
         <actions/>
      </model>
   </models>
   <components>
      <tabset rememberlastusertab="true" defertabrendering="true" renderas="">
         <tabs>
            <tab name="Candidates" loadlazypanels="true" icon="sk-icon-activities">
               <components>
                  <basicfieldeditor showheader="true" showsavecancel="true" model="Candidate" buttonposition="" mode="edit" layout="">
                     <columns/>
                  </basicfieldeditor>
                  <template multiple="false" model="CountCandidate" allowhtml="true">
                     <contents>
&lt;div class="nx-conditiontoken nx-actionselect"&gt;&lt;div class="nx-actionselect-text"&gt;
&lt;a style="color:#fff" href="/apex/skuid__ui?page=Beneficiary"&gt;Reset Filters&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;/div&gt;
</contents>
                  </template>
                  <skootable showconditions="true" showsavecancel="true" searchmethod="server" searchbox="true" showexportbuttons="true" pagesize="50" createrecords="false" model="Candidate" mode="read" buttonposition="" tokenizesearch="true" emptysearchbehavior="query" allowscrollbars="false" floatheader="true" tablescrollheight="600" freezeleftcolumns="true" columnstofreeze="1">
                     <fields>
                        <field type="COMBO" valuehalign="" allowordering="true" orderfield="spct__First_name__c" allowhtml="true">
                           <label>Candidate Name</label>
                           <template>{{spct__Contacts__r.FirstName}} {{spct__Contacts__r.MiddleName}} {{spct__Contacts__r.LastName}}</template>
                        </field>
                        <field id="spct__Id__c" valuehalign="" type="">
                           <label>REG ID</label>
                        </field>
                        <field id="spct__Disability_Type__c" valuehalign="" type="" allowordering="true"/>
                        <field id="spct__Severity__c" valuehalign="" type="" allowordering="true"/>
                        <field id="spct__Contacts__r.Birthdate" valuehalign="" type=""/>
                        <field type="COMBO" valuehalign="">
                           <label>Company</label>
                           <template>{{{spct__Company__r.Name}}}</template>
                        </field>
                        <field id="spct__Contacts__r.spct__Primary_Phone__c" valuehalign="" type=""/>
                        <field id="spct__Contacts__r.Email" valuehalign="" type=""/>
                        <field id="spct__Contacts__r.spct__Current_Region__c" valuehalign="" type=""/>
                        <field id="spct__Job_Category__c" valuehalign="" type="" readonly="true"/>
                        <field id="spct__Stage__c" valuehalign="" type="" allowordering="true" readonly="true"/>
                        <field id="spct__Registration_Date__c" valuehalign="" type="" allowordering="true"/>
                        <field id="spct__Training_Recommended_Candidates__r" type="CHILDREL" limit="100" valuehalign="" delimiter="" allowhtml="true">
                           <label>Recommanded Training</label>
                           <template>{{{spct__Training__r.Name}}}&lt;br/&gt;</template>
                        </field>
                        <field id="spct__Work_Experience_In_Year__c" decimalplaces="" valuehalign="" type="" allowordering="true"/>
                        <field id="spct__Contacts__r.spct__Permanent_Region__c" valuehalign="" type=""/>
                        <field id="spct__Minimum_End_Date__c"/>
                     </fields>
                     <rowactions>
                        <action type="edit">
                           <drawer title="Drawer Area" width="800" closehandle="true">
                              <components/>
                           </drawer>
                        </action>
                        <action type="redirect" label="View" icon="sk-icon-account-transfer" window="blank" url="/apex/skuid__ui?page=CandidateDetail&amp;id={{Id}}">
                           <drawer title="Drawer Area" width="800" closehandle="true">
                              <components/>
                           </drawer>
                           <popup width="80%" title="Viewing {{Model.label}}: {{Name}}">
                              <components>
                                 <includepanel type="skuid" pagename="CandidateDetail1" module="Enable India" uniqueid=""/>
                              </components>
                           </popup>
                        </action>
                        <action type="redirect" label="Enrollment " icon="sk-icon-popup" snippet="Enroll" window="blank" url="/apex/skuid__ui?page=CandidateEnrollmentList&amp;id={{Id}}">
                           <drawer title="Drawer Area" width="800" closehandle="true">
                              <components/>
                           </drawer>
                           <popup width="80%" title="Viewing {{Model.label}}: {{Name}}">
                              <components>
                                 <basicfieldeditor showheader="true" showsavecancel="true" model="AddEnrollment" buttonposition="" mode="edit" layout="">
                                    <columns>
                                       <column width="50%">
                                          <sections>
                                             <section title="Add Enrollment" collapsible="no">
                                                <fields>
                                                   <field id="spct__Class__c"/>
                                                </fields>
                                             </section>
                                          </sections>
                                       </column>
                                       <column width="50%">
                                          <sections>
                                             <section title="" collapsible="no">
                                                <fields>
              &n
Photo of Rohit Vakhariya

Rohit Vakhariya

  • 1,054 Points 1k badge 2x thumb

Posted 3 years ago

  • 1
Photo of Rohit Vakhariya

Rohit Vakhariya

  • 1,054 Points 1k badge 2x thumb
You have to check Reg Date Filter.
Photo of Anna Wiersema

Anna Wiersema

  • 10,890 Points 10k badge 2x thumb
Hi Rohit, I was able to get THIS_YEAR, THIS_MONTH etc. to work in a custom date field filter in this way:
  1. Create just one condition on the date field <i>without</i> a value and set it filterable default off. 
  2. Then create a manual select option on that date field condition.
  3. Manually add options to "affect the default condition" and enter TODAY, LAST_YEAR etc. for the value.  This should save you in the future from having to make a condition for each value.
Is this what you tried to do? It looks like your XML got cut off before the filters section. Can you send just that section so I can better see what's going on?
Photo of Rohit Vakhariya

Rohit Vakhariya

  • 1,054 Points 1k badge 2x thumb
This is not working for me.
Find out filter code.
Below is condition
----------------------
<condition type="fieldvalue" value="" enclosevalueinquotes="false" field="spct__Registration_Date__c" state="filterableoff" inactive="true" name="registration_date" operator="="/>
------------------
below code of filter
------------------------------------
<filter type="select" filteroffoptionlabel="Reg Date" createfilteroffoption="true" affectcookies="false" autocompthreshold="25" conditionsource="manual" labelmode="no" condition="THIS_YEAR">
                           <sources>
                              <source type="manual" effectsbehavior="justdefault">
                                 <options>
                                    <option label="Today's Candidates" type="complex">
                                       <effects>
                                          <effect action="set" value="TODAY" condition="registration_date"/>
                                       </effects>
                                    </option>
                                    <option label="This Week" type="complex">
                                       <effects>
                                          <effect action="set" value="THIS_WEEK" condition="registration_date"/>
                                       </effects>
                                    </option>
                                    <option label="This Month" type="complex">
                                       <effects>
                                          <effect action="set" value="THIS_MONTH" condition="registration_date"/>
                                       </effects>
                                    </option>
                                    <option label="This Quarter" type="complex">
                                       <effects>
                                          <effect action="set" value="THIS_QUARTER" condition="registration_date"/>
                                       </effects>
                                    </option>
                                    <option label="This Year" type="complex">
                                       <effects>
                                          <effect action="set" value="THIS_YEAR" condition="registration_date"/>
                                       </effects>
                                    </option>
                                    <option label="This Fiscal Year" type="complex">
                                       <effects>
                                          <effect action="set" value="THIS_FISCAL_YEAR" condition="registration_date"/>
                                       </effects>
                                    </option>
                                 </options>
                              </source>
                           </sources>
                        </filter>
--------------------------------------
This filters are working fine in old release but after 8.6.20 I found this issue.
(Edited)
Photo of Anna Wiersema

Anna Wiersema

  • 10,890 Points 10k badge 2x thumb
It looks like your filter is set to a different condition. Try substituting this for the first couple lines of the filter and let me know if it works:


<filter type="select" filteroffoptionlabel="Reg Date" createfilteroffoption="true" affectcookies="false" autocompthreshold="25" conditionsource="manual" labelmode="no" condition="THIS_YEAR">
(Edited)
Photo of Rohit Vakhariya

Rohit Vakhariya

  • 1,054 Points 1k badge 2x thumb
This also not work for me.