How to dynamically set resource Id from JS?

Queries and Resources
,
1

  • Goal:
    From a JS script call a query for each element of a given array whereas the array defines the resourceId that the same SQL query should be run on.

  • Steps:

  • created all resources for my different DBs
  • in my app, created a query and clicked the fx button and pre-selected one of the DB resources.
  • created a JS script that has a const dbs = ['resource-id-here1', 'resource-id-here2', ...]
  • tried to trigger via:
.. = Promise.all(dbs.map(id => {
  query1.resourceNameOverride = id;  // seems to have no effect
  return query1.trigger();
}));

This results in resolved promise values all with the same DB being used (the one that is pre-selected).

How do I trigger the same query, but with different resource ids without having to hard-code/manually create a query for each resource/db in my app?

2

Hello @WonkyDonky Welcome to the Retool Community,

To dynamically run a query on multiple resources, create a new query instance for each resource ID instead of modifying resourceNameOverride.

const dbs = ['resource-id-here1', 'resource-id-here2', 'resource-id-here3'];

const results = await Promise.all(dbs.map(id => {
  const newQuery = new Query({ name: 'baseQuery', resource: id });
  return newQuery.trigger();
}));

console.log(results);

This ensures each query runs with the correct resource. Using Promise.all executes them in parallel. If you need sequential execution, use await inside a loop.

1 Like
3

Hi, parallel is intended. Query is not defined, in which version was it introduced? Also, I couldn't find this class in the Retool documentation, do you have the link handy?

4

Couldn't find an edit button

In case you meant the actual query, if I use new query1() it says, that it's not a constructor