deck not showing related table

  • 1
  • Problem
  • Updated 11 months ago
  • In Progress
I have a deck with an object and a related object.  When I initially show a deck with the the records and related records the deck shows fine.  Once I requery the fields of related records no longer show.  The "Name", "Created Date" and "Search Number" are all in the related object.  If I hit f5 they all show again. 

https://drive.google.com/file/d/1hhjfDF5h4T28JvepPhrSMBU_bvjMrkOm/view
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb

Posted 11 months ago

  • 1
Photo of Stephen Sells

Stephen Sells, Official Rep

  • 16,856 Points 10k badge 2x thumb
What happens when you change the query to replace the data instead of Get More and Merge? It looks like the initial page load is what you want to replicate and the get more query isn't doing your desired behavior.
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb
I have removed all conditions and the query on popup close.  So nothing should have changed..https://drive.google.com/file/d/17xulHH0XVOHNgCAw0nw8OdvnEf4dmaaA/view
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb
I removed the edit button and popup and rebuild the edit button and popup and it now works.  However, If I add query after close the same problem happens
(Edited)
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb
There is an issue when adding query on the "After Close Action".  It is not working.
Photo of Bill McCullough

Bill McCullough, Champion

  • 12,436 Points 10k badge 2x thumb
Bill,

I tried replicating what you are seeing with the deck.  I am not sure that I have the same setup as you do.  I did not see any problems in my developer org in Skuid 11.

What version of Skuid are you using?  Can you try this page in your org?

Thanks,

Bill

<skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="true" useviewportmeta="true" showheader="true">
    <models>
        <model id="Opps" limit="20" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Opportunity">
            <fields>
                <field id="AccountId"/>
                <field id="Account.Name"/>
                <field id="Amount"/>
                <field id="CloseDate"/>
                <field id="Name"/>
                <field id="Account.Phone"/>
                <field id="Account.Rating"/>
                <field id="Id"/>
            </fields>
            <conditions/>
            <actions/>
        </model>
        <model id="CurrentOpp" limit="1" query="false" createrowifnonefound="false" datasource="salesforce" type="" sobject="Opportunity">
            <fields>
                <field id="Amount"/>
                <field id="CloseDate"/>
                <field id="Name"/>
            </fields>
            <conditions>
                <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="Id" operator="=" state="filterableoff" inactive="true" name="CurrOppId"/>
            </conditions>
            <actions/>
        </model>
    </models>
    <components>
        <buttonset model="Opps" uniqueid="sk-1QFfk_-281" position="left">
            <buttons>
                <button type="multi" label="Refresh" uniqueid="sk-1QFgIW-286" icon="sk-icon-refresh">
                    <actions>
                        <action type="requeryModel" model="Opps" behavior="standard">
                            <onerroractions>
                                <action type="blockUI" message="There was an error" timeout="3000"/>
                            </onerroractions>
                        </action>
                    </actions>
                </button>
            </buttons>
        </buttonset>
        <deck searchmethod="server" searchbox="true" columngutter=".75em" rowgutter=".75em" model="Opps" filtersposition="top" filterswidth="150px" showsavecancel="false" behavior="flex" verticalalign="top" ratio="1" minwidth="350px" uniqueid="sk-1QFeWi-265" buttonposition="" pagesize="10">
            <components>
                <wrapper uniqueid="sk-1QFqJI-335">
                    <components>
                        <richtext multiple="false" uniqueid="sk-1QG1zz-452">
                            <contents>&lt;p style="text-align: center;"&gt;&lt;span style="font-size:16px;"&gt;{{Account.Name}}&lt;/span&gt;&lt;/p&gt;
</contents>
                        </richtext>
                        <richtext multiple="false" uniqueid="sk-1QG93M-483">
                            <contents>&lt;p style="text-align: center;"&gt;&lt;span style="font-size:16px;"&gt;{{Account.Phone}}&lt;/span&gt;&lt;/p&gt;
