pliant remnant Nov 1, 2023, 5:48 AM

#

I am creating a discord bot and I want to fetch all the data from the document, how would I do so?

#

For example:

#


_id
6541db76eb05fd997758dafd
Guild
"1165337640288145549"
Category
"1169138910589370368"
Handlers
"1167654090189324348"
Logging
"1169138911705055272"
__v
0

#

I want to get all this data

#

But I don't want it as a JSON

#

Because I'm using discord.js

fallen socket Nov 1, 2023, 12:38 PM

#

You have to receive the data somehow, so Mongo will send it as a string using JSON. Once you have the JSON data you can parse and store it as an object you can use in your actual code. https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/JSON/parse

pliant remnant Nov 1, 2023, 1:25 PM

#

Okay thank you

pliant remnant Nov 1, 2023, 4:09 PM

#

fallen socket You have to receive the data somehow, so Mongo will send it as a string using J...

I get an error

#

Unexpected token _ in JSON at position 4

pliant remnant Nov 1, 2023, 4:10 PM

#

pliant remnant ```json _id 6541db76eb05fd997758dafd Guild "1165337640288145549" Category "1169...

I think it's talking about _id or __v

#

@fallen socket

fallen socket Nov 1, 2023, 5:04 PM

#

pliant remnant I think it's talking about _id or __v

Oh, I think Mongo actually does returns the data as an object. You don't need json parse. You should be able to access whatever you get from Mongo directly in your code or through the Discord.js helper functions.

pliant remnant Nov 1, 2023, 5:05 PM

#

But when I try to do

Setup.find({ Guild: interaction.guild.id }).then((result) => { console.log(result) });

#

It returns as a JSON

fallen socket Nov 1, 2023, 5:06 PM

#

What do you want it to be?

pliant remnant Nov 1, 2023, 5:07 PM

#

I want to fetch the data, for example Handlers is a role ID;
Then I make a variable with that role id that I fetched from the document and then use it in the message;
Example:

const HandlerRole = // Get the "Handlers" value from the DB
interaction.reply({ content: `Current Handler Role: <@${HandlerRole}>` });

#

@fallen socket

fallen socket Nov 1, 2023, 5:10 PM

#

pliant remnant But when I try to do ```js Setup.find({ Guild: interaction.guild.id }).then((re...

So this looks like its targeting the whole guild so it will return an array of objects right?

pliant remnant Nov 1, 2023, 5:11 PM

#

Yea of that Guild

fallen socket Nov 1, 2023, 5:12 PM

#

But the guild in discord is the whole server so every member right?

#

or is guild a key that you added for your bot to track? (is guild being used in your app for something other than what Discord calls a guild?)

pliant remnant Nov 1, 2023, 5:19 PM

#

fallen socket But the guild in discord is the whole server so every member right?

Yes

pliant remnant Nov 1, 2023, 5:19 PM

#

pliant remnant ```json _id 6541db76eb05fd997758dafd Guild "1165337640288145549" Category "1169...

The Guild is the guild id, the category is a category id, the handlers is a helper role id, the logging is a channel id

fallen socket Nov 1, 2023, 5:21 PM

#

pliant remnant The Guild is the guild id, the category is a category id, the handlers is a help...

would it not just be const HandlerRole = result.handlers; ?

pliant remnant Nov 1, 2023, 5:22 PM

#

So if I do result.Handlers it'll return the role Id only? And if I do result.Logging it'll return the logging channel?

pliant remnant Nov 1, 2023, 5:23 PM

#

fallen socket would it not just be `const HandlerRole = result.handlers;` ?

I tried console.logging the HandlerRole, it returns as undefined

#

    Setup.find({ Guild: interaction.guild.id }).then((result) => {
      const HandlerRole = result.Handlers;

      console.log(HandlerRole);
    });

fallen socket Nov 1, 2023, 5:25 PM

#

oh weird. are you available to come into one of the Voice chats and share screen?

pliant remnant Nov 1, 2023, 5:25 PM

#

Yes but I won't be able to talk

fallen socket Nov 1, 2023, 5:26 PM

#

pliant remnant Yes but I won't be able to talk

hmm that might be fine I'm in #735946723016442008

pliant remnant Nov 1, 2023, 5:28 PM

#

Ok thank you

fallen socket Nov 1, 2023, 5:29 PM

#

No problem 👍

pliant remnant Nov 1, 2023, 5:31 PM

#

How would I make it so it's not inside of a .then

#

Because I can't use that variable outside of the .then

#

@fallen socket

#

const {
  SlashCommandBuilder,
  ChatInputCommandInteraction,
  EmbedBuilder,
  Client,
  PermissionFlagsBits,
  ButtonBuilder,
} = require("discord.js");

// ! Schemas !
const Setup = require("../../Base/Schemas/SetupData");

module.exports = {
  data: new SlashCommandBuilder()
    .setName("panel")
    .setDescription("Enable, Disable, or Configure bot settings")
    .setDMPermission(false)
    .setDefaultMemberPermissions(PermissionFlagsBits.Administrator),
  /**
   *
   * @param {ChatInputCommandInteraction} interaction
   * @param {Client} client
   */
  async execute(interaction, client) {
    const { guild } = interaction;

    // ! Getting Data !
    // const modmailData = await Setup.findOne({
    //   Guild: interaction.guild.id,
    // });
    Setup.find({ Guild: interaction.guild.id }).then((result) => {
      const HandlerRole = result[0].Handlers;
    });

    const mainPanel = new EmbedBuilder()
      .setTitle("System Panel")
      .setDescription(`${HandlerRole}`)
      .setColor("Blue");

    // ! Buttons !
    const modmailButton = new ButtonBuilder();
  },
};

fallen socket Nov 1, 2023, 5:40 PM

#

pliant remnant Because I can't use that variable outside of the .then

You are declaring HandlerRole as a const inside your then. but you can declare it as a let outside of the then and then update it inside the then

#

either that or ...

pliant remnant Nov 1, 2023, 5:41 PM

#

My brain is not braining

fallen socket Nov 1, 2023, 5:41 PM

#

😆 happens to all of us, take a five minute break and a walk

pliant remnant Nov 1, 2023, 5:42 PM

#

I don't understand what you said

fallen socket Nov 1, 2023, 5:42 PM

#

const HandlerRole = Setup.find({ Guild: interaction.guild.id }).then((result) => {
  return result.Handlers;
});

#

👆 thats one way to do it

pliant remnant Nov 1, 2023, 5:42 PM

#

Ok let me try it

fallen socket Nov 1, 2023, 5:43 PM

#

the other way is

let HandlerRole
Setup.find({ Guild: interaction.guild.id }).then((result) => {
  HandlerRole = result[0].Handlers;
});

#

might need some adjusting if i messed up the syntax but either one of those should work

pliant remnant Nov 1, 2023, 5:43 PM

#

    const HandlerRole = Setup.find({ Guild: interaction.guild.id }).then(
      (result) => {
        return result[0].Handlers;
      }
    );

    const mainPanel = new EmbedBuilder()
      .setTitle("System Panel")
      .setDescription(`${HandlerRole}`)
      .setColor("Blue");

Returns: [object Promise]

fallen socket Nov 1, 2023, 5:44 PM

#

oh true its returning the promise... the second way should work?

pliant remnant Nov 1, 2023, 5:45 PM

#

Returns as undefined

#

Actually wait one sec

fallen socket Nov 1, 2023, 5:45 PM

#

it will take a second

#

because it will start as undefined until it gets the result from Mongo

pliant remnant Nov 1, 2023, 5:46 PM

#

If I console.log it it turns the ID in the console

#

But in the Embed it's undefined

#

    let HandlerRole;
    Setup.find({ Guild: interaction.guild.id }).then((result) => {
      HandlerRole = result[0].Handlers;
      console.log(HandlerRole);
    });

    const mainPanel = new EmbedBuilder()
      .setTitle("System Panel")
      .setDescription(`<@${HandlerRole}>`)
      .setColor("Blue");

fallen socket Nov 1, 2023, 5:48 PM

#

thats because EmbedBuilder is being run while you are still waiting on the result of the promise.

pliant remnant Nov 1, 2023, 5:48 PM

#

So how would I fix that?

fallen socket Nov 1, 2023, 5:48 PM

#

good question 😆

#

you might have to move it inside that then or call it from inside the then

pliant remnant Nov 1, 2023, 5:52 PM

#

Ok I put it inside the .then now it works

#

Thanks a lot

#

So I can't put anything after the find?

fallen socket Nov 1, 2023, 5:56 PM

#

if anything depends on the values inside the promise you will have to find a way to get them. There might be a better way to structure it, but I don't know how at the moment.

pliant remnant Nov 1, 2023, 6:01 PM

#

What if I don't have any data?

#

    Setup.find({ Guild: interaction.guild.id }).then((result) => {
      const mainPanel = new EmbedBuilder();
      if (!result) {
        mainPanel.setDescription("No Data was found");
        HandlerRole = "No Data was found";
      } else {
        HandlerRole = result[0].Handlers;
        mainPanel
          .setTitle("System Panel")
          .setDescription(`<@&${HandlerRole}>`)
          .setColor("Blue");
      }
      console.log(HandlerRole);

      interaction.reply({ embeds: [mainPanel], components: [menu] });
    });

#

This doesn't work

#

TypeError: Cannot read properties of undefined (reading 'Handlers')
    at C:\Users\1dxy\Desktop\RevoMail\Commands\Utilities\Panel.js:50:33
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)

#

Line 50 is ```js
HandlerRole = result[0].Handlers;

#

@fallen socket

#

I'm going to go for now, let mem know how I can fix this ^

pliant remnant Nov 2, 2023, 12:52 AM

#

Fixed it blobparty

fallen socket Nov 2, 2023, 2:49 PM

#

💪 Let's go!

#How to fetch all data from MongoDB database document

Returns: [object Promise]