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?
did you try also query.include('user'); query.include('user.username')?
yes i did try that and i also tried only
query.include('user');
and also returned empty array
query.select("user") still nothing?
yes also nothing empty results
Ok, I’ll test it too
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;
});
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
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- i deleted all the rows that were created before linking the user table
2- i ran the JSON.stringify(res) and everything worked smoothly