Search for a number between the values in two fields

This support ticket is created 4 years, 11 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

No supporters are available to work today on Toolset forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

Tagged: Custom search, Views plugin

This topic contains 1 reply, has 2 voices.

Last updated by Luo Yang 4 years, 11 months ago.

Assisted by: Luo Yang.

Author

Posts

December 13, 2019 at 11:48 pm #1409115

davidZ

I have a Custom Post Type with two ACF fields: Year_Beginning and Year_Ending.

In my view, I would like to have a text field into which people can enter a 4 digit year and filter to show all the records for which that number is between the two ACF values.

So if you typed "1927" you would find a record where Year_Beginning is 1925 and Year_Ending is 1930.

I can't seem to add a custom filter that can do this. Can you tell me if there's a way to accomplish this?

Thanks

December 16, 2019 at 3:24 am #1410961

Luo Yang

Hello,

It is possible, you can add two filters on same URL parameter, for example:
Select items with field:
Year_Beginning is a number lower than or equal URL_PARAM(my-url-param)
AND
Year_Ending is a number greater than or equal URL_PARAM(my-url-param)

More help:
https://toolset.com/documentation/user-guides/filtering-views-by-custom-fields/