Blank dates when filtering list builder list

When applying column filters to a custom list builder list blank dates are included in the filtered results. This is not consistent with functionality in other areas of the application.
This can be addressed by using a Between filter instead of a Before filter.  Set the first range of the Between filter to a date far into the past and the Before date into the future, and the null values will not be pulled.  

Steps to Duplicate

Create a custom list:
--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--
<QueryViewSpec
    xmlns="bb_appfx_queryview"
    xmlns:c="bb_appfx_commontypes"
    ID="CDBB6256-B9A2-47B3-B6B8-3D2ED7E68423"
    Name="Listbuilder Test"
    Description="Listbuilder test"
    Author="Developer Solutions Support"
    IsRoot="false"
    PrimaryKeyField="ID"
    RecordType="Constituent"
    UseInReportModelGenerator="true"
    >

  <!-- define the view used to return data for the query -->
    <ViewImplementation ViewName="USR_V_QUERY_LISTBUILDERTEST">
        <ViewSQL>
            <![CDATA[
        Select 
            C.ID,
            C.KEYNAME,
            C.FIRSTNAME,
            C.ISINACTIVE,
            C.CUSTOMIDENTIFIER,
            C.DATEADDED,
            C.GENDER,
            C.NAME,
            R.DATE as 'REVENUEDATE',
            R.POSTDATE as 'REVENUEPOSTDATE',
            r.AMOUNT
        From Revenue R
        Left Join Constituent C
            On R.CONSTITUENTID = C.ID  ]]>
        </ViewSQL>
    </ViewImplementation>

  <!-- describe each field in the view output -->
  <Output>
    <OutputFields>
      <OutputField Caption="System record ID" Category="System Fields" Name="ID" />
      <OutputField Name="KEYNAME" Caption="Last Name" DataType="String" />
      <OutputField Name="FIRSTNAME" Caption="First Name" DataType="String" />
      <OutputField Name="ISINACTIVE" Caption="Inactive?" DataType="Boolean" />
      <OutputField Name="CUSTOMIDENTIFIER" Caption="Custom Identifier" DataType="String" />
      <OutputField Name="DATEADDED" Caption="Date Added" DataType="Date" />
      <OutputField Name="GENDER" Caption="GENDER" DataType="String" />
      <OutputField Name="REVENUEDATE" Caption="Revenue Date" DataType="Date" />
      <OutputField Name="REVENUEPOSTDATE" Caption="Revenue Post Date" DataType="Date" />
      <OutputField Name="AMOUNT" Caption="Full Name" DataType="Money" />
    </OutputFields>
    <IdentifyingFields>
      <IdentifyingField Name="NAME"/>
    </IdentifyingFields>
  </Output>

  <!--
  <RelationshipOperations>
    <AddToParentView
            ParentView="V_QUERY_CONSTITUENT"
            ParentViewRelatedField="ID"
            Field="ID"
            Cardinality="OneToOne"
            PathAlias="Food Bank" />
  </RelationshipOperations>
-->


  <ListBuilder>
    <Columns>
      <Column Name="ID" IsDefaultColumn="true" />
      <Column Name="KEYNAME"  IsDefaultColumn="true" />
      <Column Name="FIRSTNAME" IsDefaultColumn="true" />
      <Column Name="ISINACTIVE" IsDefaultColumn="true" />
      <Column Name="CUSTOMIDENTIFIER" IsDefaultColumn="true" />
      <Column Name="DATEADDED" IsDefaultColumn="true" />
      <Column Name="GENDER" IsDefaultColumn="true" />
      <Column Name="REVENUEDATE" IsDefaultColumn="true" />
      <Column Name="REVENUEPOSTDATE" IsDefaultColumn="true" />
      <Column Name="AMOUNT" IsDefaultColumn="true" />    
  </Columns>
  </ListBuilder>
</QueryViewSpec>
--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--

Filter on RevenuePostDate < Today.
Blank dates will be included.

Was this article helpful?