Skip to main content
Nintex Community Menu Bar
Question

Conditions with 'a blank value' add new records with 'null' string

  • July 11, 2024
  • 5 replies
  • 13 views

Forum|alt.badge.img+9

In Millau, new rows in models with conditions that set to ‘a blank value’ have a ‘null’ string added instead of being null. This then leads to an error if the field data type is not a string.

Model condition

New Row:

5 replies

Forum|alt.badge.img+10

Can you paste in the XML of this page so that we can explore in greater detail what you are seeing?


Forum|alt.badge.img+9

Here is a demo page that has the same behavior:

<skuidpage unsavedchangeswarning="yes" personalizationmode="server" useviewportmeta="true" showsidebar="true" showheader="true" tabtooverride="Account">
    <models>
        <model id="Account" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" sobject="Account" type="">
            <fields>
                <field id="Name"/>
                <field id="CreatedDate"/>
                <field id="ParentId"/>
                <field id="Parent.Name"/>
            </fields>
            <conditions>
                <condition type="blank" value="null" field="ParentId" fieldtargetobjects="Account" state="" operator="=" enclosevalueinquotes="false"/>
            </conditions>
            <actions/>
        </model>
    </models>
    <components>
        <pagetitle model="Account" uniqueid="sk-e2bUg-198">
            <maintitle>
                <template>{{Model.labelPlural}}</template>
            </maintitle>
            <subtitle>
                <template>Home</template>
            </subtitle>
            <actions>
                <action type="savecancel" uniqueid="sk-e2bUf-196"/>
            </actions>
        </pagetitle>
        <skootable showconditions="true" showsavecancel="false" searchmethod="server" searchbox="true" showexportbuttons="false" pagesize="10" createrecords="true" model="Account" mode="read" allowcolumnreordering="true" uniqueid="sk-e2bUz-212">
            <fields>
                <field id="Name" hideable="true" allowordering="true" uniqueid="fi-e2aBT-363"/>
                <field id="ParentId" hideable="true" uniqueid="fi-e2iMM-272" valuehalign="" type=""/>
                <field id="CreatedDate" hideable="true" allowordering="true" uniqueid="fi-e2aBT-364"/>
            </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/>
        <css/>
        <javascript/>
        <actionsequences uniqueid="sk-e2egm-241"/>
    </resources>
    <styles>
        <styleitem type="background" bgtype="none"/>
    </styles>
</skuidpage>

Forum|alt.badge.img+6
  • July 11, 2024

We have also found the same issue.


Forum|alt.badge.img+10

Thank you for bringing this to our attention. It appears there’s an issue in how we are treating null and blank in our conditions. There is not a target date for getting this issue addressed yet but our devs are aware of it. 


Forum|alt.badge.img+10
  • Nintex Employee
  • July 11, 2024

Thank you for your patience! Skuid has fixed the issue you raised in the new 11.0.3 release which is now available on the Skuid Releases page.


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 when you upgrade. Please let us know if you continue to encounter any problems with this issue after upgrading.
 
Thanks again for alerting us of these issues!