Defect/Issue Description:
A description of the bug
Environment:
Release: Edinburgh
Release version: 16.1.6)
Platform: Salesforce
Brief Summary of the Defect/Issue:
filter set dropdown picklist is not populating if a model has aggregate and a model “Query on page load” is not checked
Mark_L
July 14, 2023, 2:32pm
2
Not that it’s a true solution to what should just inherently work by itself, but you should be able to run a separate aggregate model/query before this one that returns just the picklist options you’re looking to filter on, 1 per row, and then for your filter select “Pick options and conditions: Manually”, set up a filterable condition on the model to use, and for the filter selectable options select rows from a model and pick the separate aggregate model you set up to use. I’ve done this in a lot of places and it works well, albeit having to go about setting this up in a roundabout way to get it to work.
Hey @rinovejas thanks for reporting. Can you share some more context here?
You have a table on an aggregate model, and you have a filter set on that same model. Correct?
The model isn’t queried on page load. Is it queried later?
I quickly tried to reproduce on 16.1.6 and wasn’t able. Here’s the page I’m using if you want to take a look and make it more like what you’re doing. I have the model queried on a button.
<skuid__page unsavedchangeswarning="yes" personalizationmode="server" showsidebar="false" showheader="false">
<models>
<model id="NewModelAgg" limit="" query="false" createrowifnonefound="false" datasource="salesforce" sobject="Opportunity" type="aggregate">
<fields>
<field id="Id" name="countId" function="COUNT"/>
<field id="Amount" name="avgAmount" function="AVG"/>
</fields>
<conditions>
<condition type="fieldvalue" field="StageName" operator="=" inactive="true" enclosevalueinquotes="true" name="__autofilter__StageName" clientorserver="server" state="filterableoff" value=""/>
</conditions>
<actions/>
<groupby method="simple">
<field id="StageName" name="stageName"/>
</groupby>
</model>
</models>
<components>
<skuid__buttonSet model="NewModelAgg" uniqueid="sk-1kLi-27104">
<groups>
<skuid__buttonGroup uniqueId="sk-1kLi-27102">
<buttons>
<skuid__button label="Query model" uniqueId="sk-1kLi-27103">
<actions>
<action type="action-sequence" action-sequence-id="bd87fe9c-c69a-4482-b46b-c29e957ceb87"/>
</actions>
</skuid__button>
</buttons>
</skuid__buttonGroup>
</groups>
</skuid__buttonSet>
<skuid__filterSet model="NewModelAgg" uniqueid="sk-1kKW-20202">
<filters>
<skuid__filter uniqueId="sk-1kKX-20672" type="select" conditionSource="auto" filterMethod="server" labelMode="no" conditionField="StageName" conditionName="__autofilter__StageName"/>
</filters>
<filtering enableSearch="false" instantSearch="false" instantFilters="true"/>
<sorting enable="false"/>
</skuid__filterSet>
<skuid__table allowColumnFreezing="dragDrop" model="NewModelAgg" uniqueid="sk-1kKP-17269" mode="readonly" showSaveCancel="false">
<fields>
<field id="Id" name="countId" label="Count id" uniqueid="fi-1kKP-17829"/>
<field id="Amount" name="avgAmount" label="Avg amount" horizontalAlignment="right"/>
<field id="StageName" name="stageName" label="Stage name" uniqueid="fi-1kKP-17830"/>
</fields>
<filtering enableSearch="false"/>
<actions/>
<rowActions/>
<massActions/>
<exportProperties useTableColumns="true"/>
<sorting enable="false"/>
<filters>
<skuid__filter uniqueId="sk-1kKT-18744" type="select" conditionSource="auto" filterMethod="server" labelMode="no" conditionField="StageName" conditionName="__autofilter__StageName"/>
</filters>
</skuid__table>
</components>
<resources>
<labels/>
<javascript/>
<actionsequences>
<actionsequence id="bd87fe9c-c69a-4482-b46b-c29e957ceb87" label="Query model" type="reusable" event-scope="component" event-name="page.rendered">
<description/>
<actions>
<action type="requeryModels" behavior="standard">
<models>
<model>NewModelAgg</model>
</models>
</action>
</actions>
</actionsequence>
</actionsequences>
</resources>
<background/>
<interactions/>
<surfaces/>
</skuid__page>
@Anna_Wiersema our skuid version is 16.1.4 and it’s not working,I tried it on 16.1.6 and it works, so we just need to upgrade our production instance.
1 Like
This topic was automatically closed after 22 days. New replies are no longer allowed.