</contents>
                        </richtext>
                        <basicfieldeditor showheader="true" showsavecancel="false" showerrorsinline="true" model="Opps" buttonposition="" uniqueid="sk-1QFran-348" mode="read">
                            <columns>
                                <column width="100%">
                                    <sections>
                                        <section title="Opportunity Fields" collapsible="no">
                                            <fields>
                                                <field uniqueid="sk-1QFy6J-437" id="Name"/>
                                                <field uniqueid="sk-1QFy6J-438" id="Amount" decimalplaces="" valuehalign="" type=""/>
                                                <field uniqueid="sk-1QFy6K-439" id="CloseDate"/>
                                            </fields>
                                        </section>
                                    </sections>
                                </column>
                            </columns>
                        </basicfieldeditor>
                    </components>
                    <styles>
                        <styleitem type="background"/>
                        <styleitem type="border"/>
                        <styleitem type="size"/>
                    </styles>
                </wrapper>
            </components>
            <massactions/>
            <interactions>
                <interaction type="tap" direction="either">
                    <action type="showPopup">
                        <models/>
                        <popup title="{{Model.label}}: {{Name}}" width="80%">
                            <components>
                                <basicfieldeditor showheader="true" showsavecancel="true" showerrorsinline="true" model="Opps" buttonposition="" uniqueid="sk-1QIVwn-1009" mode="edit">
                                    <columns>
                                        <column width="100%">
                                            <sections>
                                                <section title="Opportunity Fields" collapsible="no">
                                                    <fields>
                                                        <field uniqueid="sk-1QIYuV-1037" id="Name" valuehalign="" type=""/>
                                                        <field uniqueid="sk-1QIYuV-1036" id="Amount" decimalplaces="" valuehalign="" type=""/>
                                                        <field uniqueid="sk-1QIYuU-1035" id="CloseDate"/>
                                                    </fields>
                                                </section>
                                            </sections>
                                        </column>
                                    </columns>
                                    <conditions>
                                        <condition type="contextrow" field="Id" mergefield="Id"/>
                                    </conditions>
                                </basicfieldeditor>
                            </components>
                            <afterclose>
                                <action type="requeryModel" model="Opps" behavior="standard">
                                    <onerroractions/>
                                </action>
                            </afterclose>
                        </popup>
                    </action>
                </interaction>
            </interactions>
            <actions/>
            <styles>
                <styleitem type="border"/>
            </styles>
        </deck>
    </components>
    <resources>
        <labels/>
        <javascript/>
        <css/>
        <actionsequences uniqueid="sk-1QFTZV-228"/>
    </resources>
    <styles>
        <styleitem type="background" bgtype="none"/>
    </styles>
</skuidpage>
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb
Unfortunately I was not to try as I do not use SF CRM fields only custom objects.
Photo of Bill McCullough

Bill McCullough, Champion

  • 12,436 Points 10k badge 2x thumb
Bill,

Try this page...it is based on Contacts.

<skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="true" useviewportmeta="true" showheader="true">
    <models>
        <model id="Cons" limit="20" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Contact">
            <fields>
                <field id="AccountId"/>
                <field id="Account.Name"/>
                <field id="Name"/>
                <field id="Phone"/>
                <field id="Id"/>
                <field id="Account.Phone"/>
            </fields>
            <conditions/>
            <actions/>
        </model>
        <model id="CurrentCon" limit="1" query="false" createrowifnonefound="false" datasource="salesforce" type="" sobject="Contact">
            <fields>
                <field id="Phone"/>
                <field id="Name"/>
            </fields>
            <conditions>
                <condition type="fieldvalue" value="" enclosevalueinquotes="true" field="Id" operator="=" state="filterableoff" inactive="true" name="CurrConId"/>
            </conditions>
            <actions/>
        </model>
    </models>
    <components>
        <buttonset model="Cons" uniqueid="sk-1QFfk_-281" position="left">
            <buttons>
                <button type="multi" label="Refresh" uniqueid="sk-1QFgIW-286" icon="sk-icon-refresh">
                    <actions>
                        <action type="blockUI" message="Requerying"/>
                        <action type="requeryModel" model="Cons" behavior="standard">
                            <onerroractions>
                                <action type="blockUI" message="There was an error" timeout="3000"/>
                            </onerroractions>
                        </action>
                        <action type="unblockUI"/>
                    </actions>
                </button>
            </buttons>
        </buttonset>
        <deck searchmethod="server" searchbox="true" columngutter=".75em" rowgutter=".75em" model="Cons" filtersposition="top" filterswidth="150px" showsavecancel="false" behavior="flex" verticalalign="top" ratio="1" minwidth="350px" uniqueid="sk-1QFeWi-265" buttonposition="" pagesize="10">
            <components>
                <wrapper uniqueid="sk-1QFqJI-335">
                    <components>
                        <richtext multiple="false" uniqueid="sk-1QG1zz-452">
                            <contents>&lt;p style="text-align: center;"&gt;&lt;span style="font-size:16px;"&gt;{{Account.Name}}&lt;/span&gt;&lt;/p&gt;
</contents>
                        </richtext>
                        <richtext multiple="false" uniqueid="sk-1QG93M-483">
                            <contents>&lt;p style="text-align: center;"&gt;&lt;span style="font-size:16px;"&gt;{{Account.Phone}}&lt;/span&gt;&lt;/p&gt;
</contents>
                        </richtext>
                        <basicfieldeditor showheader="true" showsavecancel="false" showerrorsinline="true" model="Cons" buttonposition="" uniqueid="sk-1QFran-348" mode="read">
                            <columns>
                                <column width="100%">
                                    <sections>
                                        <section title="Contact Fields" collapsible="no">
                                            <fields>
                                                <field uniqueid="sk-1QFy6J-437" id="Name"/>
                                                <field uniqueid="sk-1QFy6K-439" id="Phone"/>
                                            </fields>
                                        </section>
                                    </sections>
                                </column>
                            </columns>
                        </basicfieldeditor>
                    </components>
                    <styles>
                        <styleitem type="background"/>
                        <styleitem type="border"/>
                        <styleitem type="size"/>
                    </styles>
                </wrapper>
            </components>
            <massactions/>
            <interactions>
                <interaction type="tap" direction="either">
                    <action type="showPopup">
                        <models/>
                        <popup title="{{Model.label}}: {{Name}}" width="80%">
                            <components>
                                <basicfieldeditor showheader="true" showsavecancel="true" showerrorsinline="true" model="Cons" buttonposition="" uniqueid="sk-1QIVwn-1009" mode="edit">
                                    <columns>
                                        <column width="100%">
                                            <sections>
                                                <section title="Contact Fields" collapsible="no">
                                                    <fields>
                                                        <field uniqueid="sk-1QIYuV-1037" id="Name" valuehalign="" type=""/>
                                                        <field uniqueid="sk-1QIYuU-1035" id="Phone"/>
                                                    </fields>
                                                </section>
                                            </sections>
                                        </column>
                                    </columns>
                                    <conditions>
                                        <condition type="contextrow" field="Id" mergefield="Id"/>
                                    </conditions>
                                </basicfieldeditor>
                            </components>
                            <afterclose>
                                <action type="requeryModel" model="Cons" behavior="standard">
                                    <onerroractions/>
                                </action>
                            </afterclose>
                        </popup>
                    </action>
                </interaction>
            </interactions>
            <actions/>
            <styles>
                <styleitem type="border"/>
            </styles>
        </deck>
    </components>
    <resources>
        <labels/>
        <javascript/>
        <css/>
        <actionsequences uniqueid="sk-1QFTZV-228"/>
    </resources>
    <styles>
        <styleitem type="background" bgtype="none"/>
    </styles>
</skuidpage>