Toggle Table Filter Issue when condition has multiple values

  • 1
  • Problem
  • Updated 8 months ago
  • In Progress
I have a Model such conditions are activate/deactivate in Table by Toggle Filter

Something happens with this Toggle Filter that is not working for kind of conditions 
 where data is (or not) including multiple values.



FIELD: myField
OPERATOR: "is in the set of values" / "is not in the set of values"
VALUE: X, Y, Z
STATE: "This condition, named myCondition, can be modified by filters, but is on/off by Default"




Problem is, when Toggle filter is active, it performs the action.. Let's say Activate Condition 1.
But when trying to undo the action, the filter is doesn't Deactivate the condition.


Here is a test XML page you can try
There are two tables: 

First one, for model AccountsEquals   with the working Toggle Filter.
Second, for model AccountsIn with the Toggle issue. 

<skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="true" useviewportmeta="true" showheader="true">
    <models>
        <model id="AccountsEquals" limit="20" query="true" createrowifnonefound="false" datasource="salesforce" sobject="Account">
            <fields>
                <field id="Id"/>
                <field id="Name"/>
            </fields>
            <conditions>
                <condition type="fieldvalue" value="Abc" enclosevalueinquotes="true" field="Name" operator="starts with"/>
                <condition type="fieldvalue" value="ABC NETWORKS" field="Name" operator="=" state="filterableoff" inactive="true" name="Name" enclosevalueinquotes="true"/>
            </conditions>
            <actions/>
        </model>
        <model id="AccountsIn" limit="20" query="true" createrowifnonefound="false" datasource="salesforce" sobject="Account">
            <fields>
                <field id="Id"/>
                <field id="Name"/>
            </fields>
            <conditions>
                <condition type="fieldvalue" value="Abc" enclosevalueinquotes="true" field="Name" operator="starts with"/>
                <condition type="multiple" value="" field="Name" operator="in" enclosevalueinquotes="true" state="filterableoff" inactive="true" name="NameIN">
                    <values>
                        <value>ABC NETWORKS</value>
                        <value>ABC Electric Inc</value>
                    </values>
                </condition>
            </conditions>
            <actions/>
        </model>
    </models>
    <components>
        <skootable showconditions="true" showsavecancel="false" showerrorsinline="true" searchmethod="server" searchbox="false" showexportbuttons="false" hideheader="false" hidefooter="false" pagesize="10" alwaysresetpagination="false" createrecords="false" model="AccountsEquals" mode="readonly" allowcolumnreordering="false" responsive="true" uniqueid="sk-3U868W-1295" buttonposition="left" emptysearchbehavior="query">
            <fields>
                <field id="Id" hideable="false" uniqueid="fi-3U8CDA-1371" showbydefault="true"/>
                <field id="Name" hideable="false" uniqueid="fi-3U8BtL-1359" showbydefault="true"/>
            </fields>
            <rowactions/>
            <massactions usefirstitemasdefault="true"/>
            <views>
                <view type="standard"/>
            </views>
            <filters>
                <filter type="toggle" createfilteroffoption="true" affectcookies="true" autocompthreshold="25" conditionsource="manual" labelmode="auto" filtermethod="server" label="Active FilterEquals">
                    <effects>
                        <effect action="activate" value="" condition="Name"/>
                    </effects>
                </filter>
            </filters>
            <searchfields/>
        </skootable>
        <skootable showconditions="true" showsavecancel="false" showerrorsinline="true" searchmethod="server" searchbox="false" showexportbuttons="false" hideheader="false" hidefooter="false" pagesize="10" alwaysresetpagination="false" createrecords="false" model="AccountsIn" mode="readonly" allowcolumnreordering="false" responsive="true" uniqueid="sk-3UK2cj-669" emptysearchbehavior="query" buttonposition="left">
            <fields>
                <field id="Id" hideable="false" uniqueid="fi-3UK9EC-734" showbydefault="true"/>
                <field id="Name" hideable="false" uniqueid="fi-3UK8uS-722" showbydefault="true"/>
            </fields>
            <rowactions/>
            <massactions usefirstitemasdefault="true"/>
            <views>
                <view type="standard"/>
            </views>
            <filters>
                <filter type="toggle" createfilteroffoption="true" affectcookies="true" autocompthreshold="25" conditionsource="manual" labelmode="auto" filtermethod="server" label="Active Filter IN">
                    <effects>
                        <effect action="activate" value="" condition="NameIN"/>
                    </effects>
                </filter>
            </filters>
            <searchfields/>
        </skootable>
    </components>
    <resources>
        <labels/>
        <javascript/>
        <css/>
        <actionsequences uniqueid="sk-3U4sgK-283"/>
    </resources>
    <styles>
        <styleitem type="background" bgtype="none"/>
    </styles>
</skuidpage>

I hope this might be a well-know issue.. 
Thanks
Photo of Fernando Ramirez

Fernando Ramirez

  • 212 Points 100 badge 2x thumb

Posted 9 months ago

  • 1
Photo of Peter Hale

Peter Hale, Employee

  • 330 Points 250 badge 2x thumb
I tested the XML snippet in a new page, but de-activated the first filter.  In version 11.0.0, it seems to work.  What version do you have?
Photo of Fernando Ramirez

Fernando Ramirez

  • 212 Points 100 badge 2x thumb
Sorry, I forgot to mention Skuid version is Millau (11.1.1)

Wondering if you tested Toggle filter at the second table

Photo of Fernando Ramirez

Fernando Ramirez

  • 212 Points 100 badge 2x thumb
any comment I will appreciate
Photo of Peter Hale

Peter Hale, Employee

  • 330 Points 250 badge 2x thumb
I upgraded my org to 11.1.4 and can now see the same issue you're having.  It seemed to be working in 11.0.1, so this may be a bug.