Chart w/ Filter Set Failing when Model Returns no Rows

Pat VachonPat Vachon 💎💎💎
edited June 25, 2020 in Questions



Comments

  • Pat VachonPat Vachon 💎💎💎
    edited June 25, 2020
    The issue is with having a snippet as well. Removing the snippet removes the issue.

    The snippet doesn't run when the series model doesn't have any data/points.
  • edited June 25, 2020
    I'm glad you solved it before I finished building my test page. You're the man Pat.
  • Pat VachonPat Vachon 💎💎💎
    edited September 8, 2017
    This isn't solved. Just further clarified. I need to use snippets.
  • edited September 8, 2017
    The current problem seems to be a chart associated with an aggregate model. LAST_N_DAYS are working on the filter but NEXT_N_YEARS is not working. If you try and have the next run by the filter set, it'll constantly be "Applying" but never actually apply. Is that right? What is the snippet doing? I don't know how to incorporate that
  • edited September 8, 2017
    Can you share the XML of the model?
  • Pat VachonPat Vachon 💎💎💎
    edited September 10, 2017
    Here you go. You'll have to add some custom fields and one object. Not too many though.

    <skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="false" useviewportmeta="true" showheader="false" theme="Lightning Design"> <models> <model id="UIOnly" query="true" createrowifnonefound="true" datasource="Ui-Only" processonclient="true" unloadwarningifunsavedchanges="false"> <fields> <field id="ADPLastNValue" displaytype="TEXT" ogdisplaytype="TEXT" readonly="false" returntype="DOUBLE" precision="9" scale="0" defaultvaluetype="fieldvalue" label="ADPLastNValue"/> <field id="ADPLastNLabel" displaytype="TEXT" label="ADPLastNLabel"/> <field id="DPLastNValue" displaytype="TEXT" label="DPLastNValue" ogdisplaytype="TEXT" precision="9" scale="0"/> <field id="DPLastNLabel" displaytype="TEXT" label="DPLastNLabel"/> </fields> <conditions/> <actions/> </model> <model id="FacilitiesRecordType" limit="1" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="RecordType"> <fields> <field id="Id"/> <field id="IsActive"/> <field id="Description"/> </fields> <conditions> <condition type="fieldvalue" value="Account" enclosevalueinquotes="true" field="SobjectType"/> <condition type="fieldvalue" value="Facilities" enclosevalueinquotes="true" field="Name" operator="="/> </conditions> <actions/> </model> <model id="AllAccounts" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account" doclone="" queryallrows="true"> <fields> <field id="Id"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="RecordTypeId" fieldtargetobjects="RecordType" operator="=" model="FacilitiesRecordType" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate" state="" inactive="false"/> <condition type="multiple" field="Sales_Region__c" operator="in" inactive="true" enclosevalueinquotes="true" name="__autofilter__Sales_Region__c" state="filterableoff" value=""/> <condition type="fieldvalue" value="On-boarding" enclosevalueinquotes="true" field="Dental_Marketing_Status__c" operator="=" state="off" inactive="true"/> <condition type="multiple" value="" field="Type" operator="in" enclosevalueinquotes="true" state="filterableoff" inactive="true" name="Type"> <values/> </condition> </conditions> <actions> <action> <actions> <action type="blockUI"/> <action type="requeryModels" behavior="standard"> <models> <model>AllAccountsAgg</model> <model>AllAccountsAggByStatusActive</model> <model>AllAccountsAggByStatusInactive</model> <model>AllAccountsAggByStatusDeclined</model> <model>AllAccountsAggByStatusProspect</model> <model>Dental_Accounts</model> <model>Dental_Accounts_OB</model> <model>Dental_Accounts_CR</model> <model>Dental_Accounts_20</model> <model>Dental_Accounts_30</model> <model>Dental_Accounts_40</model> <model>Dental_Accounts_50</model> <model>DentalActiveSummary</model> <model>ActiveDentalPatients</model> <model>ActiveDentalProspects</model> </models> <onerroractions> <action type="blockUI" message="There was an error with query" timeout="3000"/> </onerroractions> </action> <action type="custom" snippet="calcLastValsLabels"> <onerroractions> <action type="blockUI" message="There was an error in calcLastValsLabels snippet" timeout="3000"/> </onerroractions> </action> <action type="unblockUI"/> </actions> <events> <event>models.loaded</event> </events> </action> </actions> <groupby method="simple"/> </model> <model id="AllAccountsAgg" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Account"> <fields> <field id="Id" name="FacilityCount" function="COUNT"/> <field id="Bed_Count__c" name="BedCount" function="SUM"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" operator="in" model="AllAccounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> </conditions> <actions> <action> <actions/> <events> <event>models.loaded</event> </events> </action> </actions> <groupby method="simple"/> </model> <model id="AllAccountsAggByStatusActive" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Account"> <fields> <field id="Id" name="FacilityCount" function="COUNT"/> <field id="Bed_Count__c" name="BedCount" function="SUM"/> <field id="FacilityPercent" uionly="true" displaytype="FORMULA" ogdisplaytype="TEXT" readonly="true" returntype="DOUBLE" precision="9" scale="1"> <formula>{{FacilityCount}}/{{$Model.AllAccountsAgg.data.0.FacilityCount}} *100</formula> </field> <field id="BedPercent" uionly="true" displaytype="FORMULA" label="BedPercent" ogdisplaytype="TEXT" readonly="true" returntype="DOUBLE" precision="9" scale="1"> <formula>{{BedCount}}/{{$Model.AllAccountsAgg.data.0.BedCount}} *100</formula> </field> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" operator="in" model="AllAccounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> <condition type="fieldvalue" value="Active" enclosevalueinquotes="true" field="Dental_Status__c"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="AllAccountsAggByStatusInactive" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Account"> <fields> <field id="Id" name="FacilityCount" function="COUNT"/> <field id="Bed_Count__c" name="BedCount" function="SUM"/> <field id="FacilityPercent" uionly="true" displaytype="FORMULA" ogdisplaytype="TEXT" readonly="true" returntype="DOUBLE" precision="9" scale="1"> <formula>{{FacilityCount}}/{{$Model.AllAccountsAgg.data.0.FacilityCount}} *100</formula> </field> <field id="BedPercent" uionly="true" displaytype="FORMULA" label="BedPercent" ogdisplaytype="TEXT" readonly="true" returntype="DOUBLE" precision="9" scale="1"> <formula>{{BedCount}}/{{$Model.AllAccountsAgg.data.0.BedCount}} *100</formula> </field> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" operator="in" model="AllAccounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> <condition type="fieldvalue" value="Inactive" enclosevalueinquotes="true" field="Dental_Status__c"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="AllAccountsAggByStatusDeclined" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Account"> <fields> <field id="Id" name="FacilityCount" function="COUNT"/> <field id="Bed_Count__c" name="BedCount" function="SUM"/> <field id="FacilityPercent" uionly="true" displaytype="FORMULA" ogdisplaytype="TEXT" readonly="true" returntype="DOUBLE" precision="9" scale="1"> <formula>{{FacilityCount}}/{{$Model.AllAccountsAgg.data.0.FacilityCount}} *100</formula> </field> <field id="BedPercent" uionly="true" displaytype="FORMULA" label="BedPercent" ogdisplaytype="TEXT" readonly="true" returntype="DOUBLE" precision="9" scale="1"> <formula>{{BedCount}}/{{$Model.AllAccountsAgg.data.0.BedCount}} *100</formula> </field> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" operator="in" model="AllAccounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> <condition type="fieldvalue" value="Declined" enclosevalueinquotes="true" field="Dental_Status__c"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="AllAccountsAggByStatusProspect" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Account"> <fields> <field id="Id" name="FacilityCount" function="COUNT"/> <field id="Bed_Count__c" name="BedCount" function="SUM"/> <field id="FacilityPercent" uionly="true" displaytype="FORMULA" ogdisplaytype="TEXT" readonly="true" returntype="DOUBLE" precision="9" scale="1"> <formula>{{FacilityCount}}/{{$Model.AllAccountsAgg.data.0.FacilityCount}} *100</formula> </field> <field id="BedPercent" uionly="true" displaytype="FORMULA" label="BedPercent" ogdisplaytype="TEXT" readonly="true" returntype="DOUBLE" precision="9" scale="1"> <formula>{{BedCount}}/{{$Model.AllAccountsAgg.data.0.BedCount}} *100</formula> </field> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" operator="in" model="AllAccounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> <condition type="fieldvalue" value="Prospect" enclosevalueinquotes="true" field="Dental_Status__c"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="AllFacilityAccountsStatusNotActInaDecPros" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account"> <fields> <field id="Name"/> <field id="Dental_Status__c"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" operator="in" model="AllAccounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> <condition type="multiple" value="" field="Dental_Status__c" operator="not in" enclosevalueinquotes="true"> <values> <value>Active</value> <value>Inactive</value> <value>Declined</value> <value>Prospect</value> </values> </condition> </conditions> <actions/> <groupby method="simple"/> </model> <model id="Dental_Accounts" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account"> <fields> <field id="Sales_Region__c"/> <field id="Type"/> <field id="Name"/> <field id="Dental_Marketing_Status__c"/> <field id="Dental_Status__c"/> <field id="Dental_Status_Age__c"/> <field id="Id"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" operator="in" model="AllAccounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="Dental_Accounts_OB" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account"> <fields> <field id="Sales_Region__c"/> <field id="Type"/> <field id="Name"/> <field id="Dental_Marketing_Status__c"/> <field id="Dental_Status__c"/> <field id="Dental_Status_Age__c"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" fieldtargetobjects="RecordType" operator="in" model="Dental_Accounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> <condition type="fieldvalue" value="On-boarding" enclosevalueinquotes="true" field="Dental_Marketing_Status__c"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="Dental_Accounts_CR" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account"> <fields> <field id="Sales_Region__c"/> <field id="Type"/> <field id="Name"/> <field id="Dental_Marketing_Status__c"/> <field id="Dental_Status__c"/> <field id="Dental_Status_Age__c"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" fieldtargetobjects="RecordType" operator="in" model="Dental_Accounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> <condition type="fieldvalue" value="Clinic Ready" enclosevalueinquotes="true" field="Dental_Marketing_Status__c"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="Dental_Accounts_20" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account"> <fields> <field id="Sales_Region__c"/> <field id="Type"/> <field id="Name"/> <field id="Dental_Marketing_Status__c"/> <field id="Dental_Status__c"/> <field id="Dental_Status_Age__c"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" fieldtargetobjects="RecordType" operator="in" model="Dental_Accounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="Dental_Accounts_30" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account"> <fields> <field id="Sales_Region__c"/> <field id="Type"/> <field id="Name"/> <field id="Dental_Marketing_Status__c"/> <field id="Dental_Status__c"/> <field id="Dental_Status_Age__c"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" fieldtargetobjects="RecordType" operator="in" model="Dental_Accounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="Dental_Accounts_40" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account"> <fields> <field id="Sales_Region__c"/> <field id="Type"/> <field id="Name"/> <field id="Dental_Marketing_Status__c"/> <field id="Dental_Status__c"/> <field id="Dental_Status_Age__c"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" fieldtargetobjects="RecordType" operator="in" model="Dental_Accounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="Dental_Accounts_50" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account"> <fields> <field id="Sales_Region__c"/> <field id="Type"/> <field id="Name"/> <field id="Dental_Marketing_Status__c"/> <field id="Dental_Status__c"/> <field id="Dental_Status_Age__c"/> </fields> <conditions logic=""> <condition type="modelmerge" value="" field="Id" fieldtargetobjects="RecordType" operator="in" model="Dental_Accounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="DentalActiveSummary" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Account"> <fields> <field id="Id" name="AccountCount" function="COUNT"/> <field id="Bed_Count__c" name="BedCount" function="SUM"/> <field id="Active_Dental_Patients__c" name="ActiveDentalPatients" function="SUM"/> <field id="Dental_Prospects__c" name="DentalProspects" function="SUM"/> <field id="Participation" uionly="true" displaytype="FORMULA" ogdisplaytype="TEXT" readonly="true" returntype="DOUBLE" precision="9" scale="1" label="Participation"> <formula>ROUND({{$Model.DentalActiveSummary.data.0.ActiveDentalPatients}}/{{$Model.DentalActiveSummary.data.0.BedCount}}*100)</formula> </field> </fields> <conditions> <condition type="fieldvalue" value="Active" enclosevalueinquotes="true" field="Dental_Status__c"/> <condition type="modelmerge" value="" field="Id" operator="in" model="Dental_Accounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> </conditions> <actions/> <groupby method="simple"/> </model> <model id="ActiveDentalPatients" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Account_Snapshot__c" orderby=""> <fields> <field id="Date" uionly="true" displaytype="FORMULA" label="Date" ogdisplaytype="TEXT" readonly="true" returntype="TEXT" datasource="salesforce"> <formula>IF({{{CALENDAR_MONTH}}}="1","Jan", IF({{{CALENDAR_MONTH}}}="2","Feb", IF({{{CALENDAR_MONTH}}}="3","Mar", IF({{{CALENDAR_MONTH}}}="4","Apr", IF({{{CALENDAR_MONTH}}}="5","May", IF({{{CALENDAR_MONTH}}}="6","June", IF({{{CALENDAR_MONTH}}}="7","July", IF({{{CALENDAR_MONTH}}}="8","Aug", IF({{{CALENDAR_MONTH}}}="9","Sept", IF({{{CALENDAR_MONTH}}}="10","Oct", IF({{{CALENDAR_MONTH}}}="11","Nov","Dec"))))))))))) +"-"+{{{DAY_IN_MONTH}}}+"-"+{{{CALENDAR_YEAR}}}</formula> </field> <field id="SortedDate" uionly="true" displaytype="FORMULA" label="SortedDate" ogdisplaytype="TEXT" readonly="true" returntype="TEXT" precision="9" scale="0"> <formula>{{{CALENDAR_YEAR}}}+ IF(LEN({{{CALENDAR_MONTH}}})=1,"0"+{{{CALENDAR_MONTH}}},{{{CALENDAR_MONTH}}})+ IF(LEN({{{DAY_IN_MONTH}}})=1,"0"+{{{DAY_IN_MONTH}}},{{{DAY_IN_MONTH}}})</formula> </field> <field id="Active_Dental_Patients__c" name="sumActiveDentalPatientsc" function="SUM"/> </fields> <conditions> <condition type="fieldvalue" value="LAST_N_DAYS:7" enclosevalueinquotes="false" field="CreatedDate" state="filterableon" inactive="false" name="Last7Days"/> <condition type="fieldvalue" value="LAST_N_MONTHS:3" enclosevalueinquotes="false" field="CreatedDate" state="filterableoff" inactive="true" name="Last3Months"/> <condition type="fieldvalue" value="NEXT_N_YEARS:1" enclosevalueinquotes="false" field="CreatedDate" state="filterableoff" inactive="true" name="Last1Year"/> <condition type="modelmerge" value="" field="Account__c" fieldtargetobjects="Account" operator="in" model="AllAccounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> </conditions> <actions/> <groupby method="simple"> <field id="CreatedDate" name="DAY_IN_YEAR" function="DAY_IN_YEAR"/> <field id="CreatedDate" name="CALENDAR_MONTH" function="CALENDAR_MONTH"/> <field id="CreatedDate" name="CALENDAR_YEAR" function="CALENDAR_YEAR"/> <field id="CreatedDate" name="DAY_IN_MONTH" function="DAY_IN_MONTH"/> </groupby> </model> <model id="DentalProspects" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Account_Snapshot__c" orderby=""> <fields> <field id="Date" uionly="true" displaytype="FORMULA" label="Date" ogdisplaytype="TEXT" readonly="true" returntype="TEXT" datasource="salesforce"> <formula>IF({{{CALENDAR_MONTH}}}="1","Jan", IF({{{CALENDAR_MONTH}}}="2","Feb", IF({{{CALENDAR_MONTH}}}="3","Mar", IF({{{CALENDAR_MONTH}}}="4","Apr", IF({{{CALENDAR_MONTH}}}="5","May", IF({{{CALENDAR_MONTH}}}="6","June", IF({{{CALENDAR_MONTH}}}="7","July", IF({{{CALENDAR_MONTH}}}="8","Aug", IF({{{CALENDAR_MONTH}}}="9","Sept", IF({{{CALENDAR_MONTH}}}="10","Oct", IF({{{CALENDAR_MONTH}}}="11","Nov","Dec"))))))))))) +"-"+{{{DAY_IN_MONTH}}}+"-"+{{{CALENDAR_YEAR}}}</formula> </field> <field id="SortedDate" uionly="true" displaytype="FORMULA" label="SortedDate" ogdisplaytype="TEXT" readonly="true" returntype="TEXT" precision="9" scale="0"> <formula>{{{CALENDAR_YEAR}}}+ IF(LEN({{{CALENDAR_MONTH}}})=1,"0"+{{{CALENDAR_MONTH}}},{{{CALENDAR_MONTH}}})+ IF(LEN({{{DAY_IN_MONTH}}})=1,"0"+{{{DAY_IN_MONTH}}},{{{DAY_IN_MONTH}}})</formula> </field> <field id="Dental_Prospects__c" name="sumDentalProspectsc" function="SUM"/> </fields> <conditions> <condition type="fieldvalue" value="LAST_N_DAYS:7" enclosevalueinquotes="false" field="CreatedDate" state="filterableon" inactive="false" name="Last7Days"/> <condition type="fieldvalue" value="LAST_N_MONTHS:3" enclosevalueinquotes="false" field="CreatedDate" state="filterableoff" inactive="true" name="Last3Months"/> <condition type="fieldvalue" value="NEXT_N_YEARS:1" enclosevalueinquotes="false" field="CreatedDate" state="filterableoff" inactive="true" name="Last1Year"/> <condition type="modelmerge" value="" field="Account__c" fieldtargetobjects="Account" operator="in" model="AllAccounts" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/> </conditions> <actions/> <groupby method="simple"> <field id="CreatedDate" name="DAY_IN_YEAR" function="DAY_IN_YEAR"/> <field id="CreatedDate" name="CALENDAR_MONTH" function="CALENDAR_MONTH"/> <field id="CreatedDate" name="CALENDAR_YEAR" function="CALENDAR_YEAR"/> <field id="CreatedDate" name="DAY_IN_MONTH" function="DAY_IN_MONTH"/> </groupby> </model> </models> <components> <wrapper uniqueid="sk-1S_VFE-1897"> <components> <panelset type="standard" uniqueid="sk-1JLn1Y-803" scroll=""> <panels> <panel type="left" width="225px" uniqueid="logoPanel" cssclass="headerPanel"> <components> <image source="staticresource" uniqueid="sk-1JLo-4-810" datasource="salesforce" behavior="link" alt="MultiGen Health" resource="mgh_logo" resourceContentType="image/jpeg"> <styles> <styleitem type="itemsize"/> <styleitem type="border"/> </styles> <interactions> <interaction type="tap"> <action type="redirect" window="blank" url="http://multigenhealth.com/"/>; </interaction> </interactions> </image> </components> </panel> <panel cssclass="headerPanel"> <components> <filterset model="AllAccounts" searchmethod="server" searchbox="true" uniqueid="sk-vJxoV-618" position="right" emptysearchbehavior="query" instantfilters="false"> <filters> <filter type="multiselect" filteroffoptionlabel="--- Any ---" createfilteroffoption="true" affectcookies="false" autocompthreshold="25" conditionsource="auto" labelmode="auto" conditionfield="Sales_Region__c" conditionoperator="in"/> <filter type="multiselect" filteroffoptionlabel="--- Any ---" createfilteroffoption="true" affectcookies="false" autocompthreshold="25" conditionsource="manual" labelmode="manual" condition="Type" label="Account Type"> <sources> <source type="manual" effectsbehavior="justdefault"> <options> <option label="Long-Term Care" type="simple" value="Long-Term Care"/> <option label="Retirement" type="simple" value="Retirement"/> <option label="Corporation" type="simple" value="Corporation"/> </options> </source> </sources> </filter> </filters> <searchfields/> </filterset> </components> </panel> </panels> </panelset> </components> <styles> <styleitem type="background"/> <styleitem type="border" padding="top,"> <styles> <styleitem property="padding-top" value="10px"/> <styleitem property="box-sizing" value="border-box"/> </styles> </styleitem> <styleitem type="size"/> </styles> </wrapper> <richtext multiple="false" uniqueid="sk-1JJ9mP-706"> <contents>&lt;p style="text-align: center;"&gt;&lt;strong&gt;&lt;span style="font-size:48px;"&gt;Facilities&lt;/span&gt;&lt;/strong&gt;&lt;/p&gt; </contents> </richtext> <wrapper uniqueid="sk-vgUGT-731"> <components> <wrapper uniqueid="sk-1SzXxe-1679"> <components> <grid uniqueid="sk-vlWSa-297" columngutter="10px" rowgutter="10px"> <divisions> <division behavior="flex" minwidth="100px" ratio="1" verticalalign="top"> <components> <wrapper uniqueid="sk-kh45C-629"> <components> <richtext multiple="false" uniqueid="sk-kghoD-585" model="AllAccountsAgg"> <contents>&lt;p style="text-align: center;"&gt;&lt;span style="font-size:22px;"&gt;&lt;span style="color:#e6ebed;"&gt;Total Facilities&lt;/span&gt;&lt;/span&gt;&lt;/p&gt; &lt;p style="text-align: center;"&gt;&lt;span style="font-size:36px;"&gt;&lt;span style="color:#ffffff;"&gt;{{FacilityCount}}&lt;/span&gt;&lt;/span&amp
  • Pat VachonPat Vachon 💎💎💎
    edited September 16, 2017
    Emailed Chris Jackson the XML since it seems this didn't work.
  • edited September 18, 2017
    I got it from him this morning. It doesn't look like the same as in your video. I have a few questions for you:

    Can your reproduce this using standard objects and fields and without snippets?
    What version are you on? When I go to rebuild your page, I see different options than you do. 
    How does your "No Data" work? I don't see that anywhere in the XML I have been given. 

    This is the XML I am currently working on:

    <skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="false" useviewportmeta="true" showheader="false">    <models>
            <model id="Accounter" limit="20" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account">
                <fields>
                    <field id="Name"/>
                    <field id="Id"/>
                    <field id="AnnualRevenue"/>
                </fields>
                <conditions>
                    <condition type="fieldvalue" value="Redrum" enclosevalueinquotes="true" field="Name" state="filterableoff" inactive="true" name="Name"/>
                </conditions>
                <actions/>
            </model>
        </models>
        <components>
            <buttonset model="Accounter" uniqueid="sk-2LRet2-173">
                <buttons>
                    <button type="multi" label="Activate Via Button Set" uniqueid="sk-2LSK2E-223">
                        <actions>
                            <action type="activateCondition" model="Accounter" condition="Name"/>
                            <action type="requeryModel" behavior="standard" model="Accounter"/>
                        </actions>
                    </button>
                    <button type="multi" label="Deactivate Via Button Set" uniqueid="sk-2LSSwr-240">
                        <actions>
                            <action type="deactivateCondition" model="Accounter" condition="Name"/>
                            <action type="requeryModel" model="Accounter" behavior="standard"/>
                        </actions>
                    </button>
                </buttons>
            </buttonset>
            <filterset model="Accounter" searchmethod="server" searchbox="true" uniqueid="sk-2LQuiU-133">
                <filters>
                    <filter type="select" filteroffoptionlabel="Add Filter" createfilteroffoption="true" affectcookies="false" autocompthreshold="25" conditionsource="manual" labelmode="no">
                        <sources>
                            <source type="manual" effectsbehavior="justdefault">
                                <options>
                                    <option label="Activate" type="complex">
                                        <effects>
                                            <effect action="set" value="" condition="Name"/>
                                        </effects>
                                    </option>
                                    <option label="Inactive" type="complex">
                                        <effects>
                                            <effect action="deactivate" value="" condition="Name"/>
                                        </effects>
                                    </option>
                                </options>
                            </source>
                        </sources>
                    </filter>
                </filters>
            </filterset>
            <richtext multiple="false" uniqueid="sk-2LUK7D-295" model="Accounter">
                <contents>&lt;p style="text-align: center;"&gt;&lt;span style="font-size:72px;"&gt;---No Data---&lt;/span&gt;&lt;/p&gt;
    </contents>
                <renderconditions logictype="and">
                    <rendercondition type="blank" operator="=" fieldmodel="Accounter" sourcetype="fieldvalue" nosourcerowbehavior="skipandrender" value="null" enclosevalueinquotes="false" field="Name" fieldtargetobjects="Account"/>
                </renderconditions>
            </richtext>
            <skootable showconditions="true" showsavecancel="true" showerrorsinline="true" searchmethod="server" searchbox="true" showexportbuttons="false" pagesize="10" alwaysresetpagination="false" createrecords="true" model="Accounter" buttonposition="" mode="read" allowcolumnreordering="true" responsive="true" uniqueid="sk-2LQqRy-106">
                <fields>
                    <field id="Id" hideable="true" uniqueid="fi-2LQseo-120"/>
                    <field id="Name" hideable="true" uniqueid="fi-2LQsep-121"/>
                    <field id="AnnualRevenue" hideable="true" uniqueid="fi-2LQsep-122"/>
                </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>
        <resources>
            <labels/>
            <javascript/>
            <css/>
        </resources>
        <styles>
            <styleitem type="background" bgtype="none"/>
        </styles>
    </skuidpage>


  • edited September 18, 2017
    I got it from him this morning. It doesn't look like the same as in your video. I have a few questions for you:

    Can your reproduce this using standard objects and fields and without snippets?
    What version are you on? When I go to rebuild your page, I see different options than you do. 
    How does your "No Data" work? I don't see that anywhere in the XML I have been given. 

    This is the XML I am currently working on:

    <skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="false" useviewportmeta="true" showheader="false">    <models>
            <model id="Accounter" limit="20" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="Account">
                <fields>
                    <field id="Name"/>
                    <field id="Id"/>
                    <field id="AnnualRevenue"/>
                </fields>
                <conditions>
                    <condition type="fieldvalue" value="Redrum" enclosevalueinquotes="true" field="Name" state="filterableoff" inactive="true" name="Name"/>
                </conditions>
                <actions/>
            </model>
        </models>
        <components>
            <buttonset model="Accounter" uniqueid="sk-2LRet2-173">
                <buttons>
                    <button type="multi" label="Activate Via Button Set" uniqueid="sk-2LSK2E-223">
                        <actions>
                            <action type="activateCondition" model="Accounter" condition="Name"/>
                            <action type="requeryModel" behavior="standard" model="Accounter"/>
                        </actions>
                    </button>
                    <button type="multi" label="Deactivate Via Button Set" uniqueid="sk-2LSSwr-240">
                        <actions>
                            <action type="deactivateCondition" model="Accounter" condition="Name"/>
                            <action type="requeryModel" model="Accounter" behavior="standard"/>
                        </actions>
                    </button>
                </buttons>
            </buttonset>
            <filterset model="Accounter" searchmethod="server" searchbox="true" uniqueid="sk-2LQuiU-133">
                <filters>
                    <filter type="select" filteroffoptionlabel="Add Filter" createfilteroffoption="true" affectcookies="false" autocompthreshold="25" conditionsource="manual" labelmode="no">
                        <sources>
                            <source type="manual" effectsbehavior="justdefault">
                                <options>
                                    <option label="Activate" type="complex">
                                        <effects>
                                            <effect action="set" value="" condition="Name"/>
                                        </effects>
                                    </option>
                                    <option label="Inactive" type="complex">
                                        <effects>
                                            <effect action="deactivate" value="" condition="Name"/>
                                        </effects>
                                    </option>
                                </options>
                            </source>
                        </sources>
                    </filter>
                </filters>
            </filterset>
            <richtext multiple="false" uniqueid="sk-2LUK7D-295" model="Accounter">
                <contents>&lt;p style="text-align: center;"&gt;&lt;span style="font-size:72px;"&gt;---No Data---&lt;/span&gt;&lt;/p&gt;
    </contents>
                <renderconditions logictype="and">
                    <rendercondition type="blank" operator="=" fieldmodel="Accounter" sourcetype="fieldvalue" nosourcerowbehavior="skipandrender" value="null" enclosevalueinquotes="false" field="Name" fieldtargetobjects="Account"/>
                </renderconditions>
            </richtext>
            <skootable showconditions="true" showsavecancel="true" showerrorsinline="true" searchmethod="server" searchbox="true" showexportbuttons="false" pagesize="10" alwaysresetpagination="false" createrecords="true" model="Accounter" buttonposition="" mode="read" allowcolumnreordering="true" responsive="true" uniqueid="sk-2LQqRy-106">
                <fields>
                    <field id="Id" hideable="true" uniqueid="fi-2LQseo-120"/>
                    <field id="Name" hideable="true" uniqueid="fi-2LQsep-121"/>
                    <field id="AnnualRevenue" hideable="true" uniqueid="fi-2LQsep-122"/>
                </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>
        <resources>
            <labels/>
            <javascript/>
            <css/>
        </resources>
        <styles>
            <styleitem type="background" bgtype="none"/>
        </styles>
    </skuidpage>


  • Pat VachonPat Vachon 💎💎💎
    edited September 19, 2017
    This would be far easier via GTM.

    Version 10.0.6

    Snippet execution is part of the problem, but not the problem itself. Chart doesn't like having any snippet when there's no data after re-querying model.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!