New Millau update breaks filter

  • 1
  • Problem
  • Updated 7 months ago
  • In Progress
I just installed the 11.1.1 release (and updated outdated themes to get the table filter buttons to realign properly), but now the toggle table filters that activate the model condition to only show today's activity isn't working.
Photo of Allison

Allison

  • 1,178 Points 1k badge 2x thumb

Posted 1 year ago

  • 1
Photo of Khamla Phimmachack

Khamla Phimmachack, Official Rep

  • 1,636 Points 1k badge 2x thumb
Hi Allison,

How are you activating the filter? What version of Skuid did you upgrade from?
Photo of Allison

Allison

  • 1,178 Points 1k badge 2x thumb
We were using Millau 11.0 and activating filter with basic toggle filter button
Photo of Khamla Phimmachack

Khamla Phimmachack, Official Rep

  • 1,636 Points 1k badge 2x thumb
Would you mind copying the XML of your filter condition and pasting it here? I'd like to try and reproduce the problem exactly how you have it set up.
Photo of Allison

Allison

  • 1,178 Points 1k badge 2x thumb
Photo of Allison

Allison

  • 1,178 Points 1k badge 2x thumb
Any updates on this??
Photo of Khamla Phimmachack

Khamla Phimmachack, Official Rep

  • 1,636 Points 1k badge 2x thumb
Hi Allison,

We confirmed that what you are seeing is actually a product issue. When you activate a condition that has Multiple Specified Values, those values are cleared and thus the condition does not work. We do not yet have an ETA for the fix, but once it is available. I will update you on this post. Thanks for bringing this to our attention.
Photo of Stephen Sells

Stephen Sells

  • 17,326 Points 10k badge 2x thumb
Official Response
Hello Skuid Community ~

This has been addressed in the new Millau 11.1.10 release and Brooklyn 10.0.23 which is now available on the Skuid Releases page.

As a reminder, Salesforce does NOT allow reverting back to prior versions of managed packages. Skuid always recommends installing new versions in a non-business critical sandbox environment to test all mission critical functionality before installing into a production environment. We also recommend that you update out of date themes when you upgrade.
(Edited)
Photo of Allison

Allison

  • 1,178 Points 1k badge 2x thumb
I installed the update and it's still not working.  It will refresh the model/table when unclicked/deactivated but won't refresh and reapply the "today" filter when clicked.  Please advise.
Photo of Khamla Phimmachack

Khamla Phimmachack, Official Rep

  • 1,636 Points 1k badge 2x thumb
Hi Allison,

I verified in our own environment that using a condition with multiple specified values no longer breaks the filter. Would you mind pasting the XML of your page here so that we can see how your page is setup? 
Photo of Allison

Allison

  • 1,178 Points 1k badge 2x thumb
The toggle off refreshes the table but then, when toggled back on, the table doesn't refresh.  If you manually refresh the page the filter works but not via the button.

Are you see that in the demo environment (specifically toggle off then back on again)?
Photo of Khamla Phimmachack

Khamla Phimmachack, Official Rep

  • 1,636 Points 1k badge 2x thumb
I created a simple page with a toggle filter similar to yours in my own sandbox and the filter works when I toggle off and on. If you could provide your page XML, we can see exactly how your page is setup and find out what's going on. 

In the Page Composer for your Skuid page, click View/Edit XML at the bottom right corner of the page (it's in fine print and easy to miss).
 

Then copy all of the markup and paste it here in the community post. 
Photo of Allison

Allison

  • 1,178 Points 1k badge 2x thumb
<skuidpage theme="BW" unsavedchangeswarning="yes">
    <models>
        <model id="Tasks" createrowifnonefound="false" query="true" limit="50" sobject="Task" orderby="ActivityDate ASC" datasource="salesforce">
            <fields>
                <field id="ActivityDate"/>
                <field id="CreatedDate"/>
                <field id="ReminderDateTime"/>
                <field id="Subject" overridemetadata="true" ogdisplaytype="COMBOBOX" displaytype="TEXTAREA" picklistsource="manual"/>
                <field id="Description"/>
                <field id="Status"/>
                <field id="WhoId"/>
                <field id="Who.Name"/>
                <field id="IsClosed"/>
                <field id="AccountId"/>
                <field id="Account.Name"/>
                <field id="WhatId"/>
                <field id="What.Name"/>
                <field id="Priority"/>
                <field id="OwnerId"/>
                <field id="Owner.Name"/>
                <field id="CreatedById"/>
                <field id="ScheduledByInitials__c"/>
                <field id="CreatedBy.FirstName"/>
                <field id="CreatedBy.LastName"/>
                <field id="ContactHousehold__r.CWID__c"/>
                <field id="NewField" uionly="true" displaytype="TEXT"/>
                <field id="ContactHousehold__r.Household__c"/>
            </fields>
            <conditions>
                <condition type="userinfo" value="" enclosevalueinquotes="true" field="OwnerId" operator="=" userinfotype="userid" inactive="false" state=""/>
                <condition type="fieldvalue" value="false" enclosevalueinquotes="false" field="IsClosed"/>
                <condition type="fieldvalue" value="Completed" enclosevalueinquotes="true" field="Status" operator="!="/>
                <condition type="fieldvalue" value="High" enclosevalueinquotes="true" field="Priority" operator="=" inactive="false" state=""/>
                <condition type="multiple" value="" enclosevalueinquotes="false" field="ActivityDate" operator="in" state="filterableoff" inactive="true" name="ActivityDate">
                    <values>
                        <value>TODAY</value>
                        <value>LAST_N_DAYS:1000</value>
                    </values>
                </condition>
                <condition type="fieldvalue" field="ActivityDate" operator="gte" inactive="true" enclosevalueinquotes="false" name="__autofilter__start__ActivityDate" state="filterableoff" value=""/>
                <condition type="fieldvalue" field="ActivityDate" operator="lte" inactive="true" enclosevalueinquotes="false" name="__autofilter__end__ActivityDate" state="filterableoff" value=""/>
                <condition type="multiple" value="" field="ActivityDate" state="filterableoff" inactive="true" name="ActivityDateisToday" operator="in" enclosevalueinquotes="false">
                    <values>
                        <value>TODAY</value>
                        <value>LAST_N_DAYS:10000</value>
                    </values>
                </condition>
                <condition type="fieldvalue" value="true" enclosevalueinquotes="false" field="IsRecurrence" operator="!=" state="" inactive="false"/>
            </conditions>
            <actions/>
        </model>
    </models>
    <pageregioncontents>
        <pageregioncontent uniqueid="sk-34Y0Rp-60" regionid="sk-2ZEFpZ-282">
            <components>
                <skootable uniqueid="sk-34ddAV-130" model="Tasks" mode="read" showsavecancel="false" createrecords="true" pagesize="10" showexportbuttons="false" searchbox="false" searchmethod="server" showconditions="true" emptysearchbehavior="query" buttonposition="" cssclass="tight-checkboxes" responsive="false" heading="High Priority Tasks">
                    <fields>
                        <field id="WhoId" uniqueid="fi-1EcK96-450" optionsource="" pagesize="5" columnwidth="25%" redirecttype="datasourcedefault">
                            <label>Contact</label>
                            <filters/>
                            <renderconditions logictype="and" onhidedatabehavior="keep"/>
                            <enableconditions/>
                        </field>
                        <field id="Subject" valuehalign="" type="" allowordering="true" uniqueid="fi-1EcK96-451" columnwidth="50%"/>
                        <field type="" id="ActivityDate" valuehalign="" allowordering="true" readonly="false" uniqueid="fi-1EcK96-452" columnwidth="8%">
                            <label>Due</label>
                        </field>
                        <field type="" id="Priority" valuehalign="" uniqueid="fi-1EcK96-453" columnwidth="8%"/>
                        <field id="ScheduledByInitials__c" hideable="true" uniqueid="fi-T-K3B-482">
                            <label>Set By</label>
                        </field>
                    </fields>
                    <rowactions>
                        <action type="popup" icon="sk-icon-search" label="View record details">
                            <popup width="80%" title="Viewing {{Model.label}}: {{Subject}}">
                                <components>
                                    <buttonset uniqueid="sk-HrTp3-1386" model="Tasks">
                                        <buttons>
                                            <button type="multi" label="Save" uniqueid="sk-HrT-G-1390">
                                                <actions>
                                                    <action type="save">
                                                        <models>
                                                            <model>Tasks</model>
                                                        </models>
                                                    </action>
                                                    <action type="closeTopmostPopup"/>
                                                </actions>
                                                <hotkeys>
                                                    <hotkey modifiers="ctrl" key="s"/>
                                                </hotkeys>
                                            </button>
                                            <button type="multi" label="Cancel" uniqueid="sk-HrU5G-1393">
                                                <actions>
                                                    <action type="cancel"/>
                                                    <action type="closeTopmostPopup"/>
                                                </actions>
                                            </button>
                                        </buttons>
                                    </buttonset>
                                    <grid uniqueid="sk-Hq0R8-1130">
                                        <divisions>
                                            <division behavior="flex" minwidth="100px" ratio="1">
                                                <components>
                                                    <basicfieldeditor showheader="true" showsavecancel="false" mode="read" model="Tasks" uniqueid="sk-HojVS-810" buttonposition="">
                                                        <conditions>
                                                            <condition type="contextrow" field="Id" mergefield="Id" autocreated="true"/>
                                                        </conditions>
                                                        <columns>
                                                            <column width="100%">
                                                                <sections>
                                                                    <section title="Section A" collapsible="no" showheader="false">
                                                                        <fields>
                                                                            <field id="Subject" uniqueid="sk-HojV3-789" valuehalign="" type=""/>
                                                                            <field id="ActivityDate" uniqueid="sk-HojUt-781"/>
                                                                            <field id="OwnerId" uniqueid="sk-HojVI-805" valuehalign="" type=""/>
                                                                            <field id="Priority" uniqueid="sk-HojVH-803" valuehalign="" type=""/>
                                                                            <field id="WhoId" uniqueid="sk-HojVA-795" valuehalign="" type=""/>
                                                                            <field id="ScheduledByInitials__c" uniqueid="sk-HojVN-809" valuehalign="" type=""/>
                                                                            <field id="CreatedDate" uniqueid="sk-HojUx-783" valuehalign="" type=""/>
                                                                        </fields>
                                                                    </section>
                                                                </sections>
                                                            </column>
                                                        </columns>
                                                    </basicfieldeditor>
                                                </components>
                                            </division>
                                            <division behavior="flex" verticalalign="top" minwidth="100px" ratio="1">
                                                <components>
                                                    <basicfieldeditor showheader="true" showsavecancel="false" showerrorsinline="true" model="Tasks" buttonposition="" uniqueid="sk-Hq2WA-1141" mode="edit" layout="above">
                                                        <columns>
                                                            <column width="100%">
                                                                <sections>
                                                                    <section title="Section A" collapsible="no" showheader="false">
                                                                        <fields>
                                                                            <field id="Description" uniqueid="sk-HojV5-791" valuehalign="" type=""/>
                                                                        </fields>
                                                                    </section>
                                                                </sections>
                                                            </column>
                                                        </columns>
                                                        <conditions>
                                                            <condition type="contextrow" field="Id" mergefield="Id" autocreated="true"/>
                                                        </conditions>
                                                        <renderconditions logictype="and"/>
                                                    </basicfieldeditor>
                                                </components>
                                            </division>
                                        </divisions>
                                        <styles>
                                            <styleitem type="background" bgtype="none"/>
                                        </styles>
                                    </grid>
                                </components>
                            </popup>
                        </action>
                        <action type="delete"/>
                        <action type="multi" label="Clear Task" icon="sk-icon-save">
                            <actions>
                                <action type="updateRow" fieldmodel="Tasks" field="Status" enclosevalueinquotes="true" value="Completed"/>
                                <action type="save">
                                    <models>
                                        <model>Tasks</model>
                                    </models>
                                </action>
                                <action type="requeryModel" model="Tasks" behavior="standard"/>
                            </actions>
                        </action>
                    </rowactions>
                    <massactions usefirstitemasdefault="true">
                        <action type="massupdate"/>
                        <action type="massdelete"/>
                    </massactions>
                    <views>
                        <view type="standard"/>
                        <view type="standard"/>
                    </views>
                    <filters>
                        <filter type="daterange" filteroffoptionlabel="New Filter" createfilteroffoption="true" affectcookies="true" autocompthreshold="25" conditionsource="auto" labelmode="no" startcondition="DateRangeBegin" endcondition="DateRangeEnd" conditionfield="ActivityDate" label="Select Dates"/>
                        <filter type="toggle" filteroffoptionlabel="" createfilteroffoption="true" affectcookies="true" autocompthreshold="25" conditionsource="manual" labelmode="auto" label="TODAY (w/ past)/ ALL DATES">
                            <effects>
                                <effect action="activate" value="" condition="ActivityDateisToday"/>
                            </effects>
                        </filter>
                    </filters>
                    <searchfields/>
                    <renderconditions logictype="and"/>
                </skootable>
            </components>
        </pageregioncontent>
    </pageregioncontents>
    <components/>
    <resources>
        <labels/>
        <css>
            <cssitem location="inline" name="tight-checkboxes" cachelocation="false">.tight-checkboxes nx-skootable-data input[type=checkbox] {margin: 0;}</cssitem>
        </css>
        <javascript/>
        <actionsequences uniqueid="sk-dcH1S-1034"/>
    </resources>
</skuidpage>
Photo of Khamla Phimmachack

Khamla Phimmachack, Official Rep

  • 1,636 Points 1k badge 2x thumb
Thanks for this Allison. I was not able to fully replicate your page using the XML because the fields on your Task model are specific to your environment. However, I was researching the condition in question "ActivityDateIsToday", and noticed that you have 3 values, Today, Last N days, and 10000. This seems to be a broad condition so I'd like to clarify. Can you tell me that state of the records before you use the toggle filter and what you expect to happen when you click this filter? Are you expecting it to filter only the tasks that are Due today? 
Photo of Allison

Allison

  • 1,178 Points 1k badge 2x thumb
Yes, the table by default shows all activities.  When the toggle is on, it shows only Today + all activities in the past.  The toggle works to activate the filter on the model, but doesn't refresh the table.  I have to refresh the entire page (which remembers the toggle filter value.
Photo of Khamla Phimmachack

Khamla Phimmachack, Official Rep

  • 1,636 Points 1k badge 2x thumb
Are you still having this problem Allison? I wasn't able to replicate the problem with refreshing. 
Photo of Allison

Allison

  • 1,178 Points 1k badge 2x thumb
Yes, still have the issue.  The page loads with the default set to "on", the toggle works fine when clicked to "off", but then the table doesn't refresh when it's clicked back to "on"