Field rendered as picklist not displaying more than 50 values

edited June 10, 2020 in Questions
I have rendered a reference field as a picklist in skuid which uses a filed form a model to display values in it. In console, it shows that all 53 existing recordsa re being fetched but only 50 values were getting displayed. The limit on the model rows fetched is given as 100. Could soemone help?

Comments

  • Anna WiersemaAnna Wiersema 🛠️ 
    edited June 5, 2020
    Hi Divya, what version of Skuid are using?  Are you building in v1 or v2?

    It looks like in v1 and v2 currently you can only have picklists that are 50 items long for reference fields.  I will log this as an issue in our tracking system.

    One workaround is to create a ui-only picklist field on the model and a new model to source the picklist values as demonstrated in the sample v2 page xml below ("Owner - UI Only" is the field):

    <skuid__page unsavedchangeswarning="yes" personalizationmode="server" showsidebar="true" showheader="true">
    <models>
    <model id="NewModel" limit="20" query="false" createrowifnonefound="true" datasource="DemoOrgSalesforce" sobject="Contact">
    <fields>
    <field id="OwnerId" overridemetadata="false" ogdisplaytype="REFERENCE" displaytype="REFERENCE" datasource="DemoOrgSalesforce" defaultvaluetype="fieldvalue" targetobjects="User" keyfield="Id">
    <batchfields/>
    </field>
    <field id="Owner.Name"/>
    <field id="Owner - UI Only" uionly="true" displaytype="PICKLIST" length="255" ogdisplaytype="TEXT" picklistsource="rowsinmodel" returntype="TEXT" picklistmodel="Users" entryvalue="{{Id}}" entrylabel="{{Name}}">
    <picklistentries/>
    </field>
    </fields>
    <conditions/>
    <actions/>
    </model>
    <model id="Users" limit="" query="true" createrowifnonefound="false" datasource="DemoOrgSalesforce" sobject="User" orderby="Name">
    <fields>
    <field id="Name"/>
    </fields>
    <conditions/>
    <actions/>
    </model>
    </models>
    <components>
    <skuid__form showErrorsInline="true" uniqueid="sk-24v0-1658" mode="read" model="NewModel">
    <sections>
    <section title="New Section">
    <rows>
    <row>
    <fields>
    <skuid__field id="OwnerId" displayAs="PICKLIST" pageSize="5">
    <filters/>
    <renderConditions logictype="and" onhidedatabehavior="keep"/>
    <enableConditions/>
    </skuid__field>
    </fields>
    </row>
    <row>
    <fields>
    <skuid__field id="User"/>
    </fields>
    </row>
    </rows>
    </section>
    </sections>
    </skuid__form>
    </components>
    <resources>
    <labels/>
    <javascript/>
    <css/>
    <actionsequences/>
    </resources>
    <styles>
    <styleitem type="background" bgtype="none"/>
    </styles>
    </skuid__page>



  • Anna WiersemaAnna Wiersema 🛠️ 
    edited June 10, 2020
    To use the workaround, make sure to add a model action that runs when your Ui Only field is updated to update the value of the reference field. This way the values users select will be retained on the record when it's saved.
  • Hi Divya, thank you for your patience! Skuid has fixed the issue you raised about picklists not displaying more than 50 values (issue DSC-2178) in the new Boston (13.0.4) release which is now available on the Skuid Releases page.

    Best practices for upgrading can be found in Upgrading Skuid on Salesforce.  As a reminder, Salesforce does NOT allow reverting back to prior versions of managed packages. Skuid always recommends installing new versions in a non-business critical sandbox environment to test all mission critical functionality before installing into a production environment. We also recommend that you update out of date themes after you upgrade. Please let us know if you continue to encounter any problems with this issue after upgrading.

    Thanks again for alerting us of this issue!

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!