Amount range returns no results until

[sophos707]

Hey everyone,

I have a database search where I let users filter and sort data.
It’s working great.

One problem: on the “amount” range filter, nothing shows up until the users enters data.

You can see on the search here, that results (in the background) are there because I’ve entered a dramatic range in the picker:

But, on this one (the default when it loads), nothing shows up because there is nothing in the amount range.

It works fine with the text filtering (probably because there is “no” filtering out of things when no text is entered).

How do I tell Wappler that I only want to apply this filter when data is entered?
Or is there a better way?

Thanks!
Jeff

[sophos707]

Here’s what I did as a workaround, though I’d be happy to hear better ways.

I created hidden variables with values of -99999999999 and 9999999999999 that actually do the search.
Then, when a user has a “key up” action in the text input field it updates the hidden value.

Works for the moment.

[Sorry_Duh]

Filter list by all records (Form Select Problem)

In my situation when I wanted ‘all’ results I did this [Screenshot 2021-12-02 at 01.51.48] What I did was the all option was static for me so I added a value to the select with a value of ‘published’ Then when it comes to the query I have the IN function wrapped in a condition that only activates when the selects value is not ‘published’ If you need certain filters for when its on all ‘published’ in my example you could wrap this is a condition below but this time when the value is == ‘publ…

Have a look at this topic it contains groups for the query and adding a condition to the group you could apply this here and just check your variables aren’t null

[sophos707]

So great, I completely missed the filters part of the query.
THANK YOU!

[Robert_LM]

Was there a tutorial page/docs on how you setup your search pop up?

[sophos707]

I found this here:

Filtering Database Query with a Text Input

It wasn’t exactly the same, and I modified it to work in a modal, but it’s essential the same concept