Skip to main content

anyone have any Ideas on how I would pull this off. I want to load in the most recent 5 records into a deck component, but I want them ordered in Oldest to Newest so that the newest record is at the bottom of the list. So I need to limit the record load of the model to 5, then choose to sort the model by CreatedDate DESC to get the most recent 5 records. 
THEN I NEED TO REORDER THE DECK SO THAT THE MOST RECENT RECORD APPEARS AT THE BOTTOM INSTEAD OF THE TOP.
Any ideas?

Can do with javascript for sure.


Raymond,


If you are using Skuid Millau (11), you can sort using the Action Framework. Just execute the sort on the event ‘Skuid Page: Rendered’. Here is a sample that gets the 5 most recently created Tasks and sorts them in Ascending order.


Thanks,


Bill


<skuidpage personalizationmode="server" useviewportmeta="true" showsidebar="true" showheader="true">
<models>
<model id="TaskDeck" limit="5" query="true" createrowifnonefound="false" datasource="salesforce" sobject="Task" orderby="CreatedDate DESC">
<fields>
<field id="Subject"/>
<field id="CreatedDate"/>
</fields>
<conditions/>
<actions/>
</model>
</models>
<components>
<grid uniqueid="sk-sHX-419">
<divisions>
<division behavior="flex" minwidth="100px" ratio="1" verticalalign="top">
<components>
<deck searchmethod="server" searchbox="true" columngutter=".75em" rowgutter=".75em" model="TaskDeck" filtersposition="top" filterswidth="150px" showsavecancel="false" behavior="flex" verticalalign="top" ratio="1" minwidth="350px" hideheader="false" hidefooter="false" uniqueid="sk-sHX-399" pagesize="5">
<components>
<basicfieldeditor showheader="true" showsavecancel="false" showerrorsinline="true" model="TaskDeck" uniqueid="sk-sHX-478" mode="read">
<columns>
<column width="100%">
<sections>
<section title="{{Subject}}" collapsible="no">
<fields>
<field uniqueid="sk-sHX-570" id="CreatedDate"/>
</fields>
</section>
</sections>
</column>
</columns>
</basicfieldeditor>
</components>
<massactions/>
<interactions/>
<actions/>
<styles>
<styleitem type="border"/>
</styles>
</deck>
</components>
</division>
<division behavior="flex" verticalalign="top" minwidth="100px" ratio="1">
<components/>
</division>
<division behavior="flex" verticalalign="top" minwidth="100px" ratio="1">
<components/>
</division>
</divisions>
<styles>
<styleitem type="background" bgtype="none"/>
</styles>
</grid>
</components>
<resources>
<labels/>
<javascript/>
<css/>
<actionsequences uniqueid="sk-sHX-269">
<actionsequence id="ce44ecdb-aa16-4d35-bd11-04fb7bfd7763" label="ResortDeck" type="event-triggered" event-scope="component" event-name="page.rendered">
<description/>
<actions>
<action type="sortModel" client-side="true" model="TaskDeck" method="asc" field="CreatedDate"/>
</actions>
</actionsequence>
</actionsequences>
</resources>
<styles>
<styleitem type="background" bgtype="none"/>
</styles>
</skuidpage>

Nice!

How long have we had this “Sort” action ?


Wow!!! This is cool. Thanks Bill. I haven’t had a chance to check it out, but this is awesome.


It works! Thanks BIll. I just can’t get it to work as a model action with trigger of model requery. Throws an error. Trying to get it so that when someone clicks “Load more” that it will reset the order.