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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.