68 replies

Counting Related Records with a Virtual Field in a Multi-Tenant app

In a multi-tenant application, when retrieving records from the database using a read action, is there a way to define a virtual field that counts the number of records in the database?

For example, something like:

calculate 
  :counter, 
  :integer, 
  expr(
    fragment(
      "SELECT COUNT(*) __TENANT_PLUS_CURRENT_TABLE__"
    )
  )

calculate 
  :counter, 
  :integer, 
  expr(
    fragment(
      "SELECT COUNT(*) __TENANT_PLUS_CURRENT_TABLE__"
    )
  )

calculate 
  :counter, 
  :integer, 
  expr(
    fragment(
      "SELECT COUNT(*) __TENANT_PLUS_CURRENT_TABLE__"
    )
  )

calculate 
  :counter, 
  :integer, 
  expr(
    fragment(
      "SELECT COUNT(*) __TENANT_PLUS_CURRENT_TABLE__"
    )
  )

Ash Framework Join

The Elixir backend framework for unparalleled productivity. Declarative tools that let you stop wasting time. Use with Phoenix LiveView or build APIs in minutes for your front-end of choice.

2,180Members

View on Discord

Resources

Recent Announcements