Subconditions Used Manually In Filters Do Not Show Up

  • 2
  • Problem
  • Updated 3 months ago
  • In Progress
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/skuid/topics/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>&lt;ul&gt;{{Name}} born on {{Birthdate}}&lt;/ul&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>
 
Photo of Shmuel Kamensky

Shmuel Kamensky, Champion

  • 4,328 Points 4k badge 2x thumb

Posted 5 months ago

  • 2
Photo of Stephen Sells

Stephen Sells, Official Rep

  • 16,856 Points 10k badge 2x thumb
I don't see the birthday conditions anywhere in the model. I'm not positive the XML here is complete
Photo of Shmuel Kamensky

Shmuel Kamensky, Champion

  • 4,328 Points 4k badge 2x thumb
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>
(Edited)
Photo of Shmuel Kamensky

Shmuel Kamensky, Champion

  • 4,328 Points 4k badge 2x thumb
Stephen, just checking in here to confirm that the XML in the original post is complete.
Photo of Shmuel Kamensky

Shmuel Kamensky, Champion

  • 4,328 Points 4k badge 2x thumb
This issue showed up again.