ge, le, between function problem

Ask the community
,
1

im trying to use this function, i have values between 3,000 - 5,500,000, and it seems that
the system can not distinguish between differences in the number of zeros. For example, if I have an item with a value of 12,000 and I put the search values ​​between 3,000-15,000, no results appear, but if I enter the 10,000 - 15,000 values I will see the result I am looking for(12,000) . The same thing happens if I put in the 1,000,000 - 1,500,000 values, I have an item of 1,300,000 and the search shows a result of the 12,000 item.
this is my search code :

export function search () {

let nDataV = wixData.query(‘apartments’);

   nDataV.contains('name', $w("#searchBar").value) 
    .or(nDataV.contains('nighberhood', $w("#searchBar").value)) 
    .and(nDataV.contains('typeSOrR', $w("#typeBar2").value)) 
    .and(nDataV.contains('type', $w("#typeBar").value))

//// Neither ge, le or between works

    .between('price1', $w("#minPrice").value, $w("#maxPrice").value)

//( .and(nDataV.ge(‘price1’, $w(“#minPrice”).value))
// .and(nDataV.le(‘price1’, $w(“#maxPrice”).value))
.and(nDataV.ge(‘rooms1’, $w(“#minRooms”).value))
.and(nDataV.le(‘rooms1’, $w(“#maxRooms”).value))
.and(nDataV.ge(‘floor1’, $w(“#minFloor”).value))
.and(nDataV.le(‘floor1’, $w(“#maxFloor”).value))

    .find() 

    .then(res => { 

    $w('#repeater1').data = res.items

if (res !== null ) {

        $w("#repeater1").expand(); 


    }}); 

    }
2

Make sure the field type in your database is number and not text.
Make sure the values in your query are numbers and not strings.

3

But if i need to mix text and number values?
On my database the field is number

4

if you search for a value in a field of type number, the query value should be number as well. It doesn’t make sense to look for a string there.

5

But there is alot of search in different sites that use number and text, can i create 2 different query and combin there data to create one combin condition?

6

Please add more details re what exactly you’re trying to do.

7

I have a search function with text input (word typing) dropdown( numbers but text type) and i only need to combine “price” input.
I did a condition with “.and” between each condition and then results to a repetear data

8

Sorry. I’m still not sure what you’re trying to do.
can you add examples for search terms + where you are going to look for the results in your collection?

9

It’s a real estate site, this is the fields:

  1. Name
  2. Type of property (dropdown of text)
  3. Type of transition (dropdown of text)
  4. Number of rooms (dropdown of text number)
  5. umber of floor ( dropdown of text number)
    6.price ( here is the problem)

And thank you very much for helping!!!

10

and what about the search pane?

11
  • what is “text number”?
12

I think, i kind of noob on coding, but the values are number and i think it becoming text

13

Sry but what is pane?

14

So you can change them into numbers like this:

Number($w("#maxPrice").value)
15
  • I don’t think you’re using the and-or correctly.