The age ranges have disappeared from the the profile excerpts. (Why is that?) For example, the man had a range of 50 - 80. The woman has a range of 18-35. That is gone from the search page. enlace oculto I have not edited this page. I'm wondering what happened. This happened before updating any plugins.
==>
I do not see any issue with page range or anything. It works just fine: enlace oculto
Maybe you should try to clear the cache as I see you are using plugin SG Optimizer
That is why I shared the information that how the comparison will be applied in backend with the value in my previous reply and how it will compare the actual value in comparison of the search input value.
=> https://toolset.com/forums/topic/min-and-max-fields-in-search-not-returning-correct-results/#post-1386599
If you will check my above reply, how comparison works is bit different than you think.
When I search for a user min-max of 20-25, (the woman who has a range of 18 to 35 that are actual values available)
- filter set minimum age >= search value
- filter set maximum age <= search value
This is how the query will build:
SELECT SQL_CALC_FOUND_ROWS wpae_posts.ID FROM wpae_posts INNER JOIN wpae_postmeta ON ( wpae_posts.ID = wpae_postmeta.post_id ) INNER JOIN wpae_postmeta AS mt1 ON ( wpae_posts.ID = mt1.post_id ) WHERE 1=1 AND wpae_posts.ID NOT IN (239) AND (
( wpae_postmeta.meta_key = 'wpcf-minimum-age' AND CAST(wpae_postmeta.meta_value AS SIGNED) >= '20' )
AND
( mt1.meta_key = 'wpcf-maximum-age' AND CAST(mt1.meta_value AS SIGNED) <= '25' )
) AND wpae_posts.post_type = 'talent' AND ((wpae_posts.post_status = 'publish' OR wpae_posts.post_status = 'private')) GROUP BY wpae_posts.ID ORDER BY wpae_posts.post_date DESC LIMIT 0, 10
As you can see:
- minimum age comparision will be translated to:
- 18 >= 20
- maximum age comparison will be translated to:
- 35 <= 25
Both conditions will become false. You need to place actual values.
That is why I shared the solution here, if you set the filter as I suggested with the following reply - you will get the woman who has a range of 18 to 35 when you enter search values min 20 and max 25:
=> https://toolset.com/forums/topic/min-and-max-fields-in-search-not-returning-correct-results/#post-1385775
So, for now, I already set the filters as explained in the above reply.
But, then you again shared another scenario:
49____________71 - search range, I want to see all users who fall in this range.
==>
This range will NOT show the results:
SELECT SQL_CALC_FOUND_ROWS wpae_posts.ID FROM wpae_posts INNER JOIN wpae_postmeta ON ( wpae_posts.ID = wpae_postmeta.post_id ) INNER JOIN wpae_postmeta AS mt1 ON ( wpae_posts.ID = mt1.post_id ) WHERE 1=1 AND wpae_posts.ID NOT IN (239) AND (
( wpae_postmeta.meta_key = 'wpcf-minimum-age' AND CAST(wpae_postmeta.meta_value AS SIGNED) <= '49' )
AND
( mt1.meta_key = 'wpcf-maximum-age' AND CAST(mt1.meta_value AS SIGNED) >= '71' )
) AND wpae_posts.post_type = 'talent' AND ((wpae_posts.post_status = 'publish' OR wpae_posts.post_status = 'private')) GROUP BY wpae_posts.ID ORDER BY wpae_posts.post_date DESC LIMIT 0, 10
-- As you can see the minimum age comparision will translate to: 50 <= 49 (which is false)
50__________70 -True, this person falls in that range.
===>
This range will show the results.
SELECT SQL_CALC_FOUND_ROWS wpae_posts.ID FROM wpae_posts INNER JOIN wpae_postmeta ON ( wpae_posts.ID = wpae_postmeta.post_id ) INNER JOIN wpae_postmeta AS mt1 ON ( wpae_posts.ID = mt1.post_id ) WHERE 1=1 AND wpae_posts.ID NOT IN (239) AND (
( wpae_postmeta.meta_key = 'wpcf-minimum-age' AND CAST(wpae_postmeta.meta_value AS SIGNED) <= '50' )
AND
( mt1.meta_key = 'wpcf-maximum-age' AND CAST(mt1.meta_value AS SIGNED) >= '71' )
) AND wpae_posts.post_type = 'talent' AND ((wpae_posts.post_status = 'publish' OR wpae_posts.post_status = 'private')) GROUP BY wpae_posts.ID ORDER BY wpae_posts.post_date DESC LIMIT 0, 10
So, all cases for min-max you shared are correct but 49____________71 beause the actual value for min age is set to 50.
Now, when you search for the following range: enlace oculto
- 20-25:
=> it will show you one result with woman pic
- 50-70:
=> it will show you one result with man pic
- 60-70:
=> it will show you one result with man pic
Let me know if you still have any confusion or you want to pass this ticket to support a person who works more closely with your timezone.
