#✅ Custom SQL queries

6 messages · Page 1 of 1 (latest)

foggy panther
#

If I wanted to run custom SQL queries through Directus would I have to use the JavaScript SDK and create a custom API endpoint?

deep juniperBOT
#

Thanks for posting! This is a community powered server, so you may or may not get an answer based on available help and expertise. To increase your chances of somebody being able to help you, please make sure your question includes the following:

  • An explanation of exactly what you're trying to achieve.
  • Any and all related code or previous attempts.
  • The exact issue or error you are facing.
  • Any screenshots if applicable.

When you're done with this thread, please close it.

(If you have a support agreement and need help, please contact the core team via email.)

storm drift
#

Running custom SQL is only possible using Custom Endpoints or Custom Hooks at this time

deep juniperBOT
#

✅ Custom SQL queries

deep juniperBOT
boreal flame
#

Is there an example of how you would use Custom Endpoints or Hooks for something like the List panel inside an Insights Dashboard?

I am trying to create a List of all Accounts with the count of number of Profiles associated with it. format: <id>, <account>, <profile>, ...