Find a match in your database

Ask the community
,
1

Hi, could someone help with my query. When the user fills in a word and click search, the query should search for a identical match in the database. I already tried several options but they all failed. When succeeded, the user should see a message “OK”, when not succeeded, they should see a message “Nothing found”.

This is my code, I tried several alternatives but they all failed. Thanks in advance for the help.

iboxcode: name of the input box
Boxcodes: name of the database
title: name of the colomn where the query has to search
resultbox: the text box that should contain the message for the user

import wixData from “wix-data”;

export function Claim(event) {
wixData.query(“Boxcodes”)
.eq(“title”, $w(“#iboxcode”).value)
.find()
.then(res => {
$w(“#resultbox”).value = res.items;
});
}

2

Levi, Javascript/Wix Code is case-sensitive. I’m wondering if the collection “Boxcodes” is actually lower case “boxcodes”. A query will return nothing, even when it seemingly should, if that is not correct.

3

How to do a case insentive eq in database

4

@mobiletracerapp Use .contains

wixData.query("yourDataset")
.contains("field", "text")
.find()
.then( (results) => {
    //whatever you want to do with the results here
})

this example query would search my database “yourDataset” for any string matching text (not case sensitive so TEXT, TeXt, etc will all match including TEXTING or any results that includes the word “text”) in the field “field”.

Hope that helps!

5

@anneynorton7 No this is a bad approach it ll match anything that contains , i want only exact insensitive match

6

Hey, try this → 

wixData.query("Boxcodes")
  .eq("title", $w("#iboxcode").value)
  .find()
  .then( (results) => {
    if(results.items.length > 0) {
      let items = results.items[0];
        $w("#resultbox").value = items;
    
    } else {
      // handle case where no matching items found
    }
 } )

(Matching strings with eq() is case sensitive, so “text” is not equal to “Text”.)

7

If that doesn’t work, do this - >

wixData.query("Boxcodes")
  .eq("title", $w("#iboxcode").value)
  .find()
  .then( (results) => {
    if(results.items.length > 0) {
      let item = results.items[0];
        $w("#resultbox").value = JSON.stringify(items);
    
    } else {
      // handle case where no matching items found
    }
 } )

(Matching strings with eq() is case sensitive, so “text” is not equal to “Text”.)

8

CAN WE DO THOSE WITH .EQ FOR BOTH UPPER AND LOWER CASE?
I DONT WANT TO USE .CONTAINS
THX