Skip to main content

When specifying manual conditions in a date range subconditions are shown as options but the filter does not render when the page is loaded.


I’m keeping the primary condition filterable as stated in:
https://community.skuid.com/t/cant-deactivate-filterable-sub-condition-on-subquery


Are subconditions not supported in filters? If so, why do they show up as options under manually specified conditions?


Here is a sample page that should allow you to see my issue:


<skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="true" useviewportmeta="true" showheader="true">
<models>
<model id="Account" limit="20" query="true" createrowifnonefound="false" datasource="salesforce" sobject="Account">
<fields>
<field id="Id"/>
<field id="Name"/>
<field id="Contacts" type="childRelationship" limit="10">
<fields>
<field id="Name"/>
<field id="Id"/>
<field id="Birthdate"/>
</fields>
</field>
</fields>
<conditions>
<condition type="join" value="" field="Id" operator="in" enclosevalueinquotes="true" joinobject="Contact" joinfield="AccountId" fieldtargetobjects="Account" state="filterableon" inactive="false" name="subContactConditions">
<conditions>
<condition type="fieldvalue" value="" enclosevalueinquotes="false" field="Birthdate" state="filterableoff" inactive="true" name="subBirthdayStart" operator="gte"/>
<condition type="fieldvalue" value="" enclosevalueinquotes="false" field="Birthdate" operator="lte" state="filterableoff" inactive="true" name="subBirthdayEnd"/>
</conditions>
</condition>
<condition type="fieldvalue" value="" enclosevalueinquotes="false" field="CreatedDate" operator="gte" state="filterableoff" inactive="true" name="createdDateStart"/>
<condition type="fieldvalue" value="" enclosevalueinquotes="false" field="CreatedDate" operator="lte" state="filterableoff" inactive="true" name="createdDateEnd"/>
</conditions>
<actions/>
</model>
</models>
<components>
<filterset model="Account" searchmethod="server" searchbox="false" uniqueid="sk-3WX2-745" position="right" emptysearchbehavior="query">
<filters>
<filter type="daterange" createfilteroffoption="true" affectcookies="true" autocompthreshold="25" conditionsource="manual" labelmode="manual" filtermethod="server" startcondition="createdDateStart" endcondition="createdDateEnd" label="Account Created Date" filteroffoptionlabel="No Created Date Selected"/>
<filter type="daterange" createfilteroffoption="true" affectcookies="true" autocompthreshold="25" conditionsource="manual" labelmode="manual" filtermethod="server" startcondition="subBirthdayStart" endcondition="subBirthdayEnd" label="Contact Birthday" filteroffoptionlabel="No Contact Birthday Selected"/>
</filters>
<searchfields/>
</filterset>
<skootable showconditions="true" showsavecancel="false" showerrorsinline="true" searchmethod="server" searchbox="true" showexportbuttons="false" hideheader="false" hidefooter="false" pagesize="200" alwaysresetpagination="false" createrecords="false" model="Account" buttonposition="" mode="read" allowcolumnreordering="true" responsive="true" uniqueid="sk-3WX2-519">
<fields>
<field id="Name" hideable="true" uniqueid="fi-3WX2-538"/>
<field id="Id" hideable="true" uniqueid="fi-3WX2-539"/>
<field id="Contacts" type="CHILDREL" limit="100" hideable="true" uniqueid="fi-3WX2-593" allowhtml="true">
<label>Contacts</label>
<template>&amp;lt;ul&amp;gt;{{Name}} born on {{Birthdate}}&amp;lt;/ul&amp;gt;</template>
</field>
</fields>
<rowactions>
<action type="edit"/>
<action type="delete"/>
</rowactions>
<massactions usefirstitemasdefault="true">
<action type="massupdate"/>
<action type="massdelete"/>
</massactions>
<views>
<view type="standard"/>
</views>
<searchfields/>
</skootable>
</components>
<resources>
<labels/>
<javascript/>
<css/>
<actionsequences uniqueid="sk-3WX2-255"/>
</resources>
<styles>
<styleitem type="background" bgtype="none"/>
</styles>
</skuidpage>

I don’t see the birthday conditions anywhere in the model. I’m not positive the XML here is complete


Look for “Birthdate”


I just pasted the XML into a new page and I see the same issue


The birthdate conditions are in the XML of the original post. Look for:



<conditions>
<condition type="fieldvalue" value="" enclosevalueinquotes="false" field="Birthdate" state="filterableoff" inactive="true" name="subBirthdayStart" operator="gte"/>
<condition type="fieldvalue" value="" enclosevalueinquotes="false" field="Birthdate" operator="lte" state="filterableoff" inactive="true" name="subBirthdayEnd"/>
</conditions>

Stephen, just checking in here to confirm that the XML in the original post is complete.


This issue showed up again.


Reply