Skip to main content
Nintex Community Menu Bar
Question

Reference field filter ignored when source model is empty

  • July 9, 2024
  • 6 replies
  • 11 views

Forum|alt.badge.img+13

Hello -

When a reference field filter is marked to filter results based on value in another model and set to ‘Abort query’ if no data in source model, the condition is being ignored and all results are being returned.

Steps to Reproduce:

  1. Create Contact ‘New’ page
  2. Add two models:
    a) AccountEmpty - Based on Account, contains Id & Name and is NOT marked to load data or create new
    b) AccountFull - Based on Account, contains Id & Name and is marked to load data with max records of 1
  3. Add AccountId to contact model
  4. Add Account field to Contact Field Editor setting filter to Account Id in AccountEmpty Id and abort if no data
  5. Add a second Account field to Contact Field Editor setting filter to Account Id in AccountFull Id
  6. Preview page
  7. Click magnifying glass on “AccountEmpty” field

Actual Result
All Accounts are returned

Expected Result
No records should be returned

  1. Click magnifying glass on “AccountFull” field

Actual Result = Expected Result
Only contacts from the account that was loaded are displayed

Sample Page XML

<skuidpage unsavedchangeswarning="yes" showsidebar="true" showheader="true" tabtooverride="Contact">   <models>
      <model id="AccountEmpty" limit="" query="false" createrowifnonefound="false" sobject="Account" doclone="no" type="">
         <fields>
            <field id="Id"/>
            <field id="Name"/>
         </fields>
         <conditions/>
         <actions/>
      </model>
      <model id="AccountFull" limit="1" query="true" createrowifnonefound="false" sobject="Account" doclone="no" type="">
         <fields>
            <field id="Id"/>
            <field id="Name"/>
         </fields>
         <conditions/>
         <actions/>
      </model>
      <model id="Contact" limit="1" query="false" createrowifnonefound="true" sobject="Contact">
         <fields>
            <field id="FirstName"/>
            <field id="LastName"/>
            <field id="AccountId"/>
            <field id="Account.Name"/>
            <field id="Account.Id"/>
         </fields>
         <conditions/>
         <actions/>
      </model>
   </models>
   <components>
      <basicfieldeditor showsavecancel="false" showheader="true" model="Contact" mode="edit" buttonposition="" layout="">
         <columns>
            <column width="100%">
               <sections>
                  <section title="Basics" collapsible="no">
                     <fields>
                        <field id="AccountId" valuehalign="" type="">
                           <label>Account From Empty</label>
                           <filters>
                              <filter type="modelmerge" operator="in" field="Id" value="" model="AccountEmpty" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="noquery"/>
                           </filters>
                        </field>
                        <field id="AccountId" valuehalign="" type="">
                           <label>Account From Full</label>
                           <filters>
                              <filter type="modelmerge" operator="in" field="Id" value="" model="AccountFull" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="noquery"/>
                           </filters>
                           <renderconditions logictype="and" onhidedatabehavior="keep"/>
                        </field>
                     </fields>
                  </section>
               </sections>
            </column>
         </columns>
      </basicfieldeditor>
   </components>
   <resources>
      <labels/>
      <css/>
      <javascript/>
   </resources>
</skuidpage>

Thank you!

6 replies

Forum|alt.badge.img+17
  • Nintex Employee
  • July 9, 2024

Thanks Barry.  This issue was reported last week.  I do appreciate the detailed error report though.  As we work the issue,  we will make sure your page works as expected. 


Forum|alt.badge.img+13

Thanks for the update Rob.  I somehow overlooked the previous post about this when searching (I found it this time), sorry about that.

Any idea on timing of the fix for this (e.g. patch release, summer release, etc.)?


Forum|alt.badge.img+17
  • Nintex Employee
  • July 9, 2024

This is not currently planned to be released in the upcoming release.  We will slate it for as soon as possible afterward… 


Forum|alt.badge.img+6
  • Nintex Employee
  • July 9, 2024

Barry,

This is fixed in our next patch release (7.13, Banzai Update 2). Thanks for hanging in there with us!


Forum|alt.badge.img+13

Thanks J!  Skuid is well worth the “hang time”!


Forum|alt.badge.img+13

Tested and confirmed as resolved in Skuid 7.16.  Thank you!