Filtering between Minimum and Maximum Values

Anonymous

#78442

Hello,

I am using shortcode method to display the results.
I have 2 post meta fields (Min Loan Amount & Maximum Loan Amount) to filter using the slider.

If i change the value in range slider to filter, results should display only the posts which has loan amount between Min Loan Amount & Max Loan Amount Field.

For Example :
1. Min Loan Amount is 1000 , Max Loan Amount is 100000
2. Min loan amount is 2000 , Max Loan Amount is 60000.
3. Min Loan Amount is 5000 , Max Loan Amount is 100000.

In filter form, I set (Start Meta Key) Min Key Name as “Min Loan Amount” , Max key name as “Max Loan Amount” and Compare Mode as “Input must be within the Post Meta range”.

Value in the filer form should be between Post Meta fileds (Min Loan Amount & Max Loan Amount).
If the selected value in filer is 2000. It Should not show the 1st Post (Min Loan Amount is 1000 , Max Loan Amount is 100000) in the results.Because the Min Loan Amount of that post is 2000.

This is how i wanted it to work. But unfortunately its not working.

Please see the attached image for better understanding.

Trevor

#78451

I see the slider has one handle and not 2? What does the url query string look like? Does it perhaps have something like 0+2000 in it? In which case, maybe you would need to use the Edit Query Arguments filter to make this 2000+2000. To see if this works, manually alter the url and hit GO in the browser to refresh/reload the page.

Anonymous

#78523

I have disabled the 2nd handle.
Usually URL Query looks like below after changing the value.

http://www.cybergiftindia.com/ottobanking/?_sfm_amount_of_the_loan_from=15000+200000&_sfm_duration_from=6+180&_sfm_age_min=18+40

I tried changing the URL manually but no use.

I want to filter the values between 2 post meta fields.

Filtering value should be between the 2 pos meta fields to get the results.

Trevor

#78537

But the URL would need to look like this:

http://www.cybergiftindia.com/ottobanking/?_sfm_amount_of_the_loan_from=15000+15000&_sfm_duration_from=6+180&_sfm_age_min=18+40

I wonder if you could add some javascript to the page using the change or onchange of the from field to set the value of the to field to the same value?

Anonymous

#78539

Is it possible to set the value of to field as same as from field using javascript?
If so guide me. it would be helpful.

Trevor

#78760

I have been playing with the code and this will not work the way you have it. Instead of locking/hiding the upper value, can you lock/hide the lower value and not auto detect it but instead have it a 0? Then, instead of setting the match type to ‘Input within’, make it Input overlaps

Anonymous

#78828

Hey,
For the above solution what are all the settings has to be done on backend?
Can u please guide step by step..

Thanks in advance.

Trevor

#78839

As you have it, the visible slider is the From slider.

Well, whatever you did to lock/hide the To slider (the max value) would have to be moved over to the From (min) slider in coding.

As to the backend, open that field’s settings and find the Compare Mode select box, and change that from Input must be within the Post Meta range to Input overlaps any of the Post Meta range.

Anonymous

#79047

Trevor,
I have changed the settings as you said but still its not working fine.

When i selected “Amount of the Loan” to 43500.
It should show all the loan where Selected loan amount (43500) is between Min Loan Amount value & Max Loan Amount Value.
But now its not working that way.
Can you please check it in the below URL and give me a solution.

http://www.cybergiftindia.com/ottobanking/

Thanks

Trevor

#79058

This reply has been marked as private.

[Author]

Posts