Retrieve all the data from database

Moralis General
#1

Hi, I am new to React and Moralis.
I am currently building a website and have run into some problems.

I want to retrieve all the data from one table. But I can’t achieve it and can’t find proper tutorials.

Here is the code:

import { useMoralis } from "react-moralis";
import { useEffect, useState } from "react";

export default function History() {
  const { Moralis } = useMoralis();

  const [histories, setHistories] = useState();

   useEffect(() => {
    async function getHistories() {
      const swapHistory = Moralis.Object.extend("SwapHistory");
      const query = new Moralis.Query(swapHistory);
      const histories = await query.find({ useMasterKey: true });
      setHistories(histories);
    }
    getHistories();
  }, []);

  return (
//  <div>looped list of histories<div/>
  );
}

This code doesnt return a desired list, it returns:

[ParseObjectSubclass]
0: ParseObjectSubclass {className: 'SwapHistory', _objCount: 2, id: 'ny63kiGSkT30U08DKL5t90vX'}
length: 1
[[Prototype]]: Array(0)

I want to show a list of all histories when I open the page, any solution would be welcome.

#2

Your code looks ok. Looks like it is returning one result. How many results should histories have?

#4

It only has 1 object, but how exactly can I get/retrieve a mutable and understandable list?

#5

If you access your histories array, you can find the data inside attributes. Log it to console and open it to see what’s available.

#6

This is what console.log(histories) looks like. Am I missing something? How to extract it?
image

#7

Click on attributes at (...). This is where you can access the data in code as well.

#8

Thank you bro, I got it. But why I have only one object there? How can I access all the entities?

#9

query.find() as you have done will fetch all. Do you have multiple objects in your SwapHistory class? How many results should histories have?