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
https://drive.google.com/file/d/1hhjfDF5h4T28JvepPhrSMBU_bvjMrkOm/view
-
8,044 Points
Posted 1 year ago
Stephen Sells, Official Rep
-
17,316 Points
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.
-
8,044 Points
I have removed all conditions and the query on popup close. So nothing should have changed..https://drive.google.com/file/d/17xulHH0XVOHNgCAw0nw8OdvnEf4dmaaA/view
-
8,044 Points
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)
-
8,044 Points
There is an issue when adding query on the "After Close Action". It is not working.
Bill McCullough, Champion
-
13,008 Points
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><p style="text-align: center;"><span style="font-size:16px;">{{Account.Name}}</span></p>
</contents>
</richtext>
<richtext multiple="false" uniqueid="sk-1QG93M-483">
<contents><p style="text-align: center;"><span style="font-size:16px;">{{Account.Phone}}</span></p>
</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>
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><p style="text-align: center;"><span style="font-size:16px;">{{Account.Name}}</span></p>
</contents>
</richtext>
<richtext multiple="false" uniqueid="sk-1QG93M-483">
<contents><p style="text-align: center;"><span style="font-size:16px;">{{Account.Phone}}</span></p>
</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>
-
8,044 Points
Unfortunately I was not to try as I do not use SF CRM fields only custom objects.
Bill McCullough, Champion
-
13,008 Points
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><p style="text-align: center;"><span style="font-size:16px;">{{Account.Name}}</span></p>
</contents>
</richtext>
<richtext multiple="false" uniqueid="sk-1QG93M-483">
<contents><p style="text-align: center;"><span style="font-size:16px;">{{Account.Phone}}</span></p>
</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>
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><p style="text-align: center;"><span style="font-size:16px;">{{Account.Name}}</span></p>
</contents>
</richtext>
<richtext multiple="false" uniqueid="sk-1QG93M-483">
<contents><p style="text-align: center;"><span style="font-size:16px;">{{Account.Phone}}</span></p>
</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>
Related Categories
-
Skuid on Salesforce
- 2279 Conversations
- 181 Followers