0

I have a list with 2 different views one that shows all items and one that shows current items.

But if startdate is null the item wont show up on current view. startdate should be nullable. How can i fix this?

In the schema file it looks like this:

    <Query>
      <Where>
        <And>
            <Leq>
            <FieldRef Name="StartDate"/>
            <Value Type="DateTime" IncludeTimeValue="TRUE">
              <Today />
            </Value>
          </Leq>
          <Geq>
            <FieldRef Name="EndDate" />
            <Value Type="DateTime" IncludeTimeValue="TRUE">
              <Today />
            </Value>
          </Geq>
        </And>
      </Where>
    </Query>
2
<Query>
  <Where>
    <Or>
      <And>...</And>
      <IsNull>
        <FieldRef Name="StartDate" />
      </IsNull>
    </Or>
  </Where>
</Query>

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.