[Resolved] Query filters aren't working as expected

[Author]

Posts

[josephQ]

I have a custom post type named Exhibition. It has some fields on it, including a Start Date and End Date. The fields are Date Pickers and just store month, day, and year values.

My site has 7 Exhibitions pages. I created three views for them:

+ Past Exhibitions (2006-2010)
View: hidden link
Webpage: hidden link

+ Past Exhibitions (2011-2015)
View: hidden link
Webpage: hidden link

+ Past Exhibitions (2016-Present)
View: hidden link
Webpage: hidden link

(Screenshots are also attached.)

The Views associated with them use the Start and End Dates to grab just the exhibitions during the relevant time periods. The
problem is that they're not working as expected. On the webpages, they all say "No items found." Can someone investigate?

Thank you!

--

On a related note, it would be nice if in the query filter I could re-use the same field like I can in a SQL query to say, "find records whose price is greater than 50 and whose price is less than 100."

[Luo Yang]

Hello,

Thank for the details, I have done below modification in your website:
Edit the view "View - Exhibitions - Past Exhibitions 2006-2010 - Index"
hidden link

In section "Query Filter", change the filter from value type from "DATE" to "UNSIGNED", from

Select items with field:
Exhibition Start Date is a DATE greater than or equal DATE(01, 01, 2006)
AND
Exhibition End Date is a DATE lower than or equal DATE(31, 12, 2010)

To:

Select items with field:
Exhibition Start Date is a UNSIGNED greater than or equal DATE(01, 01, 2006)
AND
Exhibition End Date is a UNSIGNED lower than or equal DATE(31, 12, 2010)

You can test it here:
hidden link

More help:
https://toolset.com/documentation/user-guides/date-filters/
when inserting a query filter to test a date custom field you should use the UNSIGNED option.

[josephQ]

Ah, wonderful! That did the trick!

Thank you!