[SOLVED] Receiving empty array of results when trying to fetch data from the user table

Moralis General
#1

Question, when using the include, it works perfectly for all the linked tables except for the user table, i am testing it separately :

`const query = new Moralis.Query("ListedItems");`
 `query.include("user.username");` 
`const queryResults = await query.find({userMasterKey:true});`

but the results are empty, i have tried

`query.include("User.username");` 
`query.include("_user.username");`
 `query.include("_User.username");`

but none worked any advice?

#2

did you try also query.include('user'); query.include('user.username')?

#3

yes i did try that and i also tried only

query.include('user');

and also returned empty array

#4

query.select("user") still nothing?

#5

yes also nothing empty results

#6

Ok, I’ll test it too

1 Like
#7

It looks like this returns me all user data:

Moralis.Cloud.define("test_user_pointer",  async (request) => {
   const query = new Moralis.Query("_Session");
   query.include("user")
   query.select("sessionToken", "user")
   x = await query.find({useMasterKey:true});
   return x;   
});
How to use query.include
Can you query.equalto the same value of the pointer?
#8 
 const query = new Moralis.Query("ListedItems");
   query.include("user")
   query.select("askingPrice", "user")
   let res = await query.find({useMasterKey:true});
   return {
   	"user": res.user,
    "price" : res.askingPrice,
   };

i used the same syntax and still got nothing, i might be doing something wrong…
this is a log of the results also

image
image1028×357 12.1 KB

#9

What you see for this:

   const query = new Moralis.Query("ListedItems");
   query.include("user")
   query.select("askingPrice", "user")
   let res = await query.find({useMasterKey:true});
   logger.info(JSON.stringify(res));
1 Like
#10

1- i deleted all the rows that were created before linking the user table
2- i ran the JSON.stringify(res) and everything worked smoothly