How to query objects like javascripts includes?

Moralis General
#1

How can I query the database using Moralis.Query to find objects where a column contains a certain string?

For Example

Object Name Anthony

I want to query all objects where the name includes “thony”. How would I do that?

#2

You can do that with equalTo method.
In the below code ownerName is column name and Aegon is the string which you want to filter.

const query = new Moralis.Query("ClassName");
query.equalTo("ownerName", "Aegon");

Check more on query methods at : https://docs.moralis.io/moralis-dapp/database/queries#basic-queries

1 Like
#3

Thats not like javascripts include, equalTo is equivalent of “===”. What I am looking for is equivalent for .includes() as I stated above. I want to get results if the value contains a substring.

Like if the value would be “apple” and I want to query that with "query.includes(“pple”).

#4

ohh ok. Try it with .fullText method. This looks for that partial string to search

See the example in the below doc.
https://docs.moralis.io/moralis-dapp/database/queries#full-text-search

#5

I tried that before but it is not giving me any results even tho when I filter inside the browser with string contains string, it gives results for my input values.

if (this.searchForWallet.length > 0) {
        console.log("searchForWallet", this.searchForWallet.toString())
        query.fullText("address", this.searchForWallet)
      }

image
image1595×407 87.3 KB
image

#6

There is a forum post where it says how to search with ignore case. It is a different method, I don’t remember it now.

#7

the address field is always stored lowercase in my database and I am testing it with the value of “84” which isnt case sensitive since its a number tho

#8

I just tried using “query.matches” and that seems to work. Not sure why matches works and then why there is a fullText. Seems to be solved for my case now but still needs clarification for why fullText doesnt work or what that is for then if we have matches

1 Like
#9

It looks like .fullText is looking for word in a sentence/multiple words rather than part of the string.

#10

Yea that ll probably be it. I checked the documentation again, “matches” is not mentioned in the docs, maybe you guys should add it. I only found matchesInQuery and matchesInKey which do different things