Cloud function not running Unhandled Rejection (Error): query is not defined

Moralis General
#1

the cloud function

Moralis.Cloud.define("getAuctionsBids", async (request) => {
  const logger = Moralis.Cloud.getLogger();
  
  const iQuery = new Moralis.Query("ItemsForAuction");
  iQuery.equalTo("user.ethAddress",request.params.address);
  iQuery.select("auctionEndTime","uid","tokenId","floorPrice");
  let iResults = await query.find({useMasterKey:true});
  
   const bQuery = new Moralis.Query("AuctionItemBids");
  bQuery.equalTo("buyer",request.params.address);
  bQuery.select("uid","tokenId","bid");
  let bResults = await query.find();

  return iResults.concat(bResults);
});

code calling function

const loadLog = () => {
    try {
      //get users auctions and bids
      let params = { address: user.get('ethAddress') };
      Moralis.Cloud.run("getAuctionsBids", params).then((res) => {
        console.log("res : ", res);

      });


    } catch (error) {
      console.log("err: ", error);
    }
  }

Error

XHRPOSThttps://abzbji6ddzw8.usemoralis.com:2053/server/functions/getAuctionsBids
[HTTP/1.1 400 Bad Request 154ms]

Uncaught (in promise) Error: query is not defined
    Babel 2
    _createSuper ParseError.js:40
    ParseError ParseError.js:91
    handleError RESTController.js:437
    promise callback*request RESTController.js:427
    run Cloud.js:172
    run Cloud.js:98
    loadLog App.js:90
    React 14
    unstable_runWithPriority scheduler.development.js:468
    React 15
    js index.js:10
    js main.chunk.js:3480
    Webpack 7

no idea why its saying its not defined i’ve tried update/restarting server no luck

#2

Hey @PeacanDuck

You haven’t defined query in your code. You have iQuery and bQuery . So, Try this:

Moralis.Cloud.define("getAuctionsBids", async (request) => {
  const logger = Moralis.Cloud.getLogger();
  
  const iQuery = new Moralis.Query("ItemsForAuction");
  iQuery.equalTo("user.ethAddress", request.params.address);
  iQuery.select("auctionEndTime","uid","tokenId","floorPrice");
  let iResults = await iQuery.find({useMasterKey:true});
  
  const bQuery = new Moralis.Query("AuctionItemBids");
  bQuery.equalTo("buyer", request.params.address);
  bQuery.select("uid","tokenId","bid");
  let bResults = await bQuery.find({useMasterKey:true});

  return iResults.concat(bResults);
});

Let me know how it works :man_factory_worker:

1 Like
#3

ahh i see it thanks i was misunderstanding the error

2 Likes
#4

got it returning results just having an issue with iQuery it doesn’t seem to be getting anything think I’m doing the equalTo wrong the “user.ethAddress” is a pointer not sure if im referencing that right

image
image3470×144 26.1 KB

#5

Hey @PeacanDuck

Can you please clarify what information your cloud function processes?
You can use the logger in different parts of the code to check where the information is lost in the code.

const logger = Moralis.Cloud.getLogger(); 
logger.info("Hello");
1 Like
#6

i added to the select and created new data seems to be working now.

#7

Hey @PeacanDuck

Great Job :muscle: