Is there a declarative way to load all records for a model?

  • 1
  • Question
  • Updated 1 month ago
  • Answered
Many of us have probably run into a scenario where you need to load all records for a model, and have used the good ol' loadAllRemainingRecords js. 

Now there's a declarative way to load all remaining records as well. There's two parts to the solution

  • A model condition that only pulls in new values (Id not in (ThisModel)(Id)
  • An action sequence that loops and merge queries until ThisModel can't retrieve more rows
Here's the XML for an example that'll load all accounts in your org

<skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="true" useviewportmeta="true" showheader="true">
    <models>
        <model id="Accounts" limit="5" query="true" createrowifnonefound="false" datasource="salesforce" sobject="Account">
            <fields>
                <field id="Id"/>
                <field id="Name"/>
                <field id="OwnerId"/>
                <field id="Owner.Name"/>
            </fields>
            <conditions>
                <condition type="modelmerge" value="" field="Id" operator="not in" model="Accounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/>
            </conditions>
            <actions/>
        </model>
        <model id="AccountsCount" query="true" createrowifnonefound="false" datasource="salesforce" sobject="Account">
            <fields>
                <field id="Id"/>
                <field id="Name"/>
                <field id="OwnerId"/>
                <field id="Owner.Name"/>
            </fields>
            <conditions/>
            <actions/>
            <groupby method="simple"/>
        </model>
    </models>
    <components>
        <grid uniqueid="sk-3RwW-1192" columngutter="50px">
            <divisions>
                <division behavior="flex" minwidth="100px" ratio="1">
                    <components>
                        <pagetitle model="Accounts" uniqueid="sk-3Rx8-1694">
                            <maintitle>Only loading 5 accounts at a time cuz apex doesn't like you</maintitle>
                            <actions>
                                <action type="multi" label="Load All Remaining Records" uniqueid="sk-3RxB-1721">
                                    <actions>
                                        <action type="blockUI"/>
                                        <action type="action-sequence" action-sequence-id="c4e8e325-a3fa-446e-9b82-d729f524307d"/>
                                    </actions>
                                </action>
                            </actions>
                        </pagetitle>
                        <skootable showconditions="true" showsavecancel="true" showerrorsinline="true" searchmethod="server" searchbox="true" showexportbuttons="false" hideheader="false" hidefooter="false" pagesize="10" alwaysresetpagination="false" createrecords="true" model="Accounts" buttonposition="" mode="read" allowcolumnreordering="true" responsive="true" uniqueid="sk-3Rue-284">
                            <fields>
                                <field id="Id" uniqueid="fi-3Rue-285"/>
                                <field id="Name" uniqueid="fi-3Rue-286"/>
                                <field id="OwnerId" uniqueid="fi-3Rue-287"/>
                                <field id="Owner.Name" uniqueid="fi-3Rue-288"/>
                            </fields>
                            <rowactions>
                                <action type="edit"/>
                                <action type="delete"/>
                            </rowactions>
                            <massactions usefirstitemasdefault="true">
                                <action type="massupdate"/>
                                <action type="massdelete"/>
                            </massactions>
                            <views>
                                <view type="standard"/>
                            </views>
                            <actions defaultlabel="Global Actions" defaulticon="sk-icon-magic" usefirstitemasdefault="true"/>
                        </skootable>
                    </components>
                </division>
                <division behavior="flex" verticalalign="top" minwidth="100px" ratio="1">
                    <components>
                        <pagetitle model="Accounts" uniqueid="sk-3Rx9-1701">
                            <maintitle>(Here's what you want as the end result)</maintitle>
                            <actions/>
                        </pagetitle>
                        <skootable showconditions="true" showsavecancel="true" showerrorsinline="true" searchmethod="server" searchbox="true" showexportbuttons="false" hideheader="false" hidefooter="false" pagesize="10" alwaysresetpagination="false" createrecords="true" model="AccountsCount" buttonposition="" mode="read" allowcolumnreordering="true" responsive="true" uniqueid="sk-3RwO-1096">
                            <fields>
                                <field id="Id" uniqueid="fi-3RwO-1097"/>
                                <field id="Name" uniqueid="fi-3RwO-1098"/>
                                <field id="OwnerId" uniqueid="fi-3RwO-1099"/>
                                <field id="Owner.Name" uniqueid="fi-3RwO-1100"/>
                            </fields>
                            <rowactions>
                                <action type="edit"/>
                                <action type="delete"/>
                            </rowactions>
                            <massactions usefirstitemasdefault="true">
                                <action type="massupdate"/>
                                <action type="massdelete"/>
                            </massactions>
                            <views>
                                <view type="standard"/>
                            </views>
                        </skootable>
                    </components>
                </division>
            </divisions>
            <styles>
                <styleitem type="background" bgtype="none"/>
            </styles>
        </grid>
    </components>
    <resources>
        <labels/>
        <javascript/>
        <css/>
        <actionsequences uniqueid="sk-3RuX-221">
            <actionsequence id="c4e8e325-a3fa-446e-9b82-d729f524307d" label="LoadAllReamingRecords_Accounts" type="reusable" uniqueid="sk-3RvX-694">
                <description/>
                <actions>
                    <action type="branch" whenfinished="stop">
                        <formula>{{$Model.Accounts.canRetrieveMoreRows}}==true</formula>
                        <iftrueactions>
                            <action type="requeryModel" model="Accounts" behavior="loadmore"/>
                            <action type="action-sequence" action-sequence-id="c4e8e325-a3fa-446e-9b82-d729f524307d"/>
                        </iftrueactions>
                    </action>
                    <action type="blockUI" message="I loaded all your accounts" timeout="3000"/>
                </actions>
            </actionsequence>
        </actionsequences>
    </resources>
    <styles>
        <styleitem type="background" bgtype="none"/>
    </styles>
</skuidpage>

Photo of Matt Davis

Matt Davis, Employee

  • 734 Points 500 badge 2x thumb

Posted 1 month ago

  • 1
Photo of Stephen Sells

Stephen Sells, Official Rep

  • 17,210 Points 10k badge 2x thumb
Thanks for posting this! Very helpful.
Photo of Matt Davis

Matt Davis, Employee

  • 734 Points 500 badge 2x thumb
Also, the above example is for a dev org size sample. Here's an example that'll pull 100 at a time instead of 5....

<skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="true" useviewportmeta="true" showheader="true">
<models>
<model id="Accounts" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" sobject="Account">
<fields>
<field id="Id"/>
<field id="Name"/>
<field id="OwnerId"/>
<field id="Owner.Name"/>
</fields>
<conditions>
<condition type="modelmerge" value="" field="Id" operator="not in" model="Accounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/>
</conditions>
<actions/>
</model>
<model id="AccountsCount" query="true" createrowifnonefound="false" datasource="salesforce" sobject="Account" type="aggregate">
<fields>
<field id="Id" name="countId" function="COUNT"/>
</fields>
<conditions/>
<actions/>
<groupby method="simple"/>
</model>
</models>
<components>
<grid uniqueid="sk-3RwW-1192" columngutter="50px">
<divisions>
<division behavior="flex" minwidth="100px" ratio="1">
<components>
<pagetitle model="Accounts" uniqueid="sk-3Rx8-1694">
<maintitle>Only loading 100 accounts at a time cuz apex doesn't like you</maintitle>
<actions>
<action type="multi" label="Load All Remaining Records" uniqueid="sk-3RxB-1721">
<actions>
<action type="blockUI"/>
<action type="action-sequence" action-sequence-id="c4e8e325-a3fa-446e-9b82-d729f524307d"/>
</actions>
</action>
</actions>
</pagetitle>
<skootable showconditions="true" showsavecancel="true" showerrorsinline="true" searchmethod="server" searchbox="true" showexportbuttons="false" hideheader="false" hidefooter="false" pagesize="10" alwaysresetpagination="false" createrecords="true" model="Accounts" buttonposition="" mode="read" allowcolumnreordering="true" responsive="true" uniqueid="sk-3Rue-284">
<fields>
<field id="Id" uniqueid="fi-3Rue-285"/>
<field id="Name" uniqueid="fi-3Rue-286"/>
<field id="OwnerId" uniqueid="fi-3Rue-287"/>
<field id="Owner.Name" uniqueid="fi-3Rue-288"/>
</fields>
<rowactions>
<action type="edit"/>
<action type="delete"/>
</rowactions>
<massactions usefirstitemasdefault="true">
<action type="massupdate"/>
<action type="massdelete"/>
</massactions>
<views>
<view type="standard"/>
</views>
<actions defaultlabel="Global Actions" defaulticon="sk-icon-magic" usefirstitemasdefault="true"/>
</skootable>
</components>
</division>
<division behavior="flex" verticalalign="top" minwidth="100px" ratio="1">
<components>
<pagetitle model="Accounts" uniqueid="sk-3Rx9-1701">
<maintitle>(Here's what you want as the end result)</maintitle>
<actions/>
</pagetitle>
<skootable showconditions="true" showsavecancel="false" showerrorsinline="true" searchmethod="server" searchbox="true" showexportbuttons="false" hideheader="false" hidefooter="false" pagesize="10" alwaysresetpagination="false" createrecords="false" model="AccountsCount" buttonposition="" mode="readonly" allowcolumnreordering="true" responsive="true" uniqueid="sk-3gXD-360">
<fields>
<field id="Id" name="countId" uniqueid="fi-3gXD-361"/>
</fields>
<rowactions/>
<massactions usefirstitemasdefault="true"/>
<views>
<view type="standard"/>
</views>
</skootable>
</components>
</division>
</divisions>
<styles>
<styleitem type="background" bgtype="none"/>
</styles>
</grid>
</components>
<resources>
<labels/>
<javascript/>
<css/>
<actionsequences uniqueid="sk-3RuX-221">
<actionsequence id="c4e8e325-a3fa-446e-9b82-d729f524307d" label="LoadAllReamingRecords_Accounts" type="reusable" uniqueid="sk-3RvX-694">
<description/>
<actions>
<action type="branch" whenfinished="stop">
<formula>{{$Model.Accounts.canRetrieveMoreRows}}==true</formula>
<iftrueactions>
<action type="requeryModel" model="Accounts" behavior="loadmore"/>
<action type="action-sequence" action-sequence-id="c4e8e325-a3fa-446e-9b82-d729f524307d"/>
</iftrueactions>
</action>
<action type="blockUI" message="I loaded all your accounts" timeout="3000"/>
</actions>
</actionsequence>
</actionsequences>
</resources>
<styles>
<styleitem type="background" bgtype="none"/>
</styles>
</skuidpage>

Photo of Bill McCullough

Bill McCullough, Champion

  • 12,758 Points 10k badge 2x thumb
Nice!  Thanks for posting.