alan Comments - Answer Overflow

alan

•Created by alan on 11/14/2023 in #djs-questions

Refresh autocomplete options with that's dependent on the other parameter

if (interaction.commandName === 'preset') {
                    // const selectedUser = interaction.options.get('user').value ? interaction.options.get('user').value : interaction.user.id;
                    //var selectedUser = '162955183670820864';
                    try {
                        selectedUser = interaction.options.get('user').value;
                    } catch {
                        selectedUser = interaction.user.id;
                    }
                    var preset = await sequelize.query(`SELECT \`id\`, \`name\` FROM \`Presets\` WHERE userID = ?`, { replacements: [selectedUser], type: QueryTypes.SELECT });
                    const focusedValue = interaction.options.getFocused();
                    const filtered = preset.filter(choice => choice.name.includes(focusedValue));
                    await interaction.respond(
                        filtered.map(choice => ({ name: choice.name, value: choice.id })),
                    ).catch(console.err);
                }

if (interaction.commandName === 'preset') {
                    // const selectedUser = interaction.options.get('user').value ? interaction.options.get('user').value : interaction.user.id;
                    //var selectedUser = '162955183670820864';
                    try {
                        selectedUser = interaction.options.get('user').value;
                    } catch {
                        selectedUser = interaction.user.id;
                    }
                    var preset = await sequelize.query(`SELECT \`id\`, \`name\` FROM \`Presets\` WHERE userID = ?`, { replacements: [selectedUser], type: QueryTypes.SELECT });
                    const focusedValue = interaction.options.getFocused();
                    const filtered = preset.filter(choice => choice.name.includes(focusedValue));
                    await interaction.respond(
                        filtered.map(choice => ({ name: choice.name, value: choice.id })),
                    ).catch(console.err);
                }