Backend database query

Ask the community
,
1

I am trying to query a database using a function i have written in the backend. Essentially i am searching a database to see if a variable name already exists in the database. However i can not get the code to work, any idea where i am going wrong ?

Backend Code:

import wixData from “wix-data”;

export function queryUsernameDatabase(variableName){
wixData.query(“name_DB”)

            .eq("name", (variableName)) 
            .limit(1000) 
            .find()

}

Frontend Code:

import wixData from “wix-data”;
import {queryUsernameDatabase} from ‘backend/signup’;

$w(‘#button1’).onClick(() => {

let variableName = ($w(‘#nameInput’).value);

queryUsernameDatabase()

.then((results) => {
let namePreviouslyRegistered = results.totalCount;
console.log(namePreviouslyRegistered);

})

2

You are not passing the variable name to the function. You need something like this:

let variableName =  ($w('#nameInput').value);
queryUsernameDatabase(variableName);

I hope this helps.

3

@ Yisrael
Thank you, sorted